MySQL Help Please!
#1

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.
Reply
#2

Show the debug log! We can't do anything with vague or ambiguous messages.
Reply
#3

I am not familiar with MySQL, nor a pro/good scripter.
I can't find the Debug log
Reply
#4

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.
Reply
#5

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
Reply


Forum Jump:


Users browsing this thread: 2 Guest(s)