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.27
change DB IP storage fields to accommodate IPv6 addresses
remove use of E_STRICT (PHP 8.4 deprecated)
update README to reflect new website
align code with new .com CPG website
correct deprecation in captcha

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.