SA-MP Forums Archive
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
pawn Код:
mysql_debug(0);
And leave

pawn Код:
mysql_debug(1);



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