Server Related Database Errors, Solution?
 

After we moved from a shared to VPS Host. I'm consistently getting such database errors. I'm quite sure that this is mainly due to server, and have informed my host too. They told me to have done some MySQL tune-up, after which the number of database error mails got lesser. However, from sometime now, I'm again getting about 20 - 50 similar mails every day. Please let me know what exactly should I tell my webhost to resolve this error?

Thanks! :)

Quote:
Database error in vBulletin 3.8.x:

Invalid SQL:

UPDATE datastore SET
data = data - 1,
data = IF(data < 0, 0, data)
WHERE title = 'mailqueue';

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Friday, September 10th 2010 @ 10:10:28 AM
Error Date : Friday, September 10th 2010 @ 10:11:19 AM
Script : [Link Removed]
Referrer :
IP Address : [IP Removed]
Username : Unregistered
Classname : vB_Database
MySQL Version :


Quote:
Database error in vBulletin 3.8.x:

Invalid SQL:
UPDATE forum SET
replycount = replycount + 1,
lastpost = 1284096211,
lastpostid = 48615,
lastposter = 'AMG',
lastthread = 'Revamped Hyundai i10 Coming?',
lastthreadid = 1824,
lasticonid = 0,
lastprefixid = ''
WHERE forumid = 5;

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Friday, September 10th 2010 @ 09:23:31 AM
Error Date : Friday, September 10th 2010 @ 09:28:07 AM
Script : [Removed]
Referrer : [Removed]
IP Address : [Removed]
Username : [Removed]
Classname : vB_Database
MySQL Version :