database problem. - 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: database problem. (/showthread.php?tid=582182)
+- 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: database problem. (/showthread.php?tid=582182)
database problem. - SpikeSpigel - 18.07.2015
Hi there. I have made my own gamemode-.. so , I started to do the database, works perfeclty, no error nothing. After I did the system without testing IT I have made a login/register system, a position save and a money save. Ah-.. and three commands. /pay , /me, /do . These works perfectly. But-.. After I start the console EVERY F****** database I try to connect to IT F****** says TO me that the didn't connected to the DATABASE. Cuz something IS FF****** using a password
The F*** is wrong with that thing ?! I tried that on the host, the same, I tried that on XAMPP, not working. On wamp, not F****** working.SERVER_LOG.
Код:
---------- Loaded log file: "server_log.txt". ---------- SA-MP Dedicated Server ---------------------- v0.3z, ©2005-2014 SA-MP Team [09:55:08] filterscripts = "" (string) [09:55:08] [09:55:08] Server Plugins [09:55:08] -------------- [09:55:08] Loading plugin: itd [09:55:08] * iTD Plugin loaded. (Support for textdraw editor mouse/keyboard) [09:55:08] Loaded. [09:55:08] Loading plugin: mysql [09:55:08] SA:MP MySQL Plugin 1.2.1 Loaded. [09:55:08] Loaded. [09:55:08] MySQL: Query thread running. Thread safe: Yes. [09:55:08] Loading plugin: streamer [09:55:08] *** Streamer Plugin v2.7.4 by Incognito loaded *** [09:55:08] Loaded. [09:55:08] Loading plugin: sscanf [09:55:08] [09:55:08] =============================== [09:55:08] sscanf plugin loaded. [09:55:08] Version: 2.8.1 [09:55:08] © 2012 Alex "******" Cole [09:55:08] =============================== [09:55:08] Loaded. [09:55:08] Loading plugin: audio [09:55:08] *** Audio Plugin v0.5 R2 by Incognito loaded *** [09:55:08] Loaded. [09:55:08] Loaded 5 plugins. [09:55:08] [09:55:08] Filterscripts [09:55:08] --------------- [09:55:08] Loaded 0 filterscripts. [09:55:08] MySQL Error (0): Failed to connect. Accиs refusй pour l'utilisateur: 'root'@'@localhost' (mot de passe: OUI). [09:55:08] ---------------------------------- [09:55:08] RolePlay Gamode BY SpikeSpigel A.K.A Modrogeanu Cristian. [09:55:08] ---------------------------------- [09:55:08] Number of vehicle models: 0
oh. And I tried to reinstall XAMPP. 10 F****** TIMES Connetion to the DATABASE on GM:
Код:
mysql_connect("localhost", "root", "roleplay", ""); // IP , USERNAME , DATABASE, PASSWORD
Re: database problem. - MotherDucker - 18.07.2015
Add the code below, above the mysql_connect function, then post all of the information within the mysql_log.txt here.
Код:
mysql_log(LOG_ALL);
Re: database problem. - SpikeSpigel - 18.07.2015
Код:
[07/18/15 10:09:27] ---------------------------------------------- [07/18/15 10:09:27] MySQL logging enabled. Logging all actions. [07/18/15 10:09:27] ----------------------------------------------
WITH NATIVECHECKER:
Код:
---------- Loaded log file: "server_log.txt". ---------- SA-MP Dedicated Server ---------------------- v0.3z, ©2005-2014 SA-MP Team [10:12:50] [10:12:50] Server Plugins [10:12:50] -------------- [10:12:50] Loading plugin: nativechecker [10:12:50] Loaded. [10:12:50] Loading plugin: mysql [10:12:50] SA:MP MySQL Plugin 1.2.1 Loaded. [10:12:50] Loaded. [10:12:50] Loading plugin: sscanf [10:12:50] MySQL: Query thread running. Thread safe: Yes. [10:12:50] [10:12:50] =============================== [10:12:50] sscanf plugin loaded. [10:12:50] Version: 2.8.1 [10:12:50] © 2012 Alex "******" Cole [10:12:50] =============================== [10:12:50] Loaded. [10:12:50] Loaded 3 plugins. [10:12:50] [10:12:50] Filterscripts [10:12:50] --------------- [10:12:50] Loaded 0 filterscripts. [10:12:50] Error: Function not registered: 'mysql_connect' [10:12:50] Error: Function not registered: 'mysql_log' [10:12:50] Error: Function not registered: 'mysql_query' [10:12:50] Error: Function not registered: 'mysql_store_result' [10:12:50] Error: Function not registered: 'mysql_num_rows' [10:12:50] Error: Function not registered: 'mysql_fetch_row' [10:12:50] MySQL Error (0): Failed to connect. Accиs refusй pour l'utilisateur: 'root'@'@localhost' (mot de passe: OUI). [10:12:50] ---------------------------------- [10:12:50] RolePlay Gamode BY SpikeSpigel A.K.A Modrogeanu Cristian. [10:12:50] ---------------------------------- [10:12:50] Number of vehicle models: 0
Re: database problem. - MotherDucker - 18.07.2015
Which version of MySQL are you using?
Re: database problem. - SpikeSpigel - 18.07.2015
In log it says that I'm using that>>
Код:
[10:12:50] Loading plugin: mysql [10:12:50] SA:MP MySQL Plugin 1.2.1 Loaded. [10:12:50] Loaded.
. The same as the IBP Gamemode. Is there any better plugin ?
Re: database problem. - Krokett - 18.07.2015
Tried using this plugin? https://sampforum.blast.hk/showthread.php?tid=56564
Re: database problem. - MotherDucker - 18.07.2015
Yeah.. use what Krokett said, it is the most up-to date plugin you can find for SA:MP.. I have no clue which plugin you're using so it is probably broken..
Re: database problem. - GGRoleplay - 18.07.2015
Dont login with root
Re: database problem. - SpikeSpigel - 18.07.2015
pBlueG or what that person is called. his plugin is bugged. how to heck there isnt a mysql_store_result
[/code]C:\Users\SpikeSpigel\Desktop\MyGamemode.pwn(97) : error 035: argument type mismatch (argument 1)
C:\Users\SpikeSpigel\Desktop\MyGamemode.pwn(9
: error 017: undefined symbol "mysql_store_result"C:\Users\SpikeSpigel\Desktop\MyGamemode.pwn(100) : error 017: undefined symbol "mysql_num_rows"
C:\Users\SpikeSpigel\Desktop\MyGamemode.pwn(287) : error 035: argument type mismatch (argument 1)
C:\Users\SpikeSpigel\Desktop\MyGamemode.pwn(28
: error 017: undefined symbol "mysql_store_result"C:\Users\SpikeSpigel\Desktop\MyGamemode.pwn(290) : error 017: undefined symbol "mysql_num_rows"
C:\Users\SpikeSpigel\Desktop\MyGamemode.pwn(309) : error 035: argument type mismatch (argument 1)
C:\Users\SpikeSpigel\Desktop\MyGamemode.pwn(329) : error 035: argument type mismatch (argument 1)
C:\Users\SpikeSpigel\Desktop\MyGamemode.pwn(330) : error 017: undefined symbol "mysql_store_result"
C:\Users\SpikeSpigel\Desktop\MyGamemode.pwn(332) : error 017: undefined symbol "mysql_fetch_row"
C:\Users\SpikeSpigel\Desktop\MyGamemode.pwn(334) : error 017: undefined symbol "mysql_fetch_row"
C:\Users\SpikeSpigel\Desktop\MyGamemode.pwn(335) : error 017: undefined symbol "mysql_fetch_row"
C:\Users\SpikeSpigel\Desktop\MyGamemode.pwn(336) : error 017: undefined symbol "mysql_fetch_row"
C:\Users\SpikeSpigel\Desktop\MyGamemode.pwn(337) : error 017: undefined symbol "mysql_fetch_row"
C:\Users\SpikeSpigel\Desktop\MyGamemode.pwn(33
: error 017: undefined symbol "mysql_fetch_row"C:\Users\SpikeSpigel\Desktop\MyGamemode.pwn(339) : error 017: undefined symbol "mysql_fetch_row"
C:\Users\SpikeSpigel\Desktop\MyGamemode.pwn(355) : error 035: argument type mismatch (argument 1)
Pawn compiler 3.2.3664 Copyright © 1997-2006, ITB CompuPhase
17 Errors.[/code] -.-
Re: database problem. - MotherDucker - 18.07.2015
It isn't bugged, it just uses different functions to the on you were using it.
If you know what threading is.. then continue using it and check the wiki for help.
However if you do not know, then I'd suggest using the R6 version as it is very similar to your previous one.