[DerickClark]

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);

[AndreiWow]

By the way, no need for

PHP Code:

'%d' 


, just

PHP Code:

%d 


, it is not a string

[solstice_]

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 By the way, no need for PHP Code: '%d'  , just PHP Code: %d  , it is not a string

Are you sure?