1.5.46 Users can't create albums, Critical Error

[wbeddoe]

When a User tries to create an album, it results in a critical error:

While executing query 'SELECT aid, title FROM cpg15x_albums WHERE category =  AND owner = 3312 ORDER BY pos ASC' in albmgr.php on line 154

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 'AND owner = 3312 ORDER BY pos ASC' at line 1

Running V1.5.46
Thank you!

[phill104]

Has your host upgraded to PHP 7? I am guessing that is the case. If so an upgrade to CPG 6.x will do the trick

[wbeddoe]

Thanks for the feedback. Will upgrade to v6 ASAP.

[wbeddoe]

When is that release going to be available?

[ron4mac]

CPG 1.6.x (currently 1.6.04) is available now.
http://forum.coppermine-gallery.net/index.php/topic,79013.0.html

But I don't believe that has anything to do with your problem. It looks to me like there is an issue with your database (categories table).
Perhaps you could provide a test user account or some way for us to investigate the issue in more depth so we may possibly come up with a solution.

[ Thank you for your service. ]

[wbeddoe]

How can I send you account login details? Will try to DM.

And thank you..

[ron4mac]

There may indeed be some logic problem that was causing that critical error. But configuring the 'registered' user group to be able to have personal albums removed the error condition. At this point we would prefer to concentrate on any issues found with CPG 1.6.x rather than making changes to 1.5.x that would require a new release.

If you upgrade to CPG 1.6.x, uninstall your plugins first ... you are using a couple that are not compatible with CPG 1.6.x. Let us know which of those plugins you can't live without and we'll see if we can get them updated for CPG 1.6.x.

[edit]
And, unfortunately, your theme will have a compatibility issue with CPG 1.6.x, as well (a simple fix, though). Unless your host is getting ready to move to PHP 7.x, you could stay with CPG 1.5.46 until that may happen.

[wbeddoe]

Awesome; thank you very much for the prompt response and solution.