mySQL error
#1

When i register account and the server shuts down.
Code:
[12:35:04] [plugins/mysql] error #1136 while executing query "INSERT INTO `accounts` (`Name`, `Password`, `IP`, `personalmsg`, `Admin`, `Money`, `Money`) VALUES ('hy_Glizzy', 'DC587CD2F91B38336043F2ACF2CAA710AF0DE5604D8AE3B08049985A18EB615AB63BBC1B748884CA48CDDCF31F83FF37050E02AE0DD986C212B9C700EA857B6C', '92.168.0.150', 'The Newcomer', 0,'0')": Column count doesn't match value count at row 1
[12:35:04] [log-core] exception 0XC0000005 (ACCESS_VIOLATION) from Vectored Exception Handler catched; shutting log-core down
Code:
            mysql_format(MySQL, query, sizeof(query), "INSERT INTO `accounts` (`Name`, `Password`, `IP`, `personalmsg`, `Admin`, `Money`, `Money`) VALUES ('%e', '%e', '%e', '%e', 0,'%d')", Name[playerid], PlayerInfo[playerid][Password], playerip[playerid], PlayerInfo[playerid][personalmsg], PlayerInfo[playerid][Money]);
            printf(query);
Reply
#2

By the way, no need for
PHP Code:
'%d' 
, just
PHP Code:
%
, it is not a string
Reply
#3

pawn Code:
mysql_format(MySQL, query, sizeof(query), "INSERT INTO `accounts` (`Name`, `Password`, `IP`, `personalmsg`, `Admin`, `Money`, `Money`) VALUES ('%e', '%e', '%e', '%e', '0','%d')", Name[playerid], PlayerInfo[playerid][Password], playerip[playerid], PlayerInfo[playerid][personalmsg], PlayerInfo[playerid][Money]);
            printf(query);
You must do '0' instead of 0

EDIT:

Quote:
Originally Posted by AndreiWow
View Post
By the way, no need for
PHP Code:
'%d' 
, just
PHP Code:
%
, it is not a string
Are you sure?
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)