Aww. Alright, so here's the deal. I previously upgraded from 1.3.5 to 1.4.8 (I'm not sure if this should be here or in the "cpg 1.4 upgrading" forum - I apologize if this thread is miscategorized). When I was running 1.3.5 I, out of nowhere ran into a Critical error when trying to access usermgr.php, which is much similar - if not identical - to the one I'm having now. Since upgrading, the error reappeared. However, the fix I applied to CPG 1.3.5 no longer seems to work for 1.4.8 - I tried it, but there was no apparent change. I also tried searching the boards here, but I couldn't find a solution, and thus I'm posting a support request for this error once more, only this time for 1.4.8 usermgr.php.
When enabling debug mode, this is what I get.
Critical 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 `web16-gallery`.cpg135_users AS u INNER JOIN cpg135_usergroups AS g ON u.user_group = g.group_id LEFT JOIN cpg135_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
File: /home/sites/daisymedia.net/public_html/gallery/include/functions.inc.php - Line: 249
I redownloaded the file, in case it was corrupt, but no dice. I still get the same error. Any suggestions?