SA-MP Forums Archive
My MYSQL is messed up. - 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: My MYSQL is messed up. (/showthread.php?tid=529167)



My MYSQL is messed up. - RayC - 31.07.2014

I keep getting these errors and there's no accounts being saved on the database.. IT works on my local server when I homerun it but when I set it up on host, it keeps giving me these errors and no stats save.
Quote:

[20:37:35] >> mysql_store_result( Connection handle: 1 )

[20:37:35] CMySQLHandler::StoreResult() - No data to store.

[20:37:35] >> mysql_retrieve_row( Connection handle: 1 )

[20:37:35] CMySQLHandler::RetrieveRow() - You cannot call this function now. (Reason: Empty Result)

[20:37:35] >> mysql_free_result( Connection handle: 1 )

[20:37:35] CMySQLHandler::FreeResult() - The result is already empty.

[20:37:35] >> mysql_store_result( Connection handle: 1 )

[20:37:35] CMySQLHandler::StoreResult() - No data to store.

[20:37:35] >> mysql_retrieve_row( Connection handle: 1 )

[20:37:35] CMySQLHandler::RetrieveRow() - You cannot call this function now. (Reason: Empty Result)

[20:37:35] >> mysql_free_result( Connection handle: 1 )

[20:37:35] CMySQLHandler::FreeResult() - The result is already empty.



Re: My MYSQL is messed up. - dirigent00 - 31.07.2014

Codes ?


Re: My MYSQL is messed up. - RayC - 31.07.2014

Quote:
Originally Posted by dirigent00
Посмотреть сообщение
Codes ?
Codes for what, that's the errors I get,


Re: My MYSQL is messed up. - dirigent00 - 31.07.2014

Codes where you use MySQL to save accounts.


Re: My MYSQL is messed up. - McBan - 31.07.2014

Hello,

I am taking a wide guess here and going for the fact that your Home Computer is most probably Windows whereas the host is more than likely to be Linux. Try and change the plugins by adding a (".so") at the end. As I said, This is a wide guess and fixed most of my errors when I hosted it on the host.


Re: My MYSQL is messed up. - Isolated - 31.07.2014

Sounds to be that you may not have the permissions, remote host or other reason, everything is returning empty.


Re: My MYSQL is messed up. - RayC - 31.07.2014

Quote:
Originally Posted by Isolated
Посмотреть сообщение
Sounds to be that you may not have the permissions, remote host or other reason, everything is returning empty.
Quote:
Originally Posted by McBan
Посмотреть сообщение
Hello,

I am taking a wide guess here and going for the fact that your Home Computer is most probably Windows whereas the host is more than likely to be Linux. Try and change the plugins by adding a (".so") at the end. As I said, This is a wide guess and fixed most of my errors when I hosted it on the host.
Quote:
Originally Posted by dirigent00
Посмотреть сообщение
Codes where you use MySQL to save accounts.
Thank you all for your help, I managed to sort this by sorting out the remote host permission, +1