Difference between revisions of "Installation:debugging"
From NeutronAdmin
| Line 4: | Line 4: | ||
==== 500 Internal server error ==== | ==== 500 Internal server error ==== | ||
Give the 'cache' folder 777 recursive permissions | Give the 'cache' folder 777 recursive permissions | ||
| + | |||
| + | ==== "MySQL Server has gone away" ==== | ||
| + | |||
| + | * Set your refreshrate in your lua config to 15 seconds or less. Your MySQL server does not allow any connections that last longer than 15 seconds most likely, so it's timing out before its hitting the default 40. | ||
| + | * To fix this run these two commands in your MySQL (If you can't, get your host to do it): | ||
| + | SET @@GLOBAL.wait_timeout=300; | ||
| + | SET @@LOCAL.wait_timeout=300; | ||
==== Function Remt does not exist ==== | ==== Function Remt does not exist ==== | ||
Please run this MySQL query in your Neutron MySQL database manually:<blockquote>CREATE FUNCTION remt(t INT(5)) RETURNS TIMESTAMP RETURN (now()-INTERVAL t SECOND)</blockquote> | Please run this MySQL query in your Neutron MySQL database manually:<blockquote>CREATE FUNCTION remt(t INT(5)) RETURNS TIMESTAMP RETURN (now()-INTERVAL t SECOND)</blockquote> | ||
Revision as of 14:40, 19 December 2017
Contents
Debugging
If you have any issues with Neutron you should always read this article first:
500 Internal server error
Give the 'cache' folder 777 recursive permissions
"MySQL Server has gone away"
- Set your refreshrate in your lua config to 15 seconds or less. Your MySQL server does not allow any connections that last longer than 15 seconds most likely, so it's timing out before its hitting the default 40.
- To fix this run these two commands in your MySQL (If you can't, get your host to do it):
SET @@GLOBAL.wait_timeout=300; SET @@LOCAL.wait_timeout=300;
Function Remt does not exist
Please run this MySQL query in your Neutron MySQL database manually:CREATE FUNCTION remt(t INT(5)) RETURNS TIMESTAMP RETURN (now()-INTERVAL t SECOND)
