SA-MP Forums Archive
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