MySQL logs - Printable Version

MySQL logs - 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: MySQL logs (/showthread.php?tid=614795)

MySQL logs - Shinja - 13.08.2016

I've got few errors on mysql logs, but can't see the query as i see in many player cases
isn't it by default? i have to use OnQueryError?

Is

PHP код:



mysql_tquery(connectionHandle, query);

Same as?

PHP код:



mysql_query(connectionHandle, query, false);

And one more question, i'm using a threaded query... [FIXED THIS PART]

Re: MySQL logs - oMa37 - 13.08.2016

Show the query.

Re: MySQL logs - Shinja - 13.08.2016

EDIT: Fixed this part

Quote:

Originally Posted by Shinja

And one more question, i'm using a threaded query

PHP код:



mysql_tquery(connectionHandle, query, "", "");

Give error

PHP код:



[ERROR] mysql_tquery - callback parameter count does not match format specifier length

Tried

PHP код:



mysql_tquery(connectionHandle, query);

Same error, i believe the query is fine

Re: MySQL logs - justjamie - 13.08.2016

what is the string size of the query and the size in the database.

Re: MySQL logs - Shinja - 13.08.2016

Quote:

Originally Posted by justjamie

what is the string size of the query and the size in the database.

I fixed the errors, i just got 2 more questions

Re: MySQL logs - Shinja - 15.08.2016

Bump, (reached 4th page and 48 passed)
I've still got some questions here

Re: MySQL logs - ThePhenix - 15.08.2016

Quote:

Originally Posted by Shinja

I've got few errors on mysql logs, but can't see the query as i see in many player cases
isn't it by default? i have to use OnQueryError?

Is

PHP код:



mysql_tquery(connectionHandle, query);

Same as?

PHP код:



mysql_query(connectionHandle, query, false);

And one more question, i'm using a threaded query... [FIXED THIS PART]

They're not the same, as the name itself expresses mysql_tquery uses threades queries, which means that if you use them, they will not freeze your server upon query conclusion, whereas mysql_query will do until the query gets concluded.