[jameskmonger]

When I submit an SQL query (not all queries, only one) the server crashes and I get this error:

Quote:

[22:57:31] [debug] Server crashed while executing DCRP.amx [22:57:31] [debug] AMX backtrace: [22:57:31] [debug] #0 native mysql_function_query () [10008f00] from mysql.DLL [22:57:31] [debug] #1 00056d58 in ?? () from DCRP.amx [22:57:31] [debug] #2 000e1310 in ?? () from DCRP.amx [22:57:31] [debug] #3 000e1f10 in public OnDialogResponse () from DCRP.amx [22:57:31] [debug] System backtrace: [22:57:31] [debug] #0 01ebeaeb in ?? () from C:\Users\James\Desktop\Diverse City Roleplay\SERVER\LIBMYSQL.dll

The query executed:

pawn Код:

new CheckCharExists_result[MAX_PLAYERS];

forward CheckCharacterExistsHandle(playerid);
public CheckCharacterExistsHandle(playerid) {
    new rows, fields, temp;
    cache_get_data(rows, fields);
    if(rows > 0) {
        temp = 1;
    } else {
        temp = 0;
    }
    CheckCharExists_result[playerid] = temp;
}

CheckCharacterExists(playerid, account[])
{
    new string[128];
    CheckMySQL();
    format(string, sizeof(string), "SELECT * FROM characters WHERE Name='%s'", account);
    mysql_function_query(dbHandle, string, true, "CheckCharacterExistsHandle", "i", playerid);
}