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.

 

[Jake Bunce]

That error is caused by one of these MySQL settings being exceeded:

wait_timeout
max_allowed_packet

If you don't manage your own server then you need to ask your host or server person to increase these settings.

 

[TazDevilLooney]

Thanks Jake for your reply but unfortunately it didn't fix the problem. There is no delay displaying the error it's pretty much instant hitting the save changes button.

innodb_lock_wait_timeout = 500
max_allowed_packet = 160M

This is the only section i have come across that displays an error. I'm running Apache on windows if that helps.

 

[Jake Bunce]

If not those limits then the server is "going away" for some other reason.

Lots of info:

http://dev.mysql.com/doc/refman/5.1/en/gone-away.html

 

[TazDevilLooney]

Thanks Jake i'll have a look

 

[Mike]

Note that Jake mentioned wait_timeout, not innodb_lock_wait_timeout. The latter wouldn't apply in this case. (wait_timeout is likely the issue, though frankly I'm not sure why it would be coming up here.)

 

[TazDevilLooney]

This only wait_timeout i could find was innodb_lock_wait_timeout in the mysql database config file. I'll see if i can add it in

 

[TazDevilLooney]

Adding wait_timeout = 300 to the mysql config file still produces the error

 

[Mike]

If you submit a ticket with FTP and admin CP access details, I'll look into it.

 

[TazDevilLooney]

Ok, thanks Mike ticket opened

 

[TazDevilLooney]

It turns out there are 2 sections in the same config file with max_allowed_packet and yep you guest it i was adjusting the wrong one.

my.ini

[mysqld]
max_allowed_packet = 32M <- This one was needed

[mysqldump]
max_allowed_packet = 32M <- Not this one

The jQuery Source now works with no errors. Thanks Jake and Mike for your help with this.

 

[ChadTheDJ]

After reading this forum, I am still getting the "gone away" after making those changes. Do I just need to make it more?

 

[TazDevilLooney]

Have you adjusted wait_timeout = 300 in my.ini ?

 

[ChadTheDJ]

The wait_timeout option was not in my config file (my.cnf), so I added it with the exact amount with "300". Restarted the service, no dice.

 

[TazDevilLooney]

Try and increase

[mysqld]
max_allowed_packet = 32M

to

[mysqld]
max_allowed_packet = 64M

 

[ChadTheDJ]

Nope, no dice as well. I will reboot my server later and see if that helps. Still seeing this:

An exception occurred: Mysqli prepare error: MySQL server has gone away in /srv/www/bestgaminghosts.com/forum/library/Zend/Db/Statement/Mysqli.php on line 77
 
Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 825
Zend_Db_Adapter_Abstract->fetchOne() in XenForo/Error.php at line 50
XenForo_Error::unexpectedException() in XenForo/Application.php at line 295
XenForo_Application::handleException()

 

[TazDevilLooney]

You do need to restart your mysql for the setting to take affect. It will only read the my.cnf on loading.

 

[ChadTheDJ]

I did run a "service mysql restart" after modifying the files. Service starts just fine.

 

[TazDevilLooney]

Ummm, i'm not sure what to suggest for you the information worked for me. You could open up a support ticket and get assistance from a member of staff.

 

[Jake Bunce]

There is more information about this error here:

http://dev.mysql.com/doc/refman/5.1/en/gone-away.html

You can forward this link to your web host or server person.

But these two settings are the most likely cause:

wait_timeout
max_allowed_packet

If the error persists then try increasing those settings some more. Or maybe you are editing the wrong config file or the settings are not taking effect for some reason.