coppermine-gallery.com/forum

Support => cpg1.3.x Support => Older/other versions => cpg1.3 Installation & Setup => Topic started by: boylan on September 10, 2004, 03:28:40 AM

Title: Trouble with upgrade (1.2.1 to 1.3.2 w/PHPbb bridge)
Post by: boylan on September 10, 2004, 03:28:40 AM
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
Title: Re: Trouble with upgrade (1.2.1 to 1.3.2 w/PHPbb bridge)
Post by: boylan on September 10, 2004, 03:49:19 AM
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