Upgrade error on adding RSS entry to FAQ

[The_Enigma]

Database error in vBulletin 3.0.1:

Invalid SQL:
REPLACE INTO datastore
(title, data)
VALUES
Lots of info here, too big to post.

mysql error: MySQL server has gone away

mysql error number: 2006


This is a test database before i upgrade the real one and is on my local machine. I've increased all memory limits and timeouts etc. Any Idea?

[weirdpixels]

Even if there is lots of info, you really need to post the whole error, so the support team have a better chance of figuring out what's going wrong

[The_Enigma]

When i meant lots of info, it's too long to post in here.

The text that you have entered is too long (1063488 characters). Please shorten it to 65536 characters long.

[weirdpixels]

sorry about that, I did not actually think it was too big to post here.
That must be some error!

[Marco van Herwaarden]

Have a look at: http://dev.mysql.com/doc/mysql/en/gone-away.html

Some quotes:

<LI>You can also get these errors if you send a query to the server that is incorrect or too large. If mysqld receives a packet that is too large or out of order, it assumes that something has gone wrong with the client and closes the connection. If you need big queries (for example, if you are working with big BLOB columns), you can increase the query limit by setting the server's max_allowed_packet variable, which has a default value of 1MB. You may also need to increase the maximum packet size on the client end. More information on setting the packet size is given in Section A.2.9, “Packet too large”.

<LI>You also get a lost connection if you are sending a packet 16MB or larger if your client is older than 4.0.8 and your server is 4.0.8 and above, or the other way around.

[The_Enigma]

If the query or packet is broken, how do you fix it?

Because it's not the max_allowed_packet or wait_timeout

[The_Enigma]

Is it possible to install a fresh vbulletin and then import mysql data after?

[Steve Machol]

Reinstalling and importing will not fix the underlying server issue that is causing this.

[Freddie Bingham]

What is max_allowed_packet and wait_timeout set to?

This query: SHOW VARIABLES

Will show you the actual values that your server is using.

[The_Enigma]

max_allowed_packet = 1048576

wait_timeout = 28800 and i've also tried 57600

[Freddie Bingham]

It is your max_allowed_packet setting of 1 megabyte. Increase it to 2 megabytes and you'll be able to do the upgrade.