even while im logged in as admin, i cant see the user list from the admin mode, when i click, it says *critical error* "There was an error while processing a database query ". my logged in users also unable to view the user list.
Enable debug mode and post the actual error
There was an error while processing a database query.
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 `fotovagu_copper`.cpg149_users AS u INNER JOIN cpg149_usergroups AS g ON u.user_group = g.group_id LEFT JOIN cpg149_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 #6
mySQL error: Got error 12 from table handler
i guess this a hosting related issue. sometimes i can view the user list from the admin mode and user mode.
here is what I found about your error message:
The error is caused by the server not having enough disk space for MySQL to perform the action.
So you need to ask your host for support
yes. that was a hoting/server side issue, and its fixed now. thanx :)