MYSQL Error - 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: MYSQL Error (/showthread.php?tid=375866)
+- 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: MYSQL Error (/showthread.php?tid=375866)
MYSQL Error - arititlez - 08.09.2012
[19:40:51] MYSQL: Attempting to connect to server...
Quote:
|
[19:40:51] MYSQL: Connection error, retrying... [19:40:51] MYSQL: Could not reconnect to server, terminating server... [19:40:51] Number of vehicle models: 74 [19:40:51] --- Server Shutting Down. |
Quote:
|
#define MYSQL_HOST "localhost" #define MYSQL_USER "root" #define MYSQL_PASS "root" #define MYSQL_DB "nestomyks" |
Re: MYSQL Error - Glint - 08.09.2012
Can you show us your mysql_connect line, and try to change the MYSQL_PASS to "" meaning empty.
Re: MYSQL Error - arititlez - 08.09.2012
line mysql_connect
Quote:
|
mysql_connect(sqlhost, sqluser, sqlpass ,sqldb); |
Re: MYSQL Error - Glint - 08.09.2012
In your defines change the password line with this
Код:
#define MYSQL_PASS ""
pawn Код:
mysql_connect(MYSQL_HOST, MYSQL_USER, MYSQL_DB, MYSQL_PASS);
Re: MYSQL Error - arititlez - 08.09.2012
What can we use instead. samp_mysql_select_db (sqldb);
Used plugins of R6.
Re: MYSQL Error - arititlez - 08.09.2012
error
Re: MYSQL Error - Glint - 08.09.2012
Quote:
|
Originally Posted by arititlez
 error
|
Re: MYSQL Error - arititlez - 08.09.2012
Quote:
|
I changed it. #define MYSQL_HOST "localhost" #define MYSQL_USER "root" #define MYSQL_PASS "nestomyks" #define MYSQL_DB "nestomyks" |
Quote:
|
public MySQLConnect(sqlhost[], sqluser[], sqlpass[], sqldb[]) // by Luk0r { print("MYSQL: Attempting to connect to server..."); mysql_connect(sqlhost, sqluser, sqldb, sqlpass); if(mysql_ping()==0) { print("MYSQL: Database connection established."); return 1; } else { print("MYSQL: Connection error, retrying..."); mysql_connect(sqlhost, sqluser, sqldb, sqlpass); if(mysql_ping()==0) { print("MYSQL: Reconnection successful. We can continue as normal."); return 1; } else { print("MYSQL: Could not reconnect to server, terminating server..."); SendRconCommand("exit"); return 0; } } } |
Quote:
|
[20:27:56] Loaded. [20:27:56] Loading plugin: mysql [20:27:56] > MySQL plugin R5 successfully loaded. [20:27:56] Loaded. [20:27:56] Loaded 2 plugins. [20:27:56] [20:27:56] Filterscripts [20:27:56] --------------- [20:27:56] Loaded 0 filterscripts. [20:27:56] AllowAdminTeleport() : function is deprecated. Please see OnPlayerClickMap() [20:27:56] Pickups Max = 100, Current Pickups = 234 [20:27:56] EEEEE [20:27:56] C C RR V V E RR [20:27:56] C R R O O O V V E R R [20:27:56] C R R O O V V EEEEE R R [20:27:56] C RR O O V V E RR [20:27:56] C R R O O O V V E R R [20:27:56] C C R R V EEEEE R R [20:27:56] MYSQL: Attempting to connect to server... [20:27:56] MYSQL: Connection error, retrying... [20:27:56] MYSQL: Could not reconnect to server, terminating server... [20:27:56] Number of vehicle models: 74 [20:27:56] --- Server Shutting Down. [20:27:56] *** Streamer Plugin v2.6.1 by Incognito unloaded *** |
Re: MYSQL Error - arititlez - 08.09.2012
help me please
Re: MYSQL Error - mamorunl - 08.09.2012
I hope you do have the right stuff where you call MYSQLConnect.