Hi Paul,
I've been getting frequent database errors that reference "mailqueue":
Quote:
Database error in vBulletin 3.8.4:
Invalid SQL:
UPDATE datastore SET
data = data - 49,
data = IF(data < 0, 0, data)
WHERE title = 'mailqueue';
MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Saturday, November 7th 2009 @ 07:40:22 AM
Error Date : Saturday, November 7th 2009 @ 07:40:57 AM
Script : http://www.longrangehunting.com/foru...and=1257597618
Referrer : http://www.longrangehunting.com/forums/
IP Address : 173.73.121.35
Username : Unregistered
Classname : vB_Database
MySQL Version :
|
Quote:
Database error in vBulletin 3.8.4:
Invalid SQL:
UPDATE datastore SET
data = data - 5,
data = IF(data < 0, 0, data)
WHERE title = 'mailqueue';
MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Saturday, November 7th 2009 @ 09:00:24 AM
Error Date : Saturday, November 7th 2009 @ 09:00:45 AM
Script : http://www.longrangehunting.com/foru...hp?rand=147496
Referrer : http://www.longrangehunting.com/arti...enance-2-3.php
IP Address : 98.125.108.202
Username : Unregistered
Classname : vB_Database
MySQL Version :
|
These are just 2 that came in this morning. There have been at least 2 each day. I submitted a support ticket to my server techs (ServInt VPS) and it was suggested that it isn't a MySQL server error:
Quote:
This seems to be an SQL error as opposed to a MySQL server error. Check the script or the SQL query you're running. Also, try to run a similar query manually to verify if this is a SQL error.
|
I may be able to run a query with more guidance. I thought I'd check with you first and if there is a specific query I should run, you could guide me.
Thanks.