SA-MP Forums Archive
Big problem with MySQL connection. - 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: Big problem with MySQL connection. (/showthread.php?tid=346769)



Big problem with MySQL connection. - Ricop522 - 29.05.2012

pawn Код:
[16:59:10] noReturnQuery(i) - Threaded function called.
[17:19:20] >> mysql_query_callback( Connection handle: 1 )
[17:19:20] >> mysql_query_callback( Connection handle: 1 )
[17:19:20] >> mysql_query_callback( Connection handle: 1 )
[17:19:20] >> mysql_query_callback( Connection handle: 1 )
[17:19:21] >> mysql_query_callback( Connection handle: 1 )
[17:19:21] >> mysql_query_callback( Connection handle: 1 )
[17:19:21] >> mysql_query_callback( Connection handle: 1 )
[17:19:21] >> mysql_query_callback( Connection handle: 1 )
[17:25:39] >> mysql_query_callback( Connection handle: 1 )
[17:25:39] >> mysql_query_callback( Connection handle: 1 )
[17:25:39] >> mysql_query_callback( Connection handle: 1 )
[17:25:39] >> mysql_query_callback( Connection handle: 1 )
[17:25:40] >> mysql_query_callback( Connection handle: 1 )
[17:25:40] >> mysql_query_callback( Connection handle: 1 )
[17:25:40] >> mysql_query_callback( Connection handle: 1 )
[17:25:40] >> mysql_query_callback( Connection handle: 1 )
[17:34:51] CMySQLHandler::ProcessQueryThread() - Reconnection attempt in background thread.
[17:34:54] CMySQLHandler::Connect() - Can't connect to MySQL server on 'host' (113) (Error ID: 2003)
[17:58:22] >> mysql_query_callback( Connection handle: 1 )
[17:58:47] >> mysql_query_callback( Connection handle: 1 )
[17:59:03] >> mysql_query_callback( Connection handle: 1 )
[17:59:31] >> mysql_query_callback( Connection handle: 1 )
[18:00:15] >> mysql_query_callback( Connection handle: 1 )
[18:00:38] >> mysql_query_callback( Connection handle: 1 )
[18:00:42] >> mysql_query_callback( Connection handle: 1 )
[18:00:51] >> mysql_query_callback( Connection handle: 1 )
[18:01:10] >> mysql_query_callback( Connection handle: 1 )
[18:02:14] >> mysql_query_callback( Connection handle: 1 )
[18:02:39] >> mysql_query_callback( Connection handle: 1 )
[18:02:52] >> mysql_query_callback( Connection handle: 1 )
[18:03:10] >> mysql_query_callback( Connection handle: 1 )
[18:03:18] >> mysql_query_callback( Connection handle: 1 )
[18:03:53] >> mysql_query_callback( Connection handle: 1 )
[18:03:58] >> mysql_query_callback( Connection handle: 1 )
[18:04:06] >> mysql_query_callback( Connection handle: 1 )
[18:04:06] >> mysql_query_callback( Connection handle: 1 )
[18:04:15] >> mysql_query_callback( Connection handle: 1 )
[18:05:36] >> mysql_query_callback( Connection handle: 1 )
[18:06:09] >> mysql_query_callback( Connection handle: 1 )
[18:07:10] >> mysql_query_callback( Connection handle: 1 )
[18:08:16] >> mysql_query_callback( Connection handle: 1 )
[18:08:46] >> mysql_query_callback( Connection handle: 1 )
[18:09:03] >> mysql_query_callback( Connection handle: 1 )
[18:10:21] >> mysql_query_callback( Connection handle: 1 )
[18:10:53] >> mysql_query_callback( Connection handle: 1 )
[18:11:14] >> mysql_query_callback( Connection handle: 1 )
[18:12:46] >> mysql_query_callback( Connection handle: 1 )
[18:12:47] >> mysql_query_callback( Connection handle: 1 )
[18:13:45] >> mysql_query_callback( Connection handle: 1 )
[18:14:46] >> mysql_query_callback( Connection handle: 1 )
[18:17:20] >> mysql_query_callback( Connection handle: 1 )
[18:17:21] >> mysql_query_callback( Connection handle: 1 )
[18:18:04] >> mysql_query_callback( Connection handle: 1 )
[18:19:11] >> mysql_query_callback( Connection handle: 1 )
[18:20:47] >> mysql_query_callback( Connection handle: 1 )
[18:21:24] >> mysql_query_callback( Connection handle: 1 )
[18:21:43] >> mysql_query_callback( Connection handle: 1 )
[18:22:05] >> mysql_query_callback( Connection handle: 1 )
[18:23:00] >> mysql_query_callback( Connection handle: 1 )
[18:23:50] >> mysql_query_callback( Connection handle: 1 )
[18:25:11] >> mysql_query_callback( Connection handle: 1 )
[18:27:04] >> mysql_query_callback( Connection handle: 1 )
[18:29:00] >> mysql_query_callback( Connection handle: 1 )
[18:29:21] >> mysql_query_callback( Connection handle: 1 )
[18:32:14] >> mysql_query_callback( Connection handle: 1 )
[18:33:22] >> mysql_query_callback( Connection handle: 1 )
[18:33:53] >> mysql_query_callback( Connection handle: 1 )
[18:35:07] >> mysql_query_callback( Connection handle: 1 )
[18:35:17] >> mysql_query_callback( Connection handle: 1 )
[18:37:41] >> mysql_query_callback( Connection handle: 1 )
[18:38:37] >> mysql_query_callback( Connection handle: 1 )
[18:42:38] >> mysql_query_callback( Connection handle: 1 )
[18:47:10] >> mysql_query_callback( Connection handle: 1 )
[18:47:12] >> mysql_query_callback( Connection handle: 1 )
[18:48:51] >> mysql_query_callback( Connection handle: 1 )
[18:49:03] >> mysql_query_callback( Connection handle: 1 )
[18:49:27] >> mysql_query_callback( Connection handle: 1 )
[18:54:16] >> mysql_query_callback( Connection handle: 1 )
[18:54:28] >> mysql_query_callback( Connection handle: 1 )
[18:55:01] >> mysql_query_callback( Connection handle: 1 )
[18:58:18] >> mysql_query_callback( Connection handle: 1 )
[19:00:22] >> mysql_query_callback( Connection handle: 1 )
[19:06:30] >> mysql_query_callback( Connection handle: 1 )
[19:07:17] >> mysql_query_callback( Connection handle: 1 )
[19:08:51] >> mysql_query_callback( Connection handle: 1 )
[19:09:47] >> mysql_query_callback( Connection handle: 1 )
[19:11:33] >> mysql_query_callback( Connection handle: 1 )
[19:16:16] >> mysql_query_callback( Connection handle: 1 )
[19:21:23] >> mysql_query_callback( Connection handle: 1 )
[19:21:42] >> mysql_query_callback( Connection handle: 1 )
[19:25:59] >> mysql_query_callback( Connection handle: 1 )
[19:26:50] >> mysql_query_callback( Connection handle: 1 )
[19:27:24] >> mysql_query_callback( Connection handle: 1 )
[19:29:09] >> mysql_query_callback( Connection handle: 1 )
[19:31:09] >> mysql_query_callback( Connection handle: 1 )
[19:32:11] >> mysql_query_callback( Connection handle: 1 )
[19:32:19] >> mysql_query_callback( Connection handle: 1 )
[19:32:24] >> mysql_query_callback( Connection handle: 1 )
[19:32:42] >> mysql_query_callback( Connection handle: 1 )
[19:32:52] >> mysql_query_callback( Connection handle: 1 )
[19:33:03] >> mysql_query_callback( Connection handle: 1 )
[19:33:40] >> mysql_query_callback( Connection handle: 1 )
[19:33:45] >> mysql_query_callback( Connection handle: 1 )
My gamemode crashes and all commands stop to work.


Re: Big problem with MySQL connection. - mati233 - 29.05.2012

Quote:

[17:34:54] CMySQLHandler::Connect() - Can't connect to MySQL server on 'host'

You're trying to connect to 'host'?
Is your database on localhost or other host? You should put there localhost, or the ip of the host where you have the database..


Re: Big problem with MySQL connection. - Ricop522 - 30.05.2012

Its the IP, but I remove it for security reasons...
This happen everyday


Re: Big problem with MySQL connection. - Ranama - 21.08.2012

Do you or anyone got any solution to this yet? becuse I'm getting this to now, but my commands and all keeps on working. it happens when i try to load all my car objects and they are a little bit strange.
EDIT: think it was becuse i was trying to get the data from non existing tables.