database problem.
#1

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
With WAMP is in french. With XAMPP is in english and I uninstalled XAMPP cuz' I thought that If I will use WAMP It will work 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
BTW, I'm using MYSQL 1.2.1 as it says in server log-..
Reply
#2

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);
Reply
#3

Код:
[07/18/15 10:09:27] ----------------------------------------------

[07/18/15 10:09:27] MySQL logging enabled. Logging all actions.

[07/18/15 10:09:27] ----------------------------------------------
That's all .. I'll do the same with nativechecker and crashdetector..

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
Reply
#4

Which version of MySQL are you using?
Reply
#5

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.
So-.. 1.2.1 . The same as the IBP Gamemode. Is there any better plugin ?
Reply
#6

Tried using this plugin? https://sampforum.blast.hk/showthread.php?tid=56564
Reply
#7

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

Dont login with root
Reply
#9

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] -.-
Reply
#10

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


Forum Jump:


Users browsing this thread: 2 Guest(s)