Server can't read data from MySQL. - Printable Version
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Server (https://sampforum.blast.hk/forumdisplay.php?fid=6)
+--- Forum: Server Support (https://sampforum.blast.hk/forumdisplay.php?fid=19)
+--- Thread: Server can't read data from MySQL. (/showthread.php?tid=305759)
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Server (https://sampforum.blast.hk/forumdisplay.php?fid=6)
+--- Forum: Server Support (https://sampforum.blast.hk/forumdisplay.php?fid=19)
+--- Thread: Server can't read data from MySQL. (/showthread.php?tid=305759)
Server can't read data from MySQL. - Andrɘ - 23.12.2011
Hey guys, for some reason my server won't read any data from SQL, i am running my server on volt-host, when i run my server at home over WampServer everything works fine.
I uploaded everything right and server is not giving out any errors, i am using R6-2 version of mysql plugin, and yes i have the linux version of it .so
Is anyone else having the same problem?
Edit: This is what i get in Debug "You cannot call this function now. (Reason: Dead Connection) "
Re: Server can't read data from MySQL. - Andrɘ - 23.12.2011
Quote:
|
[15:26:41] --------------------------- [15:26:41] MySQL Debugging activated (12/23/11) [15:26:41] --------------------------- [15:26:41] [15:26:41] >> mysql_query( Connection handle: 1 ) [15:26:41] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead) [15:26:41] >> mysql_store_result( Connection handle: 1 ) [15:26:41] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead) [15:26:41] >> mysql_num_rows( Connection handle: 1 ) [15:26:41] CMySQLHandler::NumRows() - You cannot call this function now. (Reason: Dead Connection) [15:26:41] >> mysql_free_result( Connection handle: 1 ) [15:26:41] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead) [15:26:41] >> mysql_query( Connection handle: 1 ) [15:26:41] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead) [15:26:41] >> mysql_store_result( Connection handle: 1 ) [15:26:41] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead) [15:26:41] >> mysql_num_rows( Connection handle: 1 ) [15:26:41] CMySQLHandler::NumRows() - You cannot call this function now. (Reason: Dead Connection) [15:26:41] >> mysql_free_result( Connection handle: 1 ) [15:26:41] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead) [15:26:41] >> mysql_query( Connection handle: 1 ) [15:26:41] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead) [15:26:41] >> mysql_store_result( Connection handle: 1 ) [15:26:41] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead) [15:26:41] >> mysql_num_rows( Connection handle: 1 ) [15:26:41] CMySQLHandler::NumRows() - You cannot call this function now. (Reason: Dead Connection) [15:26:41] >> mysql_free_result( Connection handle: 1 ) [15:26:41] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead) [15:26:41] >> mysql_query( Connection handle: 1 ) [15:26:41] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead) [15:26:41] >> mysql_store_result( Connection handle: 1 ) [15:26:41] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead) [15:26:41] >> mysql_num_rows( Connection handle: 1 ) [15:26:41] CMySQLHandler::NumRows() - You cannot call this function now. (Reason: Dead Connection) [15:26:41] >> mysql_free_result( Connection handle: 1 ) [15:26:41] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead) |
Re: Server can't read data from MySQL. - Mauzen - 23.12.2011
I dont see a mysql_connect anywhere in the debug log, this would explain the dead connection. Or do you activate debugging after connecting to the server? If yes, change this, so we get debug details on the connection.
Re: Server can't read data from MySQL. - Andrɘ - 23.12.2011
Here it is
Quote:
|
[15:54:21] >> mysql_connect( ) [15:54:21] CMySQLHandler::CMySQLHandler() - constructor called. [15:54:21] CMySQLHandler::CMySQLHandler() - Connecting to "leo.volt-host.com:3306" | DB: "3624_gangster" | Username: "3624_gangster" ... [15:54:21] CMySQLHandler::Connect() - Unknown MySQL server host 'leo.volt-host.com:3306' (1) (Error ID: 2005) [15:54:21] >> mysql_query( Connection handle: 1 ) [15:54:21] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead) [15:54:21] >> mysql_store_result( Connection handle: 1 ) [15:54:21] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead) [15:54:21] >> mysql_num_rows( Connection handle: 1 ) [15:54:21] CMySQLHandler::NumRows() - You cannot call this function now. (Reason: Dead Connection) [15:54:21] >> mysql_free_result( Connection handle: 1 ) [15:54:21] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead) [15:54:21] >> mysql_query( Connection handle: 1 ) [15:54:21] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead) [15:54:21] >> mysql_store_result( Connection handle: 1 ) [15:54:21] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead) [15:54:21] >> mysql_num_rows( Connection handle: 1 ) [15:54:21] CMySQLHandler::NumRows() - You cannot call this function now. (Reason: Dead Connection) [15:54:21] >> mysql_free_result( Connection handle: 1 ) [15:54:21] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead) [15:54:21] >> mysql_query( Connection handle: 1 ) [15:54:21] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead) [15:54:21] >> mysql_store_result( Connection handle: 1 ) [15:54:21] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead) [15:54:21] >> mysql_num_rows( Connection handle: 1 ) [15:54:21] CMySQLHandler::NumRows() - You cannot call this function now. (Reason: Dead Connection) [15:54:21] >> mysql_free_result( Connection handle: 1 ) [15:54:21] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead) [15:54:21] >> mysql_query( Connection handle: 1 ) [15:54:21] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead) [15:54:21] >> mysql_store_result( Connection handle: 1 ) [15:54:21] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead) [15:54:21] >> mysql_num_rows( Connection handle: 1 ) [15:54:21] CMySQLHandler::NumRows() - You cannot call this function now. (Reason: Dead Connection) [15:54:21] >> mysql_free_result( Connection handle: 1 ) [15:54:21] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead) |
DB Host (IP):64.120.22.141
DB Host (Domain):leo.volt-host.com
DB Port:3306
This is my SQL info
Re: Server can't read data from MySQL. - Mauzen - 24.12.2011
Seems like the mysql server is not running, or running on another address. Best thing you can do is send a request to the volt-host support.
Re: Server can't read data from MySQL. - Andrɘ - 24.12.2011
Trust me i have, but they keep saying different things.
Re: Server can't read data from MySQL. - Andrɘ - 24.12.2011
I Really need an advice here, can anyone help?
Re: Server can't read data from MySQL. - GamingTurf - 24.12.2011
[15:54:21] CMySQLHandler::Connect() - Unknown MySQL server host 'leo.volt-host.com:3306' (1) (Error ID: 2005)
Why post logs which didn't even have this in it..
This, is your problem.
Read the error, and figure it out, maybe your host is down? Maybe you have the wrong IP or hostname? Re-check it all.
Re: Server can't read data from MySQL. - Andrɘ - 24.12.2011
Ok... this is why im on forums in first place to get help? And sorry i didn't know? and no thats it not my problem, my problem is server wont connect to mysql, so now thats hosters problem right? I've re-checked it all about 10 times.