[iLearner]

Hello pals,

I've got a cnr server, running fit & fat.

but i've got a small problem... sometimes the login box wont popup, means players cant login and these lines are printed in console:

Код:

 [MySQL] Error (0): Failed to exeute query. Lost connection to MySQL server during query.
[10:59:33] Failed to exeute query. Lost connection to MySQL server during query.
[10:59:33] [MySQL] Error (0): Function: mysql_store_result called when no prior successful query executed. Lost connection to MySQL server during query.
[10:59:33] Function: mysql_store_result called when no prior successful query executed. Lost connection to MySQL server during query.
[10:59:33] [MySQL] Error (0): Function: mysql_num_rows called when no result stored. Lost connection to MySQL server during query.
[10:59:33] Function: mysql_num_rows called when no result stored. Lost connection to MySQL server during query.
[10:59:33] [MySQL] Error (0): Function: mysql_store_result called when no prior successful query executed. Lost connection to MySQL server during query.
[10:59:33] Function: mysql_store_result called when no prior successful query executed. Lost connection to MySQL server during query.
[10:59:33] [MySQL] Error (0): Function: mysql_num_rows called when no result stored. Lost connection to MySQL server during query.
[10:59:33] Function: mysql_num_rows called when no result stored. Lost connection to MySQL server during query.
[10:59:38] Owner: 722; Locked: 0
[10:59:42] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[10:59:42] Failed to exeute query. Commands out of sync; you can't run this command now.
[10:59:42] [MySQL] Error (0): Function: mysql_store_result called when no prior successful query executed. Commands out of sync; you can't run this command now.
[10:59:42] Function: mysql_store_result called when no prior successful query executed. Commands out of sync; you can't run this command now.
[10:59:42] [MySQL] Error (0): Function: mysql_num_rows called when no result stored. Commands out of sync; you can't run this command now.
[10:59:42] Function: mysql_num_rows called when no result stored. Commands out of sync; you can't run this command now.
[10:59:42] [MySQL] Error (0): Function: mysql_store_result called when no prior successful query executed. Commands out of sync; you can't run this command now.
[10:59:42] Function: mysql_store_result called when no prior successful query executed. Commands out of sync; you can't run this command now.
[10:59:42] [MySQL] Error (0): Function: mysql_num_rows called when no result stored. Commands out of sync; you can't run this command now.
[10:59:42] Function: mysql_num_rows called when no result stored. Commands out of sync; you can't run this command now.
[10:59:43] [MySQL] Error (0): Could not execute query. Commands out of sync; you can't run this command now.
[10:59:43] Could not execute query. Commands out of sync; you can't run this command now.

Basically the problem comes sometimes, just like these lines are sometimes are printed in console(which i think are reason for this problem)

Код:

	[10:59:33] [MySQL] Error (0): Failed to exeute query. Lost connection to MySQL server during query.
	[10:59:33] Failed to exeute query. Lost connection to MySQL server during query.
	[10:59:33] [MySQL] Error (0): Function: mysql_store_result called when no prior successful query executed. Lost connection to MySQL server during query.
	[10:59:33] Function: mysql_store_result called when no prior successful query executed. Lost connection to MySQL server during query.
	[10:59:33] [MySQL] Error (0): Function: mysql_num_rows called when no result stored. Lost connection to MySQL server during query.
	[10:59:33] Function: mysql_num_rows called when no result stored. Lost connection to MySQL server during query.
	[10:59:33] [MySQL] Error (0): Function: mysql_store_result called when no prior successful query executed. Lost connection to MySQL server during query.
	[10:59:33] Function: mysql_store_result called when no prior successful query executed. Lost connection to MySQL server during query.
	[10:59:33] [MySQL] Error (0): Function: mysql_num_rows called when no result stored. Lost connection to MySQL server during query.
	[10:59:33] Function: mysql_num_rows called when no result stored. Lost connection to MySQL server during quer

I have checked whole script, there isnt any call for mysql_store_result without SELECT query, and num_rows is being called after my_store_result every where too.


Any help? this problem fixes after restarting server, so is it convenient to add mysql_reconnect(); under
public OnMysqlError(error[], errorid, MySQL:handle ?

PS: [10:59:42] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[10:59:42] Failed to exeute query. Commands out of sync; you can't run this command now

is printed everytime a player tries to connect, after the problem has started.
Thanks in advance.

[iLearner]

Someone?

[Vince]

If you're going to fix it, you might as well go all out and update to the latest version. Older versions were notoriously unstable and greatly suffered from memory leaks. Commands out of sync, if I remember correctly, had something to do with sending a new query while the result of the previous query was still in memory; i.e. free_result hadn't been used.

[iLearner]

Checked whole script (my script in devided in includes, is there any way to search all those files by compare string? Maybe cmd.exe?) I didn't find any place where I hadn't free'd result so far
..

[iLearner]

Anyone please? i have to restart server like every 4 hours...

[iLearner]

Si it convenient to add mysql_reconnect(); under mysqlerror...? At least to fix it temporary...?

[DandyCorleone]

u use the MYSQL data?

[iLearner]

Yep i do