mysql problem
#9

Ok fixed the long query, now it shows the register dialog. But i get the same problem of the first post. It asks me everytime to register again.

mysq_log:

Quote:

[13:00:41] [DEBUG] CMySQLConnection::Connect - connection was successful
[13:00:41] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[13:00:41] [DEBUG] CMySQLConnection::Connect - connection was successful
[13:00:41] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[13:00:41] [DEBUG] mysql_errno - connection: 1
[13:01:02] [DEBUG] mysql_format - connection: 1, len: 128, format: "SELECT * FROM `playerdata` WHERE `user` = '%e' LIMIT 1"
[13:01:02] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `playerdata` WHERE `user` = 'uihuhuguhhlllll' LIMI", callback: "OnAccountCheck", format: "i"
[13:01:02] [DEBUG] CMySQLQuery::CMySQLQuery() - constructor called
[13:01:02] [DEBUG] mysql_tquery - scheduling query "SELECT * FROM `playerdata` WHERE `user` = 'uihuhuguhhlllll' LIMIT 1"..
[13:01:02] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `Bans` WHERE (`Username` = 'uihuhuguhhlllll' OR `I", callback: "(null)", format: "(null)"
[13:01:02] [DEBUG] CMySQLQuery::CMySQLQuery() - constructor called
[13:01:02] [DEBUG] mysql_tquery - scheduling query "SELECT * FROM `Bans` WHERE (`Username` = 'uihuhuguhhlllll' OR `IP` = '192.168.1.3') AND `Banned` = 1 LIMIT 1"..
[13:01:02] [DEBUG] cache_get_row_count - connection: 1
[13:01:02] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE ServerStats SET TotalJoins = TotalJoins + 1", callback: "(null)", format: "(null)"
[13:01:02] [DEBUG] CMySQLQuery::CMySQLQuery() - constructor called
[13:01:02] [DEBUG] mysql_tquery - scheduling query "UPDATE ServerStats SET TotalJoins = TotalJoins + 1"..
[13:01:02] [DEBUG] CMySQLQuery::Execute[OnAccountCheck(i)] - starting query execution
[13:01:02] [DEBUG] CMySQLQuery::Execute[OnAccountCheck(i)] - query was successful
[13:01:02] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[13:01:02] [DEBUG] CMySQLQuery::Execute[OnAccountCheck(i)] - data being passed to ProcessCallbacks()
[13:01:02] [DEBUG] CMySQLQuery::Execute[()] - starting query execution
[13:01:02] [DEBUG] Calling callback "OnAccountCheck"..
[13:01:02] [DEBUG] cache_get_data - connection: 1
[13:01:02] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[13:01:02] [DEBUG] CMySQLQuery::~CMySQLQuery() - deconstructor called
[13:01:02] [DEBUG] CMySQLQuery::Execute[()] - query was successful
[13:01:02] [DEBUG] CMySQLQuery::Execute[()] - no callback specified, skipping result saving
[13:01:02] [DEBUG] CMySQLQuery::Execute[()] - data being passed to ProcessCallbacks()
[13:01:02] [DEBUG] CMySQLQuery::Execute[()] - starting query execution
[13:01:02] [DEBUG] CMySQLQuery::~CMySQLQuery() - deconstructor called
[13:01:02] [DEBUG] CMySQLQuery::Execute[()] - query was successful
[13:01:02] [DEBUG] CMySQLQuery::Execute[()] - no callback specified, skipping result saving
[13:01:02] [DEBUG] CMySQLQuery::Execute[()] - data being passed to ProcessCallbacks()
[13:01:02] [DEBUG] CMySQLQuery::~CMySQLQuery() - deconstructor called
[13:01:05] [DEBUG] mysql_format - connection: 1, len: 1000, format: "INSERT INTO playerdata(user, password, Scores, Cash, Admin, Deaths, Nopm, Muted, Vip, Warn, RegisterDate, Jailed, AdminActions, ..."
[13:01:05] [DEBUG] mysql_tquery - connection: 1, query: "INSERT INTO playerdata(user, password, Scores, Cash, Admin, Deat", callback: "(null)", format: "(null)"
[13:01:05] [DEBUG] CMySQLQuery::CMySQLQuery() - constructor called
[13:01:05] [DEBUG] mysql_tquery - scheduling query "INSERT INTO playerdata(user, password, Scores, Cash, Admin, Deaths, Nopm, Muted, Vip, Warn, RegisterDate, Jailed, AdminActions, Cookies, Rank, VipTime, Class, PrototypesStolen, KillAsUsaTeam, KillAsGermanyTeam, KillAsItalyTeam, KillAsJapanTeam, KillAsMercTeam, KillAsMexicoTeam, IP, DaysAlive) VALUES('uihuhuguhhlllll', '', 0, 0, 0, 0, 0, 0, 0, 0, '26/1/2014 13:1:5', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '192.168.1.3', '0')"..
[13:01:05] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE ServerStats SET TotalAccounts = TotalAccounts + 1", callback: "(null)", format: "(null)"
[13:01:05] [DEBUG] CMySQLQuery::CMySQLQuery() - constructor called
[13:01:05] [DEBUG] mysql_tquery - scheduling query "UPDATE ServerStats SET TotalAccounts = TotalAccounts + 1"..
[13:01:05] [DEBUG] CMySQLQuery::Execute[()] - starting query execution
[13:01:05] [DEBUG] CMySQLQuery::Execute[()] - error will be triggered in OnQueryError
[13:01:05] [DEBUG] CMySQLQuery::Execute[()] - data being passed to ProcessCallbacks()
[13:01:05] [DEBUG] CMySQLQuery::Execute[()] - starting query execution
[13:01:05] [DEBUG] CMySQLQuery::~CMySQLQuery() - deconstructor called
[13:01:05] [DEBUG] CMySQLQuery::Execute[()] - query was successful
[13:01:05] [DEBUG] CMySQLQuery::Execute[()] - no callback specified, skipping result saving
[13:01:05] [DEBUG] CMySQLQuery::Execute[()] - data being passed to ProcessCallbacks()
[13:01:05] [DEBUG] CMySQLQuery::~CMySQLQuery() - deconstructor called
[13:01:10] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `playerdata` SET Scores='0', Cash='0', Admin='0', Deaths=", callback: "(null)", format: "(null)"
[13:01:10] [DEBUG] CMySQLQuery::CMySQLQuery() - constructor called
[13:01:10] [DEBUG] mysql_tquery - scheduling query "UPDATE `playerdata` SET Scores='0', Cash='0', Admin='0', Deaths='0', Nopm='0', Muted='0', Vip='0', Warn='0', RegisterDate='0', Jailed='0', AdminActions='0', Cookies='0', Rank='0', VipTime='0', Class='0', PrototypesStolen='0', Exp='0', Duty='0', KillAsUsaTeam='0', KillAsGermanyTeam='0', KillAsItalyTeam='0', KillAsJapanTeam='0', KillAsMercTeam='0', KillAsMexicoTeam='0', DaysAlive='0' WHERE user='uihuhuguhhlllll'"..
[13:01:10] [DEBUG] CMySQLQuery::Execute[()] - starting query execution
[13:01:10] [DEBUG] CMySQLQuery::Execute[()] - error will be triggered in OnQueryError
[13:01:10] [DEBUG] CMySQLQuery::Execute[()] - data being passed to ProcessCallbacks()
[13:01:10] [DEBUG] CMySQLQuery::~CMySQLQuery() - deconstructor called

Reply


Messages In This Thread
mysql problem - by Face9000 - 26.01.2014, 09:49
Re: mysql problem - by Misiur - 26.01.2014, 10:00
Re: mysql problem - by Face9000 - 26.01.2014, 10:01
Re: mysql problem - by Misiur - 26.01.2014, 10:16
Re: mysql problem - by Face9000 - 26.01.2014, 10:17
Re: mysql problem - by Misiur - 26.01.2014, 10:24
Re: mysql problem - by Face9000 - 26.01.2014, 10:30
Re: mysql problem - by Misiur - 26.01.2014, 10:37
Re: mysql problem - by Face9000 - 26.01.2014, 10:49
Re: mysql problem - by Misiur - 26.01.2014, 10:57

Forum Jump:


Users browsing this thread: 1 Guest(s)