[SQLite] Invalid Result Given - Printable Version

[SQLite] Invalid Result Given - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: [SQLite] Invalid Result Given (/showthread.php?tid=671188)

[SQLite] Invalid Result Given - ApolloScripter - 14.12.2019

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

}

Re: [SQLite] Invalid Result Given - Joe Staff - 14.12.2019

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

Re: [SQLite] Invalid Result Given - Danbo7 - 14.12.2019

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

Re: [SQLite] Invalid Result Given - ApolloScripter - 14.12.2019

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.

Re: [SQLite] Invalid Result Given - Joe Staff - 14.12.2019

Code:

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

Re: [SQLite] Invalid Result Given - ApolloScripter - 14.12.2019

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

Re: [SQLite] Invalid Result Given - Joe Staff - 14.12.2019

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

Re: [SQLite] Invalid Result Given - ApolloScripter - 15.12.2019

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