Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: upgrade error 1.5.2 > 1.5.22  (Read 37857 times)

0 Members and 1 Guest are viewing this topic.

zolim

  • Coppermine newbie
  • Offline Offline
  • Posts: 4
upgrade error 1.5.2 > 1.5.22
« on: January 13, 2013, 09:51:14 am »

"Critical error, could not connet to database!" I have tired two different computer after upgraded 1520 to 1522.
Logged

phill104

  • Administrator
  • Coppermine addict
  • *****
  • Country: gb
  • Offline Offline
  • Gender: Male
  • Posts: 4885
    • Windsurf.me
Re: upgrade error 1.5.2 > 1.5.22
« Reply #1 on: January 13, 2013, 12:45:47 pm »

Please check the details in your include/config.inc.php file are correct.
Logged
It is a mistake to think you can solve any major problems just with potatoes.

zolim

  • Coppermine newbie
  • Offline Offline
  • Posts: 4
Re: upgrade error 1.5.2 > 1.5.22
« Reply #2 on: January 14, 2013, 06:32:40 pm »

I have found them:

While executing query 'SELECT a.aid, a.title, a.description, a.thumb, a.keyword, category, visibility, filepath, filename, url_prefix, pwidth, pheight, a.owner  FROM cpg15x_albums AS a  LEFT JOIN cpg15x_pictures AS p ON a.thumb=p.pid  WHERE a.category = 0   ORDER BY   LIMIT 0,2' in index.php on line 795 the following error was encountered:

While executing query 'SELECT a.aid, count( p.pid ) AS pic_count, max( p.pid ) AS last_pid, max( p.ctime ) AS last_upload, a.keyword, a.alb_hits FROM cpg15x_albums AS a  LEFT JOIN cpg15x_pictures AS p ON a.aid = p.aid AND p.approved = 'YES'  WHERE a.category = 0  GROUP BY a.aid  ORDER BY   LIMIT 0,2' in index.php on line 805 the following error was encountered:
A sytactic error near 'LIMIT 0,2'

When I removed "ORDER BY $sort_order" from sql, CPG is runing.
Logged

zolim

  • Coppermine newbie
  • Offline Offline
  • Posts: 4
Re: upgrade error 1.5.2 > 1.5.22
« Reply #3 on: January 14, 2013, 06:45:01 pm »

I have not found, $CONFIG['album_sort_order'] variable.
$sort_order = $sort_array[$CONFIG['album_sort_order']]

So $sort_order is empty.
Logged

zolim

  • Coppermine newbie
  • Offline Offline
  • Posts: 4
Re: upgrade error 1.5.2 > 1.5.22
« Reply #4 on: January 14, 2013, 07:16:34 pm »

 >:( My update.php was fault. I downloaded again, so cpg already run. :D

I close this topic.
Logged

Montezuma

  • Coppermine novice
  • *
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 41
Re: upgrade error 1.5.2 > 1.5.22
« Reply #5 on: January 14, 2013, 08:54:08 pm »

I'm getting the same error after updating.  What exactly did you do to fix this?
Logged

Montezuma

  • Coppermine novice
  • *
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 41
Re: upgrade error 1.5.2 > 1.5.22
« Reply #6 on: January 14, 2013, 08:58:00 pm »

Got it.  Ran "update database" and now it seems to work.
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: upgrade error 1.5.2 > 1.5.22
« Reply #7 on: January 18, 2013, 05:15:33 pm »

Everyone with the same issue: please read the upgrade docs carefully:
Quote from: Run the update script
To run the PHP-file "update.php" (i.e. the update script), just enter the URL into the address bar of your browser. The file "update.php" resides in the coppermine directory, so to run it you will need to point your browser to http://yourdomain.tld/your_coppermine_folder/update.php (if you have installed Coppermine into the root of your web site, you will have to run http://yourdomain.tld/update.php accordingly). This will update your coppermine install by making all necessary changes in the database.


Marking thread as solved.
Logged
Pages: [1]   Go Up
 

Page created in 0.024 seconds with 20 queries.