1. 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

Discussion in 'Troubleshooting and Problems' started by Marcus, Dec 18, 2014.

  1. Marcus

    Marcus Well-Known Member

    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.

    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)
    
     
  2. Mike

    Mike XenForo Developer Staff Member

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

    Marcus Well-Known Member

    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)
    
     

Share This Page