SA-MP Forums

Go Back   SA-MP Forums > SA-MP Scripting and Plugins > Scripting Help

Reply
 
Thread Tools Display Modes
Old 20/03/2018, 10:54 PM   #11
Dayrion
High-roller
 
Dayrion's Avatar
 
Join Date: Jan 2016
Location: France
Posts: 1,832
Reputation: 252
Default Re: MySQL crash

Did you disabled logs? if not, under mysql_connect, you can add
Code:
mysql_log(ALL);
My bad for the code. I didn't compile it for some reasons. Bring back the debug message to know if the query is executed or not.
PHP Code:
    //print("Beginning 'DisplayingBanPerIP' - Rows: %i", cache_num_rows()); 
-> 
printf("Beginning 'DisplayingBanPerIP' - Rows: %i"cache_num_rows()); 
To come back on queries ; the difference is when a query is non-thread, the server will wait until the query is completely executed. A threaded query will be processed in an another thread (not on the "main thread"/SA-MP server) and will return the result in a public callback. So your server can run multiple threaded queries without having lags.

I hope you understand, I'm sorry if not. My english still very basic.
__________________
actor_plus - v5.0.0
I'm a goner, somebody catch my breath,
I'm a goner, somebody catch my breath
Dayrion is online now   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
MySQL Crash icra Scripting Help 3 23/04/2015 02:19 AM
MySQL Crash ahmedkoki Scripting Help 6 22/02/2014 08:11 PM
MySql Crash Shirley Scripting Help 2 08/09/2013 07:01 AM
MySQL R7 Crash Sp3cter Scripting Help 0 21/07/2013 12:57 PM


All times are GMT. The time now is 08:16 PM.


Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.