MySQL Problem - Printable Version

MySQL Problem - 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)
+--- Thread: MySQL Problem (/showthread.php?tid=410502)

MySQL Problem - BullseyeHawk - 25.01.2013

I'm getting this following error while trying to register:

Quote:

[MySQL] Error (0): Failed to exeute query. Column count doesn't match value count at row 1.

line where it tries to exeute:

Quote:

format(query, sizeof(query), "INSERT INTO `accounts` (Username,Password,Money,Skin,PosX,PosY,PosZ,PosA) VALUES ('%s','%s','1000','60','5','5','5')", GetPlayerNameEx(playerid), MYSQL_Password);
mysql_query(query);

GetPlayerNameEx(playerid) return a 23 length string of the username with '_'
and the database has a varchar of 23 length.

I cannot understand why it returns that error, everything is correct-..

Re: MySQL Problem - IPrototypeI - 25.01.2013

It means that the value not match with the column look at your floats 5.0 and use even backtricks for columns
but thats not the reason for your problem