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