MySQL Issues
#1

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.
Reply


Messages In This Thread
MySQL Issues - by iLearner - 17.08.2016, 12:22
Re: MySQL Issues - by iLearner - 17.08.2016, 14:41
Re: MySQL Issues - by Vince - 17.08.2016, 15:17
Re: MySQL Issues - by iLearner - 17.08.2016, 15:38
Re: MySQL Issues - by iLearner - 17.08.2016, 19:47
Re: MySQL Issues - by iLearner - 18.08.2016, 08:01
Re: MySQL Issues - by DandyCorleone - 18.08.2016, 12:50
Re: MySQL Issues - by iLearner - 18.08.2016, 18:27

Forum Jump:


Users browsing this thread: 1 Guest(s)