Bug Hunting Error

[Ogreman]

My members are getting a bad database error every time they click on hunt. This problem has essentially stopped the game. There were a few admins to the games who made monsters and were moved out of that group for other reasons, but don't why that would be causing DB errors.

 

[Cosmic]

Could you paste the full errors here for us please?

 

[Ogreman]

Well it is freezing my browser everytime I do it. It is too big. However, is part of it:

Database error in vBulletin 3.8.6:

Invalid SQL:

REPLACE INTO datastore
(title, data, unserialize)
VALUES
('dbtech_forumon_battle',

MySQL Error : Got a packet bigger than 'max_allowed_packet' bytes
Error Number : 1153
Request Date : Tuesday, August 23rd 2011 @ 05:13:48 PM
Error Date : Tuesday, August 23rd 2011 @ 05:13:48 PM
Script : http://www.gameogre.com/forums/forumon.php?do=battle&action=hunt&areaid=3
Referrer : http://www.gameogre.com/forums/forumon.php?do=worldmap&action=area&areaid=3
Username : ogreman
Classname : vB_Database
MySQL Version : 5.0.92-community-log

 

[Fillip H.]

That's a server issue, you need to edit my.cnf and increase the max_allowed_packet to a higher number

We're using 128M here on DBTech and it's working perfectly

 

[Ogreman]

You mean we would need to contact our server company and have them change that for us?

 

[Fillip H.]

Unless you have root access to your server then yes, that would be needed.

If it's a shared host it's highly unlikely they will change it for you, since it would also affect the hundreds of other sites on your server. You may need to upgrade to a VPS if so.

 

[Ogreman]

Then why didn't this error show up before? It was working fine for months.

 

[Fillip H.]

Because you have more concurrent battles now than you did a month ago, which means more data to insert.