Difference between revisions of "Installation:debugging"

From NeutronAdmin
Jump to: navigation, search
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

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)