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=632742)
+- 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=632742)
MySQL error - Man43 - 18.04.2017
hello i find this in my server.log....
PHP код:
[18:04:08] [xVeh MySql] Connecting to database...
[18:04:08] [xVeh MySql] The connection has failed!
[!!! xVehicle v2 couldn't init !!!]
Re: MySQL error - Zav1337 - 18.04.2017
DB table will be automatically created. Your problem is DB connect. Open xVehicleV2.pwn and change SQL data
starting at line 51 (SQL_HOST, SQL_USER, SQL_PASSWORD, SQL_DBNAME).
Re: MySQL error - Man43 - 18.04.2017
Hello..
What i must change here?!
Код:
#define SQL_HOST "localhost" #define SQL_USER "root" #define SQL_PASSWORD "" #define SQL_DBNAME "xfr_testdb"
Re: MySQL error - Zav1337 - 18.04.2017
Do you have any database?
Re: MySQL error - Man43 - 18.04.2017
Yes i have.
Re: MySQL error - Zav1337 - 18.04.2017
Okay, put your db host in SQL_HOST, your db user name in SQL_USER, your db user password in SQL_PASSWORD, and your database name in SQL_DBNAME
Re: MySQL error - Man43 - 18.04.2017
Hello again, its worked succsefuly but there a problem..._... When i Restarted my server and i already bouget a car All of Cars Restarted. I Mean there are no cars...
[sorry for my bad english]
Re: MySQL error - Zav1337 - 18.04.2017
Can u upload log from logs/plugins/mysql.log? It will be usefull since xVeh is logging everything.
Re: MySQL error - Man43 - 18.04.2017
This is all of server.log
Код:
---------- Loaded log file: "server_log.txt". ---------- SA-MP Dedicated Server ---------------------- v0.3.7-R2, ©2005-2015 SA-MP Team [19:11:23] [19:11:23] Server Plugins [19:11:23] -------------- [19:11:23] Loading plugin: crashdetect.so [19:11:23] CrashDetect v4.18.1 is OK. [19:11:23] Loaded. [19:11:23] Loading plugin: streamer.so [19:11:23] *** Streamer Plugin v2.8.2 by Incognito loaded *** [19:11:23] Loaded. [19:11:23] Loading plugin: mysql.so [19:11:23] >> plugin.mysql: R41-2 successfully loaded. [19:11:23] Loaded. [19:11:23] Loading plugin: whirlpool.so [19:11:23] [19:11:23] ================== [19:11:23] [19:11:23] Whirlpool loaded [19:11:23] [19:11:23] ================== [19:11:23] [19:11:23] Loaded. [19:11:23] Loading plugin: sscanf.so [19:11:23] [19:11:23] =============================== [19:11:23] sscanf plugin loaded. [19:11:23] Version: 2.8.1 [19:11:23] © 2012 Alex "******" Cole [19:11:23] =============================== [19:11:23] Loaded. [19:11:23] Loaded 5 plugins. [19:11:24] [19:11:24] Filterscripts [19:11:24] --------------- [19:11:24] Loading filterscript 'UltraHost.amx'... [19:11:24] Loading filterscript 'bank.amx'... [19:11:25] [19:11:25] [19:11:25] [19:11:25] ======================================= [19:11:25] | | [19:11:25] | YSI version 3.09.0684 | [19:11:25] | By Alex "******" Cole | [19:11:25] | | [19:11:25] ======================================= [19:11:25] [19:11:25] [19:11:25] [19:11:25] || Banking System By Zh3r0 || Loaded Successfully [19:11:25] Loading filterscript 'xVehiclev3.amx'... [19:11:25] [19:11:25] [19:11:25] [19:11:25] ======================================= [19:11:25] | | [19:11:25] | YSI version 4.00.0001 | [19:11:25] | By Alex "******" Cole | [19:11:25] | | [19:11:25] ======================================= [19:11:25] [19:11:25] +----------------------------------------------------------------------+ [19:11:25] | | [19:11:25] | 888 888 888 d8b 888 | [19:11:25] | 888 888 888 Y8P 888 | [19:11:25] | 888 888 888 888 | [19:11:25] | 888 888 Y88b d88P .d88b. 88888b. 888 .d8888b 888 .d88b. | [19:11:25] | `Y8bd8P' Y88b d88P d8P Y8b 888 '88b 888 d88P' 888 d8P Y8b | [19:11:25] | X88K Y88o88P 88888888 888 888 888 888 888 88888888 | [19:11:25] | .d8''8b. Y888P Y8b. 888 888 888 Y88b. 888 Y8b. | [19:11:25] | 888 888 Y8P 'Y8888 888 888 888 'Y8888P 888 'Y8888 | [19:11:25] | | [19:11:25] +--------------------------------------------------+-------------------+ [19:11:25] | .d888b. | [19:11:25] | VP `8D | [19:11:25] | Y8 8P odD' | [19:11:25] | `8b d8' .88' | [19:11:25] | `8bd8' j88. | [19:11:25] | YP 888888D | [19:11:25] +-------------------+ [19:11:25] [xVeh MySql] Connecting to database... [19:11:25] [xVeh MySql] The connection has failed! [!!! xVehicle v2 couldn't init !!!] [19:11:25] Loading filterscript 'speedo.amx'... [19:11:25] Loaded 4 filterscripts. [19:11:26] *** Streamer Plugin: CreateDynamicCP: Expecting 10 parameter(s), but found 8 [19:11:26] ---------------------------------- [19:11:26] Gamemode By HiLuX [19:11:26] ---------------------------------- [19:11:26] Number of vehicle models: 61 [19:11:42] [connection] 92.241.58.192:19221 requests connection cookie. [19:11:43] [connection] incoming connection: 92.241.58.192:19221 id: 0 [19:11:44] [join] HiLux has joined the server (0:92.241.58.192) [19:11:48] *** Streamer Plugin: CreateDynamicMapIcon: Expecting 12 parameter(s), but found 10 [19:26:52] [part] HiLux has left the server (0:1)
Re: MySQL error - Zav1337 - 18.04.2017
It's not working. Did you edit and compile xVehicles2.pwn? Whats your sql host? Do you need PORT with the host (dbhost:port)?
[19:11:25] [xVeh MySql] Connecting to database...
[19:11:25] [xVeh MySql] The connection has failed!
[!!! xVehicle v2 couldn't init !!!]