Question Mysql Goes Away on Install

[Mick]

Hi Guys,

When Importing the XML I get a blank page and a MYSQL gone away error.

My forum is quite large 220,000 members and 2.3 million posts...

I wondered if you guys had either the direct mysql commands (VIA SSH command line).

Or know the php.ini or my.cnf lines that need upping?

I get this occasionally with some modifications

Thank you for your support guys.

Mick

 

[Fillip H.]

This is a general server error that's very hard to diagnose, see this Manual page for further information: MySQL :: MySQL 5.0 Reference Manual :: C.5.2.9 MySQL server has gone away

 

[Mick]

This is a general server error that's very hard to diagnose, see this Manual page for further information: MySQL :: MySQL 5.0 Reference Manual :: C.5.2.9 MySQL server has gone away

Database error in vBulletin 4.2.2:

Invalid SQL:
ALTER TABLE `theforumprefix__post` ADD `chargecontent` TEXT NOT NULL;

MySQL Error   : MySQL server has gone away
Error Number  : 2006
Request Date  : Monday, December 9th 2013 @ 06:02:00 AM
Error Date    : Monday, December 9th 2013 @ 06:09:49 AM
Script        : http://www.digitalworldz.co.uk/admincpppp/plugin.php?do=productimport
Referrer      : http://www.digitalworldz.co.uk/admincpppp/plugin.php?do=productadd
IP Address    : 77.102.29.224
Username      : Mick
Classname     : vB_Database
MySQL Version : 
=====================================================

Database error in vBulletin 4.2.2:

Invalid SQL:
ALTER TABLE `theforumprefix__post` ADD `chargecontent` TEXT NOT NULL;

MySQL Error   : MySQL server has gone away
Error Number  : 2006
Request Date  : Monday, December 9th 2013 @ 06:13:54 AM
Error Date    : Monday, December 9th 2013 @ 06:15:47 AM
Script        : http://www.digitalworldz.co.uk/admincpppp/plugin.php?do=productimport
Referrer      : http://www.digitalworldz.co.uk/admincpppp/plugin.php?do=productadd
IP Address    : 77.102.29.224
Username      : Mick
Classname     : vB_Database
MySQL Version :

Thank you
Mick

 

[Fillip H.]

Have you tried running those queries via SSH and installing the mod after they've ran?

 

[Mick]

I am looking for them to be honest Fillip H.,

I cant find them in the credits_installer.php file ??

Which file holds the quieres , I do not mind manually doing any of them

Cheers
Mick

 

[Fillip H.]

Try this one first, as this is the one who generated the error above:

ALTER TABLE `theforumprefix__post` ADD `chargecontent` TEXT NOT NULL;

 

[Mick]

might take a while

the post table on my forum is really big like 3gb or something

cheers
Mick

 

[Mick]

Not sure why, but it even timed out at command line ???

Not sure what to do next...

I have been reading and there seems to be some problem with mysql 5 and above with TEXT NOT NULL?

Something to do with strict ??

Regards
Mick

 

[Fillip H.]

I've never heard of a problem with that column, where did you read that?

 

[Mick]

Fillip H. To be honest I was just searching for not null and mysql errors and came across this..

WordPress › Support » MySQL 5 incompatibility caused by TEXT NOT NULL columns

Regards
Mick

 

[Fillip H.]

What version of MySQL are you running?

 

[Mick]

What version of MySQL are you running?

Server version: 5.2.12-MariaDB-mariadb115 (MariaDB)

Thanks very much Fillip H. appreciate your time.

Mick

 

[Fillip H.]

Then you shouldn't be affected by the issue in that link.

If you cannot run MySQL queries from the command line without them timing out, then you should contact your host.