[Tutorial] MySQL Registration System [Threaded Queries(R33+) + Whirlpool]
#52

Logging in dosen't work for me. It tells me my password is wrong even though it's right, also it dosen't turn the characters I type in into those circle things.

mysql_log.txt
Quote:

[13:51:59] [DEBUG] mysql_connect - host: "localhost", user: "root", database: "server", password: "****", port: 3306, autoreconnect: true, pool_size: 2
[13:51:59] [DEBUG] CMySQLHandle::Create - creating new connection..
[13:51:59] [DEBUG] CMySQLHandle::CMySQLHandle - constructor called
[13:51:59] [DEBUG] CMySQLHandle::Create - connection created (id: 1)
[13:51:59] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[13:51:59] [DEBUG] CMySQLConnection::Connect - connection was successful
[13:51:59] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[13:51:59] [DEBUG] mysql_errno - connection: 1
[13:51:59] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[13:51:59] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[13:51:59] [DEBUG] CMySQLConnection::Connect - connection was successful
[13:51:59] [DEBUG] CMySQLConnection::Connect - connection was successful
[13:51:59] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[13:51:59] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[13:52:38] [DEBUG] mysql_format - connection: 1, len: 128, format: "SELECT `Password`, `ID` FROM `players` WHERE `Username` = '%e' LIMIT 1"
[13:52:38] [DEBUG] mysql_tquery - connection: 1, query: "SELECT `Password`, `ID` FROM `players` WHERE `Username` = 'aaa' ", callback: "OnAccountCheck", format: "i"
[13:52:38] [DEBUG] CMySQLQuery::Execute[OnAccountCheck] - starting query execution
[13:52:38] [DEBUG] CMySQLQuery::Execute[OnAccountCheck] - query was successfully executed within 0.382 milliseconds
[13:52:38] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[13:52:38] [DEBUG] Calling callback "OnAccountCheck"..
[13:52:38] [DEBUG] cache_get_data - connection: 1
[13:52:38] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[13:52:42] [DEBUG] mysql_format - connection: 1, len: 300, format: "INSERT INTO `players` (`Username`, `Password`, `IP`, `Admin`, `Money`, `PosX` ,`PosY`, `PosZ`) VALUES ('%e', '%s', '%s', 0, 0, 0..."
[13:52:42] [DEBUG] mysql_tquery - connection: 1, query: "INSERT INTO `players` (`Username`, `Password`, `IP`, `Admin`, `M", callback: "OnAccountRegister", format: "i"
[13:52:42] [DEBUG] CMySQLQuery::Execute[OnAccountRegister] - starting query execution
[13:52:43] [DEBUG] CMySQLQuery::Execute[OnAccountRegister] - query was successfully executed within 20.534 milliseconds
[13:52:43] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[13:52:43] [DEBUG] Calling callback "OnAccountRegister"..
[13:52:43] [DEBUG] cache_insert_id - connection: 1
[13:52:43] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[13:52:49] [DEBUG] mysql_format - connection: 1, len: 128, format: "UPDATE `players` SET `Admin`=%d, `Money`=%d, `posX`=%f, `posY`=%f, `posZ`=%f WHERE `ID`=%d"
[13:52:49] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `players` SET `Admin`=0, `Money`=0, `posX`=131.999, `posY", callback: "(null)", format: "(null)"
[13:52:49] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[13:52:49] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 22.90 milliseconds
[13:52:49] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving

server_log.txt
Quote:

----------
Loaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3z-R4, ©2005-2014 SA-MP Team

[13:51:59] filterscripts = "" (string)
[13:51:59]
[13:51:59] Server Plugins
[13:51:59] --------------
[13:51:59] Loading plugin: mysql
[13:51:59] >> plugin.mysql: R39-2 successfully loaded.
[13:51:59] Loaded.
[13:51:59] Loading plugin: Whirlpool
[13:51:59]
[13:51:59] ==================
[13:51:59]
[13:51:59] Whirlpool loaded
[13:51:59]
[13:51:59] ==================
[13:51:59]
[13:51:59] Loaded.
[13:51:59] Loaded 2 plugins.

[13:51:59]
[13:51:59] Filterscripts
[13:51:59] ---------------
[13:51:59] Loaded 0 filterscripts.

[13:51:59] main() has been called.
[13:51:59] Number of vehicle models: 0
[13:52:38] Incoming connection: 127.0.0.1:51323
[13:52:38] [join] aaa has joined the server (0:127.0.0.1)
[13:52:43] New account registered. ID: 3
[13:52:49] [part] aaa has left the server (0:1)

Here is my .pwn file, it compiles without any issues:
http://pastebin.com/FRp2Jw6k

Thanks in advance if you help me, sorry if this post is too long!
Reply


Messages In This Thread
MySQL Registration System [Threaded Queries + Whirlpool] - by newbienoob - 05.01.2014, 05:36
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - by SyntaxQ - 05.01.2014, 05:46
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - by Ryan_Bowe - 05.01.2014, 07:19
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - by Lordzy - 05.01.2014, 07:27
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - by iZN - 05.01.2014, 07:30
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - by newbienoob - 05.01.2014, 09:51
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - by dusk - 05.01.2014, 10:34
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - by ]Rafaellos[ - 06.01.2014, 07:08
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - by iZN - 06.01.2014, 07:20
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - by Vince - 06.01.2014, 10:10
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - by Konstantinos - 06.01.2014, 10:34
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - by maddinat0r - 06.01.2014, 16:33
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - by anou1 - 06.01.2014, 19:19
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - by Konstantinos - 06.01.2014, 19:40
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - by anou1 - 06.01.2014, 19:44
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - by newbienoob - 07.01.2014, 03:04
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - by anou1 - 07.01.2014, 18:26
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - by iZN - 07.01.2014, 18:59
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - by anou1 - 07.01.2014, 19:05
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - by PowerPC603 - 27.01.2014, 13:20
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - by Konstantinos - 27.01.2014, 13:33
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - by Konstantinos - 04.02.2014, 21:00
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - by Blast3r - 04.02.2014, 21:08
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - by PowerPC603 - 04.02.2014, 21:36
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - by Dorito - 08.02.2014, 07:07
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - by Zinedine - 08.02.2014, 16:18
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - by Konstantinos - 08.02.2014, 16:23
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - by Zinedine - 08.02.2014, 16:25
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - by Zinedine - 09.02.2014, 00:12
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - by Ryan_Undering - 20.02.2014, 17:21
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - by Konstantinos - 20.02.2014, 17:29
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - by jordyvc - 25.03.2014, 16:04
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - by Konstantinos - 25.03.2014, 16:13
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - by newbienoob - 25.03.2014, 16:17
Re : MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - by Cam972 - 25.03.2014, 17:01
Re: Re : MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - by newbienoob - 25.03.2014, 17:18
Re : MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - by Cam972 - 25.03.2014, 18:10
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - by Konstantinos - 25.03.2014, 19:50
Re : MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - by Cam972 - 28.03.2014, 17:53
Re : MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - by Cam972 - 30.03.2014, 17:04
Re : MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - by Maxime_Creteur - 05.04.2014, 07:50
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - by Thomixio - 24.07.2014, 17:40
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - by adithegman - 25.08.2014, 09:04
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - by FlipperK119 - 29.08.2014, 22:12
AW: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - by klaus1n3 - 21.09.2014, 03:20
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - by JeaSon - 21.09.2014, 05:29
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - by TakeiT - 21.09.2014, 06:03
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - by Baltimore - 21.09.2014, 13:52
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - by WopsS - 21.09.2014, 13:53
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - by Baltimore - 21.09.2014, 14:05
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - by JeaSon - 22.09.2014, 06:29
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - by StegooPs - 25.09.2014, 11:02
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - by Justinclaveria123 - 10.10.2014, 08:39
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - by zwoorelook - 11.10.2014, 17:03
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - by Vince - 11.10.2014, 18:31
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - by Ryz - 06.01.2015, 04:55
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - by Bondage - 13.01.2015, 13:54
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - by AgusZ - 16.01.2015, 05:54
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - by VenomMancer - 01.02.2015, 12:16
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - by Nicker - 01.02.2015, 12:41
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - by VenomMancer - 02.02.2015, 10:25
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - by AchievementMaster360 - 05.03.2015, 02:24
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - by AroseKhanNiazi - 09.03.2015, 10:05
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - by Dorito - 21.03.2015, 09:26
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - by BR3TT - 30.03.2015, 13:57
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - by BleverCastard - 30.03.2015, 15:01
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - by BR3TT - 30.03.2015, 22:56
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - by naveen - 20.04.2015, 10:21
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - by BleverCastard - 20.04.2015, 15:50
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - by naveen - 04.05.2015, 14:18
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - by DarkLouis - 07.05.2015, 16:26
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - by Konstantinos - 07.05.2015, 16:29
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - by DarkLouis - 07.05.2015, 16:31
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - by DarkLouis - 07.05.2015, 16:38
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - by DarkLouis - 07.05.2015, 16:59
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - by BigGroter - 16.05.2015, 23:24
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - by Jihanz - 14.11.2015, 12:55
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - by Celirius - 15.04.2016, 22:35
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - by BennyX - 26.12.2016, 18:31

Forum Jump:


Users browsing this thread: 2 Guest(s)