Trouble with upgrade (1.2.1 to 1.3.2 w/PHPbb bridge) Trouble with upgrade (1.2.1 to 1.3.2 w/PHPbb bridge)
 

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

Main Menu

Trouble with upgrade (1.2.1 to 1.3.2 w/PHPbb bridge)

Started by boylan, September 10, 2004, 03:28:40 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

boylan

Not sure if this is the right place to post this (should it be in BBS Integration?), but I had a fully functional Coppermine/PHPbb bridge working.  I upgraded to 1.3.2 following the documentation, and everything looked fine at first.  The album list page works fine, but when viewing the thumbnails in an album, or any individual picture, I get a database error.

I have debugging turned on, so you can view the error messages on different pages at http://www.chrisboylan.com/coppermine/.  When you clcik on an album, you get this error message:

While executing query "SELECT pid, filepath, filename, url_prefix, filesize, pwidth, pheight, ctime, aid, title, caption,hits,owner_id,owner_name from cpg11d_pictures WHERE aid='5'  AND approved='YES'  ORDER BY   LIMIT 0 ,12" on 0

mySQL error: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 0 ,12' at line 1


Any suggestions?

Thanks,

Chris
Chris Boylan: the webpage.  It will never be finished.

boylan

Well, nevermind....

I changed a few settings on the config page, unrelated to anything (display EXIF info), and then the problem fixed itself.  I'm guessing the bridge didn't take when I hit groups the first time.  But it works, so - oh, well.

Thanks for the great work.  I love it!

Chris
Chris Boylan: the webpage.  It will never be finished.