Mysql help - Query problem - 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)
+---- Forum: Help Archive (
https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: Mysql help - Query problem (
/showthread.php?tid=181948)
Mysql help - Query problem -
Niixie - 08.10.2010
Hello everyone.
I've scripted a register system in mysql, and this is the first time i have this problem.
i have
format(query, sizeof(query), "INSERT INTO blabla", parameters);
and its alright. I've debugged it, and the line is okay. But it doesnt insert it into the database?
Anyone else had that problem?
Re: Mysql help - Query problem -
Calgon - 08.10.2010
Have you verified the query would execute properly if executed under another platform (for example, running the query through PHP?).
If not, please could you paste the query here, or try that?
Re: Mysql help - Query problem -
Lenny the Cup - 08.10.2010
If you're using G-sTyLeZzZ MySQL plugin (And you should), use MYSQL_DEBUG 1 and check the log it generates
Re: Mysql help - Query problem -
[HiC]TheKiller - 08.10.2010
Use this
https://sampwiki.blast.hk/wiki/MySQL#mysql_debug if you are using GsTyLeZzZ plugin like Lenny said and post the script and error here.
Re: Mysql help - Query problem -
Niixie - 08.10.2010
Sorry i dont answer before now, but there doesnt show up any file when i debug?
I have mysql_debug(1); then (0); after
Re: Mysql help - Query problem -
Niixie - 08.10.2010
*bumb, please help
Re: Mysql help - Query problem -
[HiC]TheKiller - 08.10.2010
Take out
And leave
Re: Mysql help - Query problem -
Niixie - 09.10.2010
Alright, here it is.
Код:
[17:03:06]
[17:03:06] ---------------------------
[17:03:06] MySQL Debugging activated (10/09/10)
[17:03:06] ---------------------------
[17:03:06]
[17:03:06] >> mysql_query( Connection handle: 1 )
[17:03:06] >> mysql_query() - Invalid connection handle. (You set: 1, Highest connection handle ID is 0).
[17:03:06] >> mysql_query( Connection handle: 1 )
[17:03:06] >> mysql_query() - Invalid connection handle. (You set: 1, Highest connection handle ID is 0).
[17:03:06] >> mysql_store_result( Connection handle: 1 )
[17:03:06] >> mysql_store_result() - Invalid connection handle. (You set: 1, Highest connection handle ID is 0).
[17:03:06] >> mysql_num_rows( Connection handle: 1 )
[17:03:06] >> mysql_num_rows() - Invalid connection handle. (You set: 1, Highest connection handle ID is 0).
Re: Mysql help - Query problem -
Sergei - 09.10.2010
Connect to the database.
Re: Mysql help - Query problem -
Niixie - 09.10.2010
Lol, how could i forget? Thanks