PM Database Errors

[tqj]

I am having some problems with users getting a database error when sending PM's. It seems that the PM's go through but get the following error:

Database error in vBulletin 3.7.3:

Invalid SQL:

UPDATE user
SET pmtotal = pmtotal + 1, pmunread = pmunread + 1,
pmpopup =
CASE
WHEN userid IN(29) THEN 2
ELSE pmpopup
END

WHERE userid IN(29);

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Friday, November 7th 2008 @ 09:45:37 AM
Error Date : Friday, November 7th 2008 @ 09:46:10 AM
Script : http://www.theqjoint.com/forum/priva...insertpm&pmid=
Referrer : http://www.theqjoint.com/forum/private.php?do=newpm
IP Address : *******
Username : *******
Classname : vB_Database
MySQL Version :

Any help would be appreciated.

[snakes1100]

If this isnt a dedicated/vps server, you will need to contact your host to resolve this issue.

wait_timeout = 60 (or higher)
connect_timeout = 60 (or higher)

Set those in my.cnf and restart mysql

[tqj]

Join Date: Jan 2008
Posts: 27


I went into the Mysql admin at GoDaddy and built a new database and transfered everything over to the new database.
I figured that would eliminate any part of it that may have been corrupt.

The problem still continues even if there are only 5 or so members on line.
Our forum only has 352 members So I'm not sure what could be overloading it.

This problem only happens with private messages. The sender gets the error and the recipient still gets the message.
This is causing members to send the message over and over thinking the person didn't get it.

[Marco van Herwaarden]

I don't know what modification added that query, but it is for sure not a default vB query. Also it is constructed in a very strange way and can most likely be optimised a lot. The whole CASE construct seems to be useless.

[Magnumutz]

Your MySQL server chrashed.
That means that your host is not good enough for you or that your mods may cause the MySQL server to crash.