MySQL error 2014.
#1

Hello,

Since i modified my saving code yesterday, i get a weird error somehow. It says the syntax that i'm using is wrong, but i dont see the mistake:

Quote:

[18:01:16] CMySQLHandler::Query(UPDATE `users` SET `adminlevel` = '1100', `money` = '10000', `license` = '1', `weaponlicense` = '1', `flylicense` = '1', `job` = '8' WHERE `username` = 'Danny') - An error has occured. (Error ID: 2014, Commands out of sync; you can't run this command now)

And this is the code in the GM:

Код:
	format(file, sizeof file,"UPDATE `users` SET `adminlevel` = '%d', `money` = '%d', `license` = '%d', `weaponlicense` = '%d', `flylicense` = '%d', `job` = '%d' WHERE `username` = '%s'",pInfo[playerid][adminlevel],pInfo[playerid][money],pInfo[playerid][license],pInfo[playerid][weaponlic],pInfo[playerid][flylic],gTeam[playerid],EscapeName);
	mysql_query(file);
	mysql_store_result();
What im doing wrong?

Greetz,
Danny
Reply


Messages In This Thread
MySQL error 2014. - by Danny - 26.04.2011, 17:29
Re: MySQL error 2014. - by Raimis_R - 26.04.2011, 17:39
Re: MySQL error 2014. - by Danny - 26.04.2011, 17:45
Re: MySQL error 2014. - by Raimis_R - 26.04.2011, 17:49
Re: MySQL error 2014. - by Danny - 26.04.2011, 18:02
Re: MySQL error 2014. - by Raimis_R - 26.04.2011, 18:08
Re: MySQL error 2014. - by Danny - 26.04.2011, 18:24
Re: MySQL error 2014. - by Raimis_R - 26.04.2011, 18:25

Forum Jump:


Users browsing this thread: 1 Guest(s)