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


Database connection problem - bimax999 - 19.07.2015

I do not understand why not connect to database server , open ports + because I put the server gamemode sql_host give written etc.Intru password register button
give the password to connect to writing and saying it's wrong .

PHOTO!!!:







Re: Database connection problem - SoFahim - 19.07.2015

But, it shows okey. Because, If your mysql server not connected, it won't show number of vehicle models : 75

Re: Database connection problem - bimax999 - 19.07.2015

Why no work ? on login

Re: Database connection problem - JaydenJason - 19.07.2015

Check your mysql log; add this to your script and see if it prints anything.
Код:
public OnQueryError(errorid, error[], resultid, extraid, callback[], query[], connectionHandle) 
{
     printf("EID: %d | Error: %s | Query: %s", errorid, error, query);
     return 1;
}


Re: Database connection problem - bimax999 - 19.07.2015

MYSQL_LOG!
Quote:

[11:10:38] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:11:14] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:12:03] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:12:24] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:13:37] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:16:04] [ERROR] CMySQLQuery::Execute - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''ř' at line 1
[11:16:16] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:16:51] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:17:06] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:17:22] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:17:31] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:17:31] [ERROR] CMySQLQuery::Execute - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''''' at line 1
[11:18:37] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:19:09] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:19:17] [ERROR] CMySQLQuery::Execute - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''ů' at line 1
[11:20:17] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:21:24] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:21:33] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:21:35] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:22:06] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:22:33] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:23:18] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:23:47] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:24:01] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:25:09] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:26:09] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:26:56] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:27:38] [ERROR] CMySQLQuery::Execute - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''' at line 1
[11:28:22] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:28:32] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:28:39] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:29:02] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:29:02] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:30:05] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:32:10] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:32:18] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:32:38] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:32:53] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:33:04] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:33:11] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:33:39] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:33:43] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:34:37] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:34:37] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:35:28] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:35:40] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:36:07] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:36:19] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:36:30] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:36:39] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:37:03] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:37:29] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:37:45] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:38:05] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:38:42] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:39:11] [ERROR] CMySQLQuery::Execute - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Н'' at line 1
[11:39:27] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:39:31] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:39:42] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:40:16] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:40:28] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:40:50] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:41:11] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:41:26] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:41:26] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:41:41] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:42:05] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:43:45] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:44:58] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:45:33] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:47:30] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:48:01] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:48:02] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:48:14] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:49:14] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:50:06] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:51:07] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:51:08] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:51:08] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:51:12] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:51:33] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:51:34] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:51:38] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:51:39] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:52:52] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:54:00] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:54:23] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:55:26] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:56:11] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:56:16] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:56:25] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:56:38] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:56:57] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:56:59] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:57:02] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'
[11:57:30] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Radio' in 'field list'


Re: Database connection problem - gurmani11 - 19.07.2015

hmm now match radio column in script and in local host

Re: Database connection problem - bimax999 - 19.07.2015

What are the problem ? :S

AW: Database connection problem - BigBrainAFK - 19.07.2015

You have to add the field Radio in the mysql table and then recheck if everything works after that

Re: Database connection problem - bimax999 - 19.07.2015

Now ..
Quote:

[16:42:54] [ERROR] mysql_connect - empty connection data specified
[16:42:54] [ERROR] "mysql_query" - invalid connection handle (id: 0)
[16:42:54] [ERROR] "mysql_query" - invalid connection handle (id: 0)
[16:42:54] [ERROR] "mysql_query" - invalid connection handle (id: 0)
[16:42:54] [ERROR] "mysql_query" - invalid connection handle (id: 0)
[16:42:54] [ERROR] "mysql_query" - invalid connection handle (id: 0)
[16:42:54] [ERROR] "mysql_query" - invalid connection handle (id: 0)
[16:42:54] [ERROR] "mysql_query" - invalid connection handle (id: 0)
[16:42:54] [ERROR] "mysql_query" - invalid connection handle (id: 0)
[16:42:54] [ERROR] "mysql_query" - invalid connection handle (id: 0)
[16:42:54] [ERROR] "mysql_query" - invalid connection handle (id: 0)
[16:43:42] [ERROR] "mysql_query" - invalid connection handle (id: 0)
[16:43:52] [ERROR] "mysql_escape_string" - invalid connection handle (id: 1)
[16:43:52] [ERROR] "mysql_query" - invalid connection handle (id: 0)
[16:43:52] [ERROR] "mysql_query" - invalid connection handle (id: 0)
[16:43:53] [ERROR] "mysql_escape_string" - invalid connection handle (id: 1)
[16:43:53] [ERROR] "mysql_query" - invalid connection handle (id: 0)
[16:43:55] [ERROR] "mysql_query" - invalid connection handle (id: 0)
[16:43:55] [ERROR] "mysql_query" - invalid connection handle (id: 0)


Re: Database connection problem - bimax999 - 19.07.2015

HELP MEEEEEEEEEEEEEE!