Error for non-registered users viewing album list

[nanothree]

If i logout when i try to view all teh albums i get this error:
There was an error while processing a database query

if i login i can see them though
the url is http://www.rockthoselocks.com/Gallery/index.php?cat=1

[Joachim Müller]

enable debug_mode in coppermine config to see what query actually fails. If you can't go to the config screen, use a tool like phpMyAdmin, browse the coppermine config table and set debug_mode to "1". Post the error message here.

Joachim

[nanothree]

sorry about the delay, i never got the notification this is what comes up when i enable debig mode

While executing query "SELECT user_id,      user_name,      COUNT(DISTINCT a.aid) as alb_count,      COUNT(DISTINCT pid) as pic_count,      MAX(pid) as thumb_pid FROM cpg11d_users AS u INNER JOIN cpg11d_albums AS a ON category = 10000 + user_id INNER JOIN cpg11d_pictures AS p ON p.aid = a.aid WHERE approved = 'YES' p.aid NOT IN (37,70,76,113)  GROUP BY user_id ORDER BY user_name " 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 'p.aid NOT IN (37,70,76,113)  GROUP BY user_id ORDER BY user_nam

[nanothree]

I posted this a while ago but, probably due to my bad memory, it has just sort have been forgotten, When a non registered user tries to view all the albums ithey get this error:

There was an error while processing a database query.

So i turned on debug mode las requested in the old topic and this came up:

While executing query "SELECT user_id,      user_name,      COUNT(DISTINCT a.aid) as alb_count,      COUNT(DISTINCT pid) as pic_count,      MAX(pid) as thumb_pid FROM cpg11d_users AS u INNER JOIN cpg11d_albums AS a ON category = 10000 + user_id INNER JOIN cpg11d_pictures AS p ON p.aid = a.aid WHERE approved = 'YES' p.aid NOT IN (37,70,76,113)  GROUP BY user_id ORDER BY user_name " 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 'p.aid NOT IN (37,70,76,113)  GROUP BY user_id ORDER BY user_nam
and this:

File: /home/liam/public_html/Gallery/include/functions.inc.php - Line: 105

[Tranz]

If you can't remember where you posted something, click on the profile button that will show your account info. Click on Show Posts to show all that you have posted. That will prevent you from creating a duplicate thread, which is a big no-no.

I have merged the threads.

[nanothree]

sorry  , can any one help?

[nanothree]

Its ok i have fixed it, i just uploaded the index file again, i must have messed it up