MySQL server has gone away reading from vb3_style
 

Hi,

after updating to vbulletin 4 I get the following error mail some times per week:

Invalid SQL:

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

MySQL-Fehler : MySQL server has gone away
Fehler-Nr. : 2006

I know that "MySQL server has gone away" indicates a timeout. But hey, the statement is one of the easiest ones. And I don't get the same error with other statements!
What's wrong with this statement or the table? The Table only contains two records: the default style and my own style (with styleid 4)...

Thanks for help!

Martin

Please see the manual on this error: Lost connection to MySQL server during query

Thank you for your answer. I have read the manual before asking. But I can't find any help there for my problem. The mentioned reasons in the manual:

The statement is in my case very short (no join, selection of one row of a table with two rows). All other statements of vbulletin (which are much more expensive) work without an error.

All other statements work at the same time without an error.

In phpmyadmin the statement works without an error.

That's not possible if the error only occurs on this statement...

So - any ideas?

Martin

It could be that a previous statement is overloading the MySQL server anbd by that causing the subsequent statement to generate this error.

Try disabling all your plugins and see if that solves the issue.

The statement may be fine, but whats in that style?

Does it do the same thing requesting a different style id?