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:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

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.