MySQL Problem
#1

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

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
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)