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 :(
Search the board before posting...
Enable debug mode in config and then go back to the users page to get the detailed error message.
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
Search the board before posting...
http://forum.coppermine-gallery.net/index.php?topic=34789.0