PDA

View Full Version : Unknown Database Error


MayerZwo
12-18-2012, 09:04 AM
Hello

Since a few Weeks I`m getting daily a few Mails with the following MySQL Error:


Invalid SQL:

SELECT *
FROM vb3_style
WHERE (styleid = 4 AND userselect = 1)
OR styleid = 4
ORDER BY styleid ASC
LIMIT 1;

MySQL-Error : MySQL server has gone away
Error-No. : 2006


I can not reproduce this Error.
It seems not be a big Problem, but I would like to know how to get rid of it.

As I don`t know much about MySQL, I hope anyone here can give me a Hint. ;)
vBulletin Version is 4.1.11

Best regards
Michael

Simon Lloyd
12-18-2012, 09:56 AM
If your server has run out of resources you'll get that message.

betterthanyours
12-19-2012, 09:59 AM
If your server has run out of resources you'll get that message.

This can also happen due to misconfiguration though....the timeout variable might be too low or was probably exceeded or elapsed.

Videx
12-21-2012, 03:49 PM
If it's a shared server you may just have to get used to it as the default timeouts in PHP/mysql have been lowered. Fortunately, it doesn't seem to bother vb much as whatever failed just gets retried until it works.

I just made a mail filter for them. But lately they seem to be slowing down, with only one from 12/17 in there right now. maybe my host relented and raised the settings.