hi,
i am getting this error after i updated permission on # of albums in the gallery be accessible only by me...
QuoteWhile executing query "SELECT count(*) FROM cpg11d_albums as a WHERE category = '0' and AND a.aid NOT IN (40,41,43,235,318,319,320,321,322,323,324,325,451,454,455,456,457,458,487,488,489,490,491,492,493,494,495) " 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 'AND a.aid NOT IN (40,41,43,235,318,319,320,321,322,323,324,325,
after i login, the main page displays fine but when i log out it says
There was an error while processing a database query.
please help
thank u
You have repeated the word 'and' in the query, as your code actually says ;
WHERE category = '0' and AND a.aid NOT
Remove that and it should work
thanks!
remove from which file?
Did you modify any code?
Search for this in there.
no i did not change any code...
all i did was updated the permissions on album (see attached image)... to ME ONLY and thats when error appeared
If you have made no changes to your code whatever, then all I can suggest is replacing all your files with fresh cpoies, and see if that cures it.
okay, this is whats causing the problem
http://forum.coppermine-gallery.net/index.php?topic=9540.0
when i enable that anycontent, the error appears and when it take it off - it disappears and no errors.
OK, tracked the error. Try the updated version of the mod, should be named anycontent.3.php.txt