[CMS] Persistant Database Error After Upgrading to 4.1.11

[mmostafayousef]

I am receiving a persistant database error "Got a packet Bigger than max allowed packet size" after upgrading to 4.1.11.

It is actually happening always with the same SQL query which is: "REPLACE INTO vb_cashe".

Here is a sample of the error message I receive:

---- START HERE ----

Database error in vBulletin 4.1.11:

Invalid SQL:

REPLACE INTO vb_cache
SET cacheid = 'widget_70.43dfd31265eeea2c5ec032cf2ae52d80',
expires = 1331182816,
created = 1331182516,
locktime = 0,
data = "a:4:{s:13:\"contenttypeid\";s:1:\"1\";s:3:\"ids\";a:5:{i:0;s:5:\"38584\";i:1;s:5:\"38583\ ";i:2;s:5:\"38582\";
.
.
.
.
.
Horrible amount of data goes here that I cannot even copy it in the clipboard.
.
.
.
.
.

thumb\";s:1:\"0\";s:11:\"width_thumb\";s:1:\"0\";s:14:\"filedata_thumb\";s:0:\"\";}}}}}",
serialized = '1';

MySQL Error : Got a packet bigger than 'max_allowed_packet' bytes
Error Number : 1153
Request Date : Wednesday, March 7th 2012 @ 10:55:16 PM
Error Date : Wednesday, March 7th 2012 @ 10:55:17 PM
Script : http://forum.ismaily-channel.com/index.php
Referrer : http://forum.ismaily-channel.com/index.php
IP Address : 188.163.107.91
Username : apomborry
Classname : vB_Database
MySQL Version :

---- END HERE ----

[PolicyWala]

Error code 1153: Got a packet bigger than 'max_allowed_packet' bytes
It means that a query is sent that is larger than your host allows for.

MySQL Error : Got a packet bigger than 'max_allowed_packet' bytes

You need to ask your host to increase the 'max_allowed_packet' variable in the my.cnf file and restart MySQL. The default is 1Mb, but most hosts run 8-16 Mb without problems.

More info here: http://dev.mysql.com/doc/refman/5.0/...too-large.html

[mmostafayousef]

Thank you; that was my question. But still I want to know How much it should be for the vBulletin 4.1.11 to work correctly??

[George L]

value can vary from forum to forum, start with 16M and restart mysql server and see. If that doesn't work values up to 64M should be fine

[mmostafayousef]

Ok .. My hosting server has increased the value from 2MB to 5MB and it seems that my CMS page is now loading but not showing correctly. However; I am now receiving another Database Error that I was receiving earlier as well which is explained as follows:

---- START ----

Database error in vBulletin 4.1.11:
Invalid SQL:

UPDATE vb_user
SET
fbaccesstoken = '128978933809266|f3a30e63ac1319b193fdcf3e24da1331'
WHERE userid = 2;

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Saturday, March 10th 2012 @ 11:00:47 PM
Error Date : Saturday, March 10th 2012 @ 11:01:39 PM
Script : http://forum.ismaily-channel.com/forum.php
Referrer : http://forum.ismaily-channel.com/
IP Address : 188.248.46.24
Username : mmostafayousef
Classname : vB_Database
MySQL Version :

---- END ----

[George L]

You need to raise mysql wait_timeout value too

see http://vbtechsupport.com/433/ and http://vbtechsupport.com/433/2/