Bug Database error

[Anony999]

Database error in vBulletin 4.1.1:

Invalid SQL:

* * * * * * * *SELECT *
* * * * * * * *FROM vbstyle
* * * * * * * *WHERE (styleid = 1)
* * * * * * * * * *OR styleid = 1
* * * * * * * *ORDER BY styleid ASC
* * * * * * * *LIMIT 1;

MySQL Error **: MySQL server has gone away
Error Number *: 2006
Request Date *: Monday, January 31st 2011 @ 07:09:01 PM
Error Date ***: Monday, January 31st 2011 @ 07:10:01 PM
Script *******: http://mywebsiteurl/ajax.php?do=dbtech_infopanel_stats
Referrer *****: http://mywebsiteurl/forum.php
IP Address ***: my ip address
Username *****: Admin
Classname ****: vB_Database
MySQL Version :

I think this is an info problem ? As it's the script thats being called?

No other mods on vb other than three of yours, standard skin and no vbseo

 

[Fillip H.]

That's your MySQL crashing, it's not InfoPanels in particular. Nothing we can do unfortunately

 

[Anony999]

Ok, I'll ask my host to have a look

I got five more SQL errors in the night, all the same, so why is it that every SQL error list info stats php as the script ? Surly if it were a server SQL problem the scripts in the emailed error would all be different ?

Thanks

 

[Fillip H.]

Not necessarily, it could just be the fact that IP is adding an extra load to the server.

We had a similar issue on DBTech back several months ago, we fixed it by increasing the wait timeout setting in my.cnf (sorry I can't be more specific, I can't recall the specific setting name)

 

[Anony999]

Not necessarily, it could just be the fact that IP is adding an extra load to the server.

We had a similar issue on DBTech back several months ago, we fixed it by increasing the wait timeout setting in my.cnf (sorry I can't be more specific, I can't recall the specific setting name)

Thanks, host has checked and reckons the sql is fine

Cud you check what the specific wait timeout you changed was so i can get them to check that ! If possible !

Cheers

 

[Fillip H.]

Try doubling the default and keep increasing it until the errors go away.

 

[Anony999]

Try doubling the default and keep increasing it until the errors go away.

Thanks

Doubling the default in what ?

Also host has come back and check the logs, the sql hasnt stopped as far as they are concerned and have asked for more information

 

[Fillip H.]

I don't know what the default is for you, so I can't tell you what to double