MySQL error 1153 while editing forum in ACP

[Stefan118]

I was editing the discription of a forum, and when i pressed the save button i got this error.
I tried it again, and again the error.

Then i just entered a random forum in the ACP ( Forums & moderators --> Forum manager --> edit forum) and hit the save button. Again the error!

I disabled all the plugins to see if that was the issue, but i still get the error.

The error 1153 says: Got a packet bigger than 'max_allowed_packet' bytes.
I googled this, and there is a lot of info, infact... TOO much info.

What can i do about this?
Using vB 4.2.1

[ForceHSS]

You need to ask your host to allow you more send them the full error they will know what to do

[Stefan118]

ok...
not untill tomorow unfortunately.
Helpdesk closed in the weekends.

I tried to capture the error to show it here, but it is to big.

[ForceHSS]

You can upload it in a zip file if its that big we might be able to help with parts of it.

[Stefan118]

Good one...
I copied and pasted the error in a tekst document and it is only 1,21 mb large!!!
So i made it a zipfile indeed.

My forum is in dutch language, so parts of the tekst in the error are also dutch.

The attached document contains the error i got while i had all plugins disabled.

[ForceHSS]

in your /includes/config.php file, what is listed for "$config['Datastore']['class']" or is that commented out (which is the default)?
I'd suggest reuploading all the default files
Run this just in case (https://vborg.vbsupport.ru/showthread.php?t=265866)
vBulletin Manual (http://www.vbulletin.com/docs/html/datastore)

[Stefan118]

In the config.php file it should be standard... I did not changed it. Maybe the previous owner, but the last 3 years i own the forum it has not been changed.

What it says is: $config['Datastore']['class'] = 'vB_Datastore_Memcached';

Edit 1:
Ho, wait... It is commented out.
Compleet script part is:
/*
$config['Datastore']['class'] = 'vB_Datastore_Memcached';
$i = 0;
// First Server
$i++;
$config['Misc']['memcacheserver'][$i] = '127.0.0.1';
$config['Misc']['memcacheport'][$i] = 11211;
$config['Misc']['memcachepersistent'][$i] = true;
$config['Misc']['memcacheweight'][$i] = 1;
$config['Misc']['memcachetimeout'][$i] = 1;
$config['Misc']['memcacheretry_interval'][$i] = 15;
*/

Edit 2:
I reuploaded all files.
Tried it again, same error.
Updated and repaired the database, and after that i tried to update the counters.
All were updated fine, exept Rebuilding forum information. Here i got the same 1153 error.
So the problem seems to be in creating, editing, updating etc the forum part.

[ForceHSS]

might be best to put in a support ticket i am to tired to think

[Zachery]

Remove your attachment, the datastore can have some sensitive information.

Like I responded in your ticket:
MySQL Error : Got a packet bigger than 'max_allowed_packet' bytes

This isn't an issue a database restore could ever fix. More data than is allowed was sent to MySQL, MySQL freaked out.

[ForceHSS]

Sorry i could not help more did not get the best sleep last nite and its hard to think when i am tired but after having a short rest was just about to say what support said too you

[Stefan118]

I just called my webhost and indeed, the MySQL max_packet_size was 1MB
He thought it would be standard at 10, but it wasn't.
About 5 minutes later it was set to 20Mb, and the problems were solved.

So stupid, At the top in the ACP there is server information.
it says:
Server Type: Linux
Web Server: apache2handler
PHP: 5.3.8
and so on... the last line was: MySQL Packet Size: 1,00 MB

Now it is 20.

Thanks for the help.