• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

XF 1.4 [Solved] Editing Templates: Mysqli prepare error: MySQL server has gone away

Marcus

Well-known member
#1
I get this error whenever I want to change a template now. However when I post the same template content as a regular forum post, it works. So I wonder what I could do, and where to look to solve that issue. Thanks.

An exception occurred: Mysqli prepare error: MySQL server has gone away in /.../library/Zend/Db/Statement/Mysqli.php on line 77
Code:
mysql> SHOW VARIABLES WHERE Variable_Name IN ('wait_timeout', 'max_allowed_packet');
+--------------------+-------+
| Variable_name      | Value |
+--------------------+-------+
| max_allowed_packet | 16384 |
| wait_timeout       | 28800 |
+--------------------+-------+
2 rows in set (0.00 sec)
 

Marcus

Well-known member
#3
Thanks Mike, I am always amazed by the great service I get here on xenforo! I restarted the database with stock options and it works perfect now.

Code:
mysql> SHOW VARIABLES WHERE Variable_Name IN ('wait_timeout', 'max_allowed_packet');
+--------------------+---------+
| Variable_name      | Value   |
+--------------------+---------+
| max_allowed_packet | 4194304 |
| wait_timeout       | 28800   |
+--------------------+---------+
2 rows in set (0.00 sec)