MySQL error

ncangler · February 24th, 2009, 04:45 PM

I've been getting a number of these errors the past couple months from Reviewpost and Photopost. Our server has been rock solid so I don't think this is a server issue. Any ideas what would cause this error message:

Quote:

An error was encountered during execution of the query:

SELECT id,user,userid,cat,manu,title,bigimage,views FROM rp_products WHERE approved=1 ORDER BY views DESC LIMIT 35

The query returned with an errorcode of:

MySQL server has gone away

If you need assistence or feel this is a 'bug'; please report it to our support forums at: ReviewPost PHP User Reviews Engine

To turn off these emails, set $debug=0 in your config-inc.php file.

Chuck S · February 24th, 2009, 05:48 PM

That has nothing to do with the programs. That error means your mysql on the server has shut down.

ncangler · February 24th, 2009, 06:04 PM

That is what I thought but there is no evidence that our server is dropping the MySQL server as it is not rebooting. I guess I'll just change the Debug setting to "Do Nothing" to eliminate the error messages. Everything seems to be working fine. Thanks.

Chuck S · February 24th, 2009, 09:09 PM

Your mysql server I would suspect does reboot or go down at times. your host should know more on that but thats what that mysql message means.