MySQL Little help
#1

Can someone please tell me what am I missing? Here's what the problem, every time I register from the server it seems like it doesn't save from the database. So everytime I exit the game and reconnect it always bring me to register screen.

Код:
[18:01:51] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[18:01:51] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[18:01:51] [DEBUG] CMySQLConnection::Connect - connection was successful
[18:01:51] [DEBUG] CMySQLConnection::Connect - connection was successful
[18:01:51] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[18:01:51] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[18:01:51] [DEBUG] CMySQLConnection::Connect - connection was successful
[18:01:51] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[18:01:52] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `tehserverz1351` WHERE `Server` = '1';", callback: "Safe_LoadServerStats", format: "(null)"
[18:01:52] [DEBUG] mysql_format - connection: 1, len: 256, format: "UPDATE `tehserverz1351` SET `Last_Restarted_Time` = '%s', `Last_Restarted_Date` = '%s' WHERE `Server` = '1';"
[18:01:52] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `tehserverz1351` SET `Last_Restarted_Time` = '18:1:52', `", callback: "(null)", format: "(null)"
[18:01:52] [DEBUG] CMySQLQuery::Execute[Safe_LoadServerStats] - starting query execution
[18:01:52] [ERROR] CMySQLQuery::Execute[Safe_LoadServerStats] - (error #1146) Table 'propowner.tehserverz1351' doesn't exist
[18:01:52] [DEBUG] CMySQLQuery::Execute[Safe_LoadServerStats] - error will be triggered in OnQueryError
[18:01:52] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[18:01:52] [DEBUG] Calling callback "OnQueryError"..
[18:01:52] [ERROR] CMySQLQuery::Execute[] - (error #1146) Table 'propowner.tehserverz1351' doesn't exist
[18:05:15] [DEBUG] mysql_errno - connection: 1
[18:05:15] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `tehserverz1351` WHERE `Server` = '1';", callback: "Safe_LoadServerStats", format: "(null)"
[18:05:15] [DEBUG] mysql_format - connection: 1, len: 256, format: "UPDATE `tehserverz1351` SET `Last_Restarted_Time` = '%s', `Last_Restarted_Date` = '%s' WHERE `Server` = '1';"
[18:05:15] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `tehserverz1351` SET `Last_Restarted_Time` = '18:5:15', `", callback: "(null)", format: "(null)"
[18:05:15] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[18:05:15] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[18:05:15] [DEBUG] CMySQLConnection::Connect - connection was successful
[18:05:15] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[18:05:15] [DEBUG] CMySQLConnection::Connect - connection was successful
[18:05:15] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[18:05:15] [DEBUG] CMySQLConnection::Connect - connection was successful
[18:05:15] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[18:05:15] [DEBUG] CMySQLQuery::Execute[Safe_LoadServerStats] - starting query execution
[18:05:15] [ERROR] CMySQLQuery::Execute[Safe_LoadServerStats] - (error #1146) Table 'propowner.tehserverz1351' doesn't exist
[18:05:15] [DEBUG] CMySQLQuery::Execute[Safe_LoadServerStats] - error will be triggered in OnQueryError
[18:05:15] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[18:05:15] [ERROR] CMySQLQuery::Execute[] - (error #1146) Table 'propowner.tehserverz1351' doesn't exist
[18:05:15] [DEBUG] Calling callback "OnQueryError"..
[18:05:54] [DEBUG] mysql_format - connection: 1, len: 158, format: "SELECT AccountID, Password, Banned, IP FROM `tehuzerz1351` WHERE Username = '%e' LIMIT 1"
[18:05:54] [DEBUG] mysql_tquery - connection: 1, query: "SELECT AccountID, Password, Banned, IP FROM `tehuzerz1351` WHERE", callback: "CheckAccount", format: "i"
[18:05:54] [DEBUG] CMySQLQuery::Execute[CheckAccount] - starting query execution
[18:05:54] [DEBUG] CMySQLQuery::Execute[CheckAccount] - query was successfully executed within 0.359 milliseconds
[18:05:54] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[18:05:54] [DEBUG] Calling callback "CheckAccount"..
[18:05:54] [DEBUG] cache_get_data - connection: 1
[18:05:54] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[18:06:26] [DEBUG] mysql_tquery - connection: 1, query: "INSERT INTO `tehuzerz1351` (Username, Password, IP, Score, Cash,", callback: "(null)", format: "(null)"
[18:06:26] [DEBUG] mysql_format - connection: 1, len: 128, format: "UPDATE `tehserverz1351` SET `Total_Users` = '%i' WHERE Server = '1';"
[18:06:26] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `tehserverz1351` SET `Total_Users` = '1' WHERE Server = '", callback: "(null)", format: "(null)"
[18:06:26] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[18:06:26] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''1' at line 1
[18:06:26] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[18:06:26] [ERROR] CMySQLQuery::Execute[] - (error #1146) Table 'propowner.tehserverz1351' doesn't exist
[18:14:08] [DEBUG] mysql_format - connection: 1, len: 620, format: "UPDATE `tehuzerz1351` SET Admin = '%i', VIP = '%i', LastActive = '%s', Cash = '%i', Score = '%i', Kills = '%i', Deaths = '%i', S..."
[18:14:08] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `tehuzerz1351` SET Admin = '0', VIP = '0', LastActive = '", callback: "(null)", format: "(null)"
[18:14:08] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[18:14:08] [ERROR] CMySQLQuery::Execute[] - (error #1054) Unknown column 'Bounce' in 'field list'
[18:59:08] [DEBUG] mysql_errno - connection: 1
[18:59:08] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `tehserverz1351` WHERE `Server` = '1';", callback: "Safe_LoadServerStats", format: "(null)"
[18:59:08] [DEBUG] mysql_format - connection: 1, len: 256, format: "UPDATE `tehserverz1351` SET `Last_Restarted_Time` = '%s', `Last_Restarted_Date` = '%s' WHERE `Server` = '1';"
[18:59:08] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `tehserverz1351` SET `Last_Restarted_Time` = '18:59:8', `", callback: "(null)", format: "(null)"
[18:59:08] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[18:59:08] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[18:59:08] [DEBUG] CMySQLConnection::Connect - connection was successful
[18:59:08] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[18:59:08] [DEBUG] CMySQLConnection::Connect - connection was successful
[18:59:08] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[18:59:08] [DEBUG] CMySQLConnection::Connect - connection was successful
[18:59:08] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[18:59:08] [DEBUG] CMySQLQuery::Execute[Safe_LoadServerStats] - starting query execution
[18:59:08] [ERROR] CMySQLQuery::Execute[Safe_LoadServerStats] - (error #1146) Table 'propowner.tehserverz1351' doesn't exist
[18:59:08] [DEBUG] CMySQLQuery::Execute[Safe_LoadServerStats] - error will be triggered in OnQueryError
[18:59:08] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[18:59:08] [ERROR] CMySQLQuery::Execute[] - (error #1146) Table 'propowner.tehserverz1351' doesn't exist
[18:59:08] [DEBUG] Calling callback "OnQueryError"..
[19:03:06] [DEBUG] mysql_format - connection: 1, len: 158, format: "SELECT AccountID, Password, Banned, IP FROM `tehuzerz1351` WHERE Username = '%e' LIMIT 1"
[19:03:06] [DEBUG] mysql_tquery - connection: 1, query: "SELECT AccountID, Password, Banned, IP FROM `tehuzerz1351` WHERE", callback: "CheckAccount", format: "i"
[19:03:06] [DEBUG] CMySQLQuery::Execute[CheckAccount] - starting query execution
[19:03:06] [DEBUG] CMySQLQuery::Execute[CheckAccount] - query was successfully executed within 1.312 milliseconds
[19:03:06] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[19:03:06] [DEBUG] Calling callback "CheckAccount"..
[19:03:06] [DEBUG] cache_get_data - connection: 1
[19:03:06] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[19:03:43] [DEBUG] mysql_tquery - connection: 1, query: "INSERT INTO `tehuzerz1351` (Username, Password, IP, Score, Cash,", callback: "(null)", format: "(null)"
[19:03:43] [DEBUG] mysql_format - connection: 1, len: 128, format: "UPDATE `tehserverz1351` SET `Total_Users` = '%i' WHERE Server = '1';"
[19:03:43] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `tehserverz1351` SET `Total_Users` = '1' WHERE Server = '", callback: "(null)", format: "(null)"
[19:03:43] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[19:03:43] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''1' at line 1
[19:03:43] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[19:03:43] [ERROR] CMySQLQuery::Execute[] - (error #1146) Table 'propowner.tehserverz1351' doesn't exist
[19:03:56] [DEBUG] mysql_format - connection: 1, len: 620, format: "UPDATE `tehuzerz1351` SET Admin = '%i', VIP = '%i', LastActive = '%s', Cash = '%i', Score = '%i', Kills = '%i', Deaths = '%i', S..."
[19:03:56] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `tehuzerz1351` SET Admin = '0', VIP = '0', LastActive = '", callback: "(null)", format: "(null)"
[19:03:56] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[19:03:56] [ERROR] CMySQLQuery::Execute[] - (error #1054) Unknown column 'Bounce' in 'field list'
Reply


Messages In This Thread
MySQL Little help - by iBanner - 11.02.2015, 14:38
Re: MySQL Little help - by kevin1990 - 11.02.2015, 15:26
Re: MySQL Little help - by kevin1990 - 11.02.2015, 15:34
Re: MySQL Little help - by iBanner - 11.02.2015, 16:45
Re: MySQL Little help - by kevin1990 - 11.02.2015, 17:17
Re: MySQL Little help - by iBanner - 11.02.2015, 18:39
Re: MySQL Little help - by kevin1990 - 11.02.2015, 18:49

Forum Jump:


Users browsing this thread: 1 Guest(s)