error processing a database query :: Users

[LuthienMoss]

I hope I am posting in the right forum.

Whn I try to access my user list through my CP I get this:
Critical error
There was an error while processing a database query


I have no idea why,it's been so for a long time now

[Nibbler]

Search the board before posting...

Enable debug mode in config and then go back to the users page to get the detailed error message.

[LuthienMoss]

Code Select Expand

While executing query "SELECT user_id as user_id, user_name as user_name, user_email as user_email, UNIX_TIMESTAMP(user_regdate) as user_regdate, UNIX_TIMESTAMP(user_lastvisit) as user_lastvisit, user_active as user_active, COUNT(pid) as pic_count, ROUND(SUM(total_filesize)/1024) as disk_usage, group_name, group_quota FROM `web77-gallery-4`.cpg1411_users AS u INNER JOIN cpg1411_usergroups AS g ON u.user_group = g.group_id LEFT JOIN cpg1411_pictures AS p ON p.owner_id = u.user_id GROUP BY user_id ORDER BY user_regdate DESC LIMIT 0, 25;" on Resource id #5

mySQL error: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay

[Nibbler]

Search the board before posting...

http://forum.coppermine-gallery.net/index.php?topic=34789.0