Hee. Well, this is interesting. I recently upgraded my Coppermine Photo Gallery from 1.3.5 to 1.4.8, and everything seemed to be working fine, no errors were reported in the database update (I ran the update, checked the file versions - only anycontent.php is still 1.3.5), until I tried to manage the categories. When trying to access catmgr.php, I get the following message:
Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator, webmaster@daisymedia.net and inform them of the time the error occurred, and anything you might have done that may have caused the error.
More information about this error may be available in the server error log.
--------------------------------------------------------------------------------
Apache/2.0.55 (Red Hat) Server at www.daisymedia.net Port 80
So I started looking for more errors... and found this when accessing usermgr.php
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 believe the database query error has occurred once before, but I fixed it with 1.3.5 (can't for the life of me remember how, though - will have to search, if it is indeed the same error as before), and now it seems to be back. However the 500 Internal Server Error didn't occur before I upgraded the gallery today, I've tried reuploading the file, but nothing seems to help.
The gallery is located at
http://www.daisymedia.net/gallery . Unfortunately, I cannot create a test user because I can't access the user manager. x_x This isn't the first time I've upgraded CPG, but it is the first time I've ran into problems because of upgrading. Any help much appreciated!