[6:34:31.043] mysql_real_query(): UPDATE `players` SET `online` = 0 WHERE `id` = 32 L

[Stellow]

I got this error

[6:34:31.043] mysql_real_query(): UPDATE `players` SET `online` = 0 WHERE `id` = 32 LIMIT 1; - MYSQL ERROR: Lost connection to MySQL server during query (2013)

And then players cannot log anymore in their characters

 

[Cornex]

Can you don't run

UPDATE `players` SET `online` = 0 WHERE `id` = 32 LIMIT 1;

In phpmyadmin/SQL

 

[Resource]

Somehow the server lost connection to mysql, try restarting mysql in xampp or whatever you are using.

 

[Milice]

As Resource said. And also just a question.. " id " in players is an unique auto_increment value. Why the hell is there a " LIMIT 1 " ?

 

[sn3ejk]

Your server loses connection to the database.
I propose to update the MySQL database management in the source files.

 

[Stellow]

I [12:48:44.501] mysql_real_query(): SELECT `save` FROM `players` WHERE `id` = 75 LIMIT 1 - MYSQL ERROR: Lost connection to MySQL server during query (2013)

Frequently, I get this error, and then no longer able to access their player chars. Idea

Obs: Always after serve save (globalserver save disabled)

sqlKeepAlive = 10
mysqlReadTimeout = 0
mysqlWriteTimeout = 0

Now, I tried to mess with that ^, we gonna see if works or not =/

- - - Updated - - -

Your server loses connection to the database.
I propose to update the MySQL database management in the source files.

How do I do it?

- - - Updated - - -

Bump