SA-MP Forums Archive
[Help] MySQL bug i can'f fix, need help - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+---- Forum: Help Archive (https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: [Help] MySQL bug i can'f fix, need help (/showthread.php?tid=157648)



[Help] MySQL bug i can'f fix, need help - Kastranova - 07.07.2010

I'm busy trying to istert mysql cmds in my server. but have something i can't find a sollution.

Код:
new string[256];
format(string,sizeof(string),"INSERT INTO `users` (`username`, `password`, `cash`, `bank`, `adminlevel`, `years`, `months`) VALUES ('%s', '%s', '2500', '5000', '0', '0', '0')", usernamein, passwordin);
mysql_query(string);
but i get this error in my MySQL Log
Quote:

An error has occured. (Error ID: 2014, Commands out of sync; you can't run this command now

Please help


Re: [Help] MySQL bug i can'f fix, need help - oliverrud - 07.07.2010

You might have missed adding a mysql_free_result(); earlier in the script like OnPlayerConnect or whatever.