SA-MP Forums Archive
OnQueryFinish 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)
+--- Thread: OnQueryFinish Problem. (/showthread.php?tid=387782)



[FIXED]OnQueryFinish Problem. - Peach - 26.10.2012

Problem has been fixed. I forgot to add mysql_store_result(); in the function.


Re: OnQueryFinish Problem. - Calabresi - 26.10.2012

I really did not see a problem here but check your server's MySQL logs, maybe the answer is in there.


Re: OnQueryFinish Problem. - Peach - 26.10.2012

Fixed.


Re: OnQueryFinish Problem. - Calabresi - 26.10.2012

Quote:
Originally Posted by Peach
Посмотреть сообщение
I'm trying to trace down my XAMPP mysql logs but having no luck so far.
Just check mysql_log.txt in your server's main directory. (The place you run samp-server.exe)


Re: OnQueryFinish Problem. - Peach - 26.10.2012

Fixed.


Re: OnQueryFinish Problem. - Calabresi - 26.10.2012

Quote:
Originally Posted by Peach
Посмотреть сообщение
My server does not create a mysql_log, have no idea why.
Are you sure that you installed mysql plugin without any problems?


Re: OnQueryFinish Problem. - Peach - 26.10.2012

Fixed.


Re: OnQueryFinish Problem. - Calabresi - 26.10.2012

Quote:
Originally Posted by Peach
Посмотреть сообщение
100% I've been working on this server for a few months now. Never had any problems or errors regarding the MySQL plugin.

I'm using the G-sTyLeZzZ MySQL plugin and it's never let me down.
I suggest you to use BlueG's one, because it's much better in my opinion plus, it writes you a mysql log.

https://sampforum.blast.hk/showthread.php?tid=56564

Edit: You gotta download R7 for threaded connections.


Re: OnQueryFinish Problem. - B-Matt - 26.10.2012

Quote:
Originally Posted by Calabresi
Посмотреть сообщение
I suggest you to use BlueG's one, because it's much better in my opinion plus, it writes you a mysql log.

https://sampforum.blast.hk/showthread.php?tid=56564

Edit: You gotta download R7 for threaded connections.
It's the same plugin lol Put mysql_debug in public OnGameModeInit() callback and that will create mysql_log.txt in server folder.

PHP код:
public OnGameModeInit()
{
    
mysql_debug(1); //enable debug
    //...
    
mysql_debug(0); //disable debug
    
return 1;

Source: https://sampwiki.blast.hk/wiki/MySQL#mysql_debug


Re: OnQueryFinish Problem. - Peach - 26.10.2012

Problem has been fixed. Look at the top on how I fixed it.