Getting MySQL errors after fresh install

[Boofo]

I have been getting errors like the following on a regular basis since doing a fresh install of 3.7.0 beta 4. I was running 3.5.4 until now and have not seen any db errors in quite a while with that version. I was reading that this error might be because of restarting MySQL but I don't see that analogy being the case in this as my host has not changed the way they have done things. Does anyone have any idea why the errors are happening so much more now than before?

Database error in vBulletin 3.7.0 Beta 4:
Invalid SQL:
UPDATE user SET
lastactivity = 1201623110,
lastvisit = 1201623109
WHERE userid = 5;
MySQL Error : MySQL server has gone away
Error Number : 2006
Date : Tuesday, January 29th 2008 @ 08:12:03 AM
Script : http://www.fathers-rights-forums.com/forums/forumdisplay.php?do=markread
Referrer : http://www.fathers-rights-forums.com/forums/
IP Address : xxx.xxx.x.x
Username : xxxx
Classname : vb_database
MySQL Version :

[Jason2]

MySQL Error : MySQL server has gone away

That's saying exactly what it means. Maybe you have it to automatically restart mySQL on a daily basis.

Look in your mysql.err error log in your mysql data directory for reasons/clues as to why mysql went down.

Regards Jason :)

[Boofo]

I can't see that as this only started happening since the new version. The old site is still running fine with no db errors. Why would I get reset errors on the new version and not on the old version when they are on the same damned server?

[Jason2]

Have you checked your error log that I said above?

MySQL Error : MySQL server has gone away

Maybe someone else can help you, but that says it all.

Regards Jason :)

[Boofo]

Ok, I just got another error like that.

I checked with my host and MySQL is only reset once a day. I had 4 of those errors yesterday and 3 so far today. And after looking at the logs, they only have happened on beta 4, none on beta 3 when I had that version up and running. So, I'm not buying it's all MySQL's fault no matter what error vb is saying it is. It doesn't make sense why it would start out of the blue on a stock vb install.

[Jason2]

Post the error log.

Regards Jason :)

[Lynne]

Do you have any mods installed? Maybe one of the mods is causing the problem because of a change in the vb software that the mod hasn't been able to update yet.

[poprulz]

I got the same error.
Error Number : 2006

I guess its with the Casino plugin. I used to get around 10-20 gone away errors most referring to values related to casino.

I will update if it is confirmed, running on betas aswell

[Boofo]

Well, I have to confess that my host changed something somewhere that seems to have stopped the errors for now. What was strange, and still bothers me, is the fact that my old site was up and running as I was moving things to the new version and it never encountered any of those errors. They are both on the same server. I will attached the error report if I get any more of them.

Do you have any mods installed? Maybe one of the mods is causing the problem because of a change in the vb software that the mod hasn't been able to update yet.

This was happening on a stock vBulletin 3.7.0 beta 4 setup.

[Icy]

This might help :) MySQL Server Gone Away Error Explained (http://www.vbulletin.com/forum/showthread.php?t=43505)

[Boofo]

This might help :) MySQL Server Gone Away Error Explained (http://www.vbulletin.com/forum/showthread.php?t=43505)

Excellent! Thank you. ;)

But that still doesn't explain why it will give me errors on the new version and not on the 3.5.4 version. I was using both when I was moving stuff.

[Icy]

May be because of 3.7 needs more DB resources than 3.5 :S I'm not sure though. Just a wild guess :S

[Boofo]

A wild guess is better than anything I have been able to come up with so far. ;)