MySQL Help Please! - 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 Help Please! (
/showthread.php?tid=411747)
MySQL Help Please! -
Saadat - 30.01.2013
My server shuts down because it fails to connect to to MySQL DB
Код:
----------
Loaded log file: "server_log.txt".
----------
SA-MP Dedicated Server
----------------------
v0.3e-R2, ©2005-2012 SA-MP Team
[17:30:10]
[17:30:10] Server Plugins
[17:30:10] --------------
[17:30:10] Loading plugin: mysql.dll
[17:30:10]
> MySQL plugin R5 successfully loaded.
[17:30:10] Loaded.
[17:30:10] Loaded 1 plugins.
[17:30:11]
[17:30:11] Filterscripts
[17:30:11] ---------------
[17:30:11] Loading filterscript 'npcs.amx'...
[17:30:11] Loaded 1 filterscripts.
[17:30:11] Incoming connection: 127.0.0.1:52184
[17:30:11] Incoming connection: 127.0.0.1:52186
[17:30:11] Incoming connection: 127.0.0.1:52185
[17:30:11] Incoming connection: 127.0.0.1:52188
[17:30:11] Incoming connection: 127.0.0.1:52187
[17:30:11] Incoming connection: 127.0.0.1:52197
[17:30:11] Incoming connection: 127.0.0.1:52190
[17:30:11] Incoming connection: 127.0.0.1:52198
[17:30:11] Incoming connection: 127.0.0.1:52192
[17:30:11] Incoming connection: 127.0.0.1:52189
[17:30:11] Incoming connection: 127.0.0.1:52193
[17:30:11] Incoming connection: 127.0.0.1:52194
[17:30:11] Incoming connection: 127.0.0.1:52191
[17:30:11] Incoming connection: 127.0.0.1:52195
[17:30:11] Incoming connection: 127.0.0.1:52196
[17:30:11] Incoming connection: 127.0.0.1:52199
[17:30:12] [MYSQL]: [ERROR]: Connection To `cnr` Failed!
[17:30:12] [MYSQL]: Could Not Retrieve Field - Shutting Down Server.
[17:30:12]
----------------------------------
[17:30:12] SERVER: HIDDEN
[17:30:12] GAME MODE: HIDDEN
[17:30:12] MAP NAME: HIDDEN
[17:30:12] VERSION: 1 Beta 1.4
[17:30:12] MAX PLAYER SLOTS: HIDDEN
[17:30:12] DEVELOPER NAME: HIDDEN
[17:30:12] WEBSITE: HIDDEN
[17:30:12] LAST EDITED: HIDDEN
[17:30:12] ----------------------------------
[17:30:12] Number of vehicle models: 125
[17:30:12] --- Server Shutting Down.
I have this in my script, not my script my friends, he don't want to host it anymore.
Код:
//The following information is only for our wamp server, when we are ready to upload it to our server for use you will need to change it
#define MYSQL_HOST "127.0.0.1" //Standard wamp host localhost
#define MYSQL_USER "root" //Standard wamp user
#define MYSQL_PASS "" //Standard wamp password (Nothing)
#define MYSQL_DB "cnr" //This is the database we are going to use (I'll show you how to set it up later :) )
#define DIALOG_REGISTER (1000)
#define DIALOG_LOGIN (2000)
No other MySQL Database entered in the script. I created an online MySQL DB, but when I add it here, it does the same thing.
EDIT: Plus I have XAMPP but I don't know how to set up a database with that.
Re: MySQL Help Please! -
Vince - 30.01.2013
Show the debug log! We can't do anything with vague or ambiguous messages.
Re: MySQL Help Please! -
Saadat - 30.01.2013
I am not familiar with MySQL, nor a pro/good scripter.
I can't find the Debug log
Re: MySQL Help Please! -
Vince - 30.01.2013
It should be in the server directory, called
mysql_log.txt. If it's not there, then add
mysql_debug(); as the first thing in
OnGamemodeInit.
Re: MySQL Help Please! -
Saadat - 30.01.2013
I added it, but can't workout with it. Still can't find that log file.
Can you help me through TeamViewer?
If no, then help me here