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

[Marcus]

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

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)

 

[Mike]

That max_allowed_packet is 16K -- the default is 1M and even that is low. So it's likely that.

 

[Marcus]

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.

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)