[ApolloScripter]

Hello there, i started using SQLite recently, so many questions and problems will arise, one of them is just below, when calling a function to delete a row from my table, it prints in the prompt the error below:

pawn Code:

[05:19:36] SQLitei Notice: (db_free_result_hook) Invalid result given.
[05:19:36] [debug] AMX backtrace:
[05:19:36] [debug] #0 native PrintBacktrace () from crashdetect.DLL
[05:19:36] [debug] #1 00019984 in ?? (0) from Survive.amx
[05:19:36] [debug] #2 00093a20 in ?? (0) from Survive.amx
[05:19:36] [debug] #3 000938e0 in ?? (0, 5235, 1, 0, 366666296) from Survive.amx
[05:19:36] [debug] #4 000110ec in public OnDialogResponse (0, 5235, 1, 0, 366666296) from Survive.amx

My code:

PHP Code:

stock ApagarPlayerClan(playerid)
{
    new Query[256], DBResult:Result;
    format(Query, sizeof(Query), "DELETE FROM `ServerClan` WHERE `clanNome` = %s", GetPClan(playerid));
    Result = db_query(gAccounts, Query);
    return db_free_result(Result);
} 


[Joe Staff]

I'm guessing because the query doesn't contain any resulting information and doesn't need to be freed.

[Danbo7]

big of a long shot but i'm sure
clanNome
should be
clanName

[ApolloScripter]

Quote:

Originally Posted by Joe Staff I'm guessing because the query doesn't contain any resulting information and doesn't need to be freed.

Okay, but how can a delete a row?

Quote:

Originally Posted by Danbo7 big of a long shot but i'm sure clanNome should be clanName

No, its clanNome, it is in portuguese.

[Joe Staff]

Code:

stock ApagarPlayerClan(playerid)
{
    new Query[100];
    format(Query, sizeof(Query), "DELETE FROM `ServerClan` WHERE `clanNome` = %s", GetPClan(playerid));
    db_query(gAccounts, Query);
}

[ApolloScripter]

Quote:

Originally Posted by Joe Staff Code: stock ApagarPlayerClan(playerid) { new Query[100]; format(Query, sizeof(Query), "DELETE FROM `ServerClan` WHERE `clanNome` = %s", GetPClan(playerid)); db_query(gAccounts, Query); }

I tried it, nothing happens the row still there and the data has not been deleted

[Joe Staff]

Print the string to console and check the log, see that the SQL code being ran is correct.

[ApolloScripter]

I print the string in the console, it appeared right the name of the clan, still did not delete the row.
I changed and used a SQLite Improved Statement, and for some reason I can't explain worked.

PHP Code:

stmt_apagarPlayerClan = db_prepare(gAccounts, "DELETE FROM 'ServerClan' WHERE 'clanNome'=? COLLATE NOCASE");
stock ApagarPlayerClan(playerid)
{
    stmt_bind_value(stmt_apagarPlayerClan, 0, DB::TYPE_STRING, GetPClan(playerid));
    stmt_execute(stmt_apagarPlayerClan);
} 


Thanks to everyone who helped me