[Andrɘ]

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) "

[Andrɘ]

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)

This is what i get in Debug

[Mauzen]

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.

[Andrɘ]

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)

For some reason it says its invalid.

DB Host (IP):64.120.22.141
DB Host (Domain):leo.volt-host.com
DB Port:3306

This is my SQL info

[Mauzen]

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.

[Andrɘ]

Trust me i have, but they keep saying different things.

[Andrɘ]

I Really need an advice here, can anyone help?

[GamingTurf]

[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.

[Andrɘ]

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.