I upgraded my gallery from 1.4.23 to 1.4.25 and can no longer access it at all. It gives me a "Critical error: There was an error while processing a database query." message. I turned debug mode on via phpMyAdmin and received this message:
QuoteWhile executing query "SELECT count(*) FROM WHERE owner=2" 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 'WHERE owner=2' at line 1
File: [..]/include/functions.inc.php - Line: 248
Searching the docs and board have failed to turn up anything that looks similar. URL is http://ihwmedia.net/index.php. Thanks!
works as expected for me ???
I'm still getting the same error - perhaps because I'm still logged in from before I performed the update?
Clear your cookies then.
I did, and when I log in again I get the same error.
Clear your browsers cache. Your site works well for me.
It works fine for me as well, however the problem seems to persist upon Admin login. Does the issue remain using a guest or another login? Can anyone else log in?
Also, if you use any thrid-party cleaning applications, such as "CCleaner" for example, you will need to manually delete the cookie yourself, or remove the cookie from the "protected" list. Clearing the cache will not delete these cookies.
Must be related to some mod you have applied (Stramm's modpack maybe) since that query is not a normal part of Coppermine. Remember to fully reapply mods after updating Coppermine.
Great! I didn't think I had the mod pack enabled, but reuploaded and upgraded anyway to check and it's now working. Thanks!