PDA

View Full Version : MySQL Error: Server has gone away


MagicPID
05-08-2013, 01:54 PM
Database error in vBulletin 4.2.0:

Invalid SQL:
UPDATE language SET title = title, phrasegroup_global = 'a:2161:{s:9:\"1_day_ago\";s:9:\"1 Day Ago\";s:10:\"1_hour_ago\";s:10:\"1 Hour Ago\";s:12:\"1_minute_ago.... (This was very long, past the thread limit)
MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Wednesday, May 8th 2013 @ 06:48:56 PM
Error Date : Wednesday, May 8th 2013 @ 06:49:01 PM
Script : http://astropid.com/forums/admincp/plugin.php?do=productimport
Referrer : http://astropid.com/forums/admincp/plugin.php?do=productadd
IP Address : ------------------
Username : Revelation
Classname : vB_Database
MySQL Version :

I keep getting this while trying to install a plugin, some plugins work, some don't. I'm on a new server so the MySQL settings are all fresh so I'm thinking it's timing out and I need too change the time out settings or something, any help on this?

Thanks

Zachery
05-08-2013, 01:59 PM
Two things, make sure the max packet size is some what reasonable (4, 8, 16mb) and that the wait_timeout setting is also not too low. should be at least 30~ seconds if not higher.

MagicPID
05-20-2013, 02:40 PM
I can't find my mysql config file, bah.

nhawk
05-20-2013, 02:50 PM
If this is a dedicated server, you have to SSH into the server and it will be in the /etc directory.

It's usually in..
/etc/mysql/my.cnf
/etc/my.cnf