Loosing db conection

[Exiled Pain]

I'm getting this error quite alot. Someone, anyone?

Lattest error:

[19/11/2009 23:05:44] Failed reconnecting to database - MYSQL ERROR: Lost connection to MySQL server during query
[19/11/2009 23:05:44] mysql_real_query(): SELECT `password` FROM `accounts` WHERE `id` = 7716064: MYSQL ERROR: Lost connection to MySQL server during query

After that no one else can enter the server, if you log out, or die (well its basically the same), you can't go back in, only if the server is restarted, but the server doesn't crash nor anything just that error and after that, player msg is on window is:

[19/11/2009 23:06:08] Sonia Baccers has logged out.
[19/11/2009 23:06:08] Error while saving player: Sonia Baccers

And it goes the same for all the players

 

[C00KIE]

I'm getting this error quite alot. Someone, anyone?

Lattest error:

[19/11/2009 23:05:44] Failed reconnecting to database - MYSQL ERROR: Lost connection to MySQL server during query
[19/11/2009 23:05:44] mysql_real_query(): SELECT `password` FROM `accounts` WHERE `id` = 7716064: MYSQL ERROR: Lost connection to MySQL server during query

After that no one else can enter the server, if you log out, or die (well its basically the same), you can't go back in, only if the server is restarted, but the server doesn't crash nor anything just that error and after that, player msg is on window is:

[19/11/2009 23:06:08] Sonia Baccers has logged out.
[19/11/2009 23:06:08] Error while saving player: Sonia Baccers

And it goes the same for all the players

export your needed tables, and re-do your database -- character loss might be alot depending how established your server is, but im sure they would like the fact they could log in after dieing.

I don't deal with mysql but the call function is trying to load save an account after dieing, but the password is erroring within the query, and unless you developed or know the code well.. its going to be a b**ch to fix it. Just export and start fresh.

 

[Exiled Pain]

Well but is there any other way, cause if creating a new dB and importing everything, what keeps it from having the same problem in a few days or weeks. Is there a more permanent solution and what are the steps for it?

 

[Exiled Pain]

bump anyone?

 

[IonS]

are you using a clean or edited TFS?

 

[Exiled Pain]

Clean for this server in particular. Except the map

 

[IonS]

TFS version? I'll test it...