Print

[DefenceTalk.com]

hi,

i am getting this error after i updated permission on # of albums in the gallery be accessible only by me...

While 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

[Casper]

You have repeated the word 'and' in the query, as your code actually says ;

Code: [Select]

WHERE category = '0' and AND a.aid NOT
Remove that and it should work

[DefenceTalk.com]

thanks!

remove from which file?

[Casper]

Did you modify any code?

Search for this in there.

[DefenceTalk.com]

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

[Casper]

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.

[DefenceTalk.com]

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.

[Nibbler]

OK, tracked the error. Try the updated version of the mod, should be named anycontent.3.php.txt