jQuery Source - Mysqli prepare error

[TazDevilLooney]

options -> performance -> Jquery Source

When i try to change the source from Google Ajax API CDN to any other i get this error.

An exception occurred: Mysqli prepare error: MySQL server has gone away in \library\Zend\Db\Statement\Mysqli.php on line 77

1. Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
2. Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
3. Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
4. Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 825
5. Zend_Db_Adapter_Abstract->fetchOne() in XenForo/Error.php at line 50
6. XenForo_Error::unexpectedException() in XenForo/Application.php at line 295
7. XenForo_Application::handleException()

Any help with this would be gratefully received.

 

[ChadTheDJ]

I actually read those docs and really just confused me more. I am in control of my own server so I will have to make the changes.

This is my current my.cnf file: http://pastebin.com/PQ3zhSDX

 

[Jake Bunce]

Increase those settings until the problem goes away.

The defaults are:

wait_timeout = 28800
max_allowed_packet = 1048576 (1MB)

 

[ChadTheDJ]

I appreciate the help, I am already surpassing 2GB and 10 times the wait timeout without any luck. I assume this is not normal...

 

[Jake Bunce]

I appreciate the help, I am already surpassing 2GB and 10 times the wait timeout without any luck. I assume this is not normal...

In that case I highly suspect that those settings aren't taking for some reason. Maybe you are editing the wrong config file.

If you have shell access then you can run this command:

mysql --help

That may provide useful info.

Also note that there are client and server configurations in the config file.

 

[ChadTheDJ]

You were right, I restarted the box and worked like a charm... so I must have been restarting the wrong service. Thanks for assisting me!