11.11.2014, 18:58
The Script part: http://pastebin.com/q5BFdcCa
Line 25, where the problem starts.
Mysql Log:
[21:42:15] [DEBUG] mysql_format - connection: 1, len: 128, format: "SELECT `Parool`, `ID` FROM `kasutajad` WHERE `Kasutajanimi` = '%e' LIMIT 1"
[21:42:15] [DEBUG] mysql_tquery - connection: 1, query: "SELECT `Parool`, `ID` FROM `kasutajad` WHERE `Kasutajanimi` = 'T", callback: "KasutajaKontroll", format: "i"
[21:42:15] [DEBUG] CMySQLQuery::CMySQLQuery() - constructor called
[21:42:15] [DEBUG] mysql_tquery - scheduling query "SELECT `Parool`, `ID` FROM `kasutajad` WHERE `Kasutajanimi` = 'Test1' LIMIT 1"..
[21:42:15] [DEBUG] CMySQLQuery::Execute[KasutajaKontroll(i)] - starting query execution
[21:42:15] [DEBUG] CMySQLQuery::Execute[KasutajaKontroll(i)] - query was successful
[21:42:15] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[21:42:15] [DEBUG] CMySQLQuery::Execute[KasutajaKontroll(i)] - data being passed to ProcessCallbacks()
[21:42:15] [DEBUG] Calling callback "KasutajaKontroll"..
[21:42:15] [DEBUG] cache_get_data - connection: 1
[21:42:15] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[21:42:15] [DEBUG] CMySQLQuery::~CMySQLQuery() - deconstructor called
[21:42:22] [DEBUG] mysql_format - connection: 1, len: 3000, format: "INSERT INTO `kasutajad` (Kasutajanimi, Parool, IP, AdminLevel, VIP, Raha, posX, posY, posZ) VALUES ('%e', '%s', '%s', 0, 0, 0, 0..."
[21:42:22] [DEBUG] mysql_tquery - connection: 1, query: "INSERT INTO `kasutajad` (Kasutajanimi, Parool, IP, AdminLevel, V", callback: "KasutajaRegistreerimine", format: "i"
[21:42:22] [DEBUG] CMySQLQuery::CMySQLQuery() - constructor called
[21:42:22] [DEBUG] mysql_tquery - scheduling query "INSERT INTO `kasutajad` (Kasutajanimi, Parool, IP, AdminLevel, VIP, Raha, posX, posY, posZ) VALUES ('Test1', 'FD9D94340DBD72C11B37EBB0D2A19B4D05E00FD78E4E2CE89 23B9EA3A54E900DF181CFB112A8A73228D1F3551680E2AD970 1A4FCFB248FA7FA77B95180628BB2', '192.168.88.252', 0, 0, 0, 0.0, 0.0, 0.0"..
[21:42:22] [DEBUG] CMySQLQuery::Execute[KasutajaRegistreerimine(i)] - starting query execution
[21:42:22] [ERROR] CMySQLQuery::Execute[KasutajaRegistreerimine(i)] - (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 '' at line 1
[21:42:22] [DEBUG] CMySQLQuery::Execute[KasutajaRegistreerimine(i)] - error will be triggered in OnQueryError
[21:42:22] [DEBUG] CMySQLQuery::Execute[KasutajaRegistreerimine(i)] - data being passed to ProcessCallbacks()
[21:42:22] [DEBUG] CMySQLQuery::~CMySQLQuery() - deconstructor called
What have i missed ?
Line 25, where the problem starts.
Mysql Log:
[21:42:15] [DEBUG] mysql_format - connection: 1, len: 128, format: "SELECT `Parool`, `ID` FROM `kasutajad` WHERE `Kasutajanimi` = '%e' LIMIT 1"
[21:42:15] [DEBUG] mysql_tquery - connection: 1, query: "SELECT `Parool`, `ID` FROM `kasutajad` WHERE `Kasutajanimi` = 'T", callback: "KasutajaKontroll", format: "i"
[21:42:15] [DEBUG] CMySQLQuery::CMySQLQuery() - constructor called
[21:42:15] [DEBUG] mysql_tquery - scheduling query "SELECT `Parool`, `ID` FROM `kasutajad` WHERE `Kasutajanimi` = 'Test1' LIMIT 1"..
[21:42:15] [DEBUG] CMySQLQuery::Execute[KasutajaKontroll(i)] - starting query execution
[21:42:15] [DEBUG] CMySQLQuery::Execute[KasutajaKontroll(i)] - query was successful
[21:42:15] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[21:42:15] [DEBUG] CMySQLQuery::Execute[KasutajaKontroll(i)] - data being passed to ProcessCallbacks()
[21:42:15] [DEBUG] Calling callback "KasutajaKontroll"..
[21:42:15] [DEBUG] cache_get_data - connection: 1
[21:42:15] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[21:42:15] [DEBUG] CMySQLQuery::~CMySQLQuery() - deconstructor called
[21:42:22] [DEBUG] mysql_format - connection: 1, len: 3000, format: "INSERT INTO `kasutajad` (Kasutajanimi, Parool, IP, AdminLevel, VIP, Raha, posX, posY, posZ) VALUES ('%e', '%s', '%s', 0, 0, 0, 0..."
[21:42:22] [DEBUG] mysql_tquery - connection: 1, query: "INSERT INTO `kasutajad` (Kasutajanimi, Parool, IP, AdminLevel, V", callback: "KasutajaRegistreerimine", format: "i"
[21:42:22] [DEBUG] CMySQLQuery::CMySQLQuery() - constructor called
[21:42:22] [DEBUG] mysql_tquery - scheduling query "INSERT INTO `kasutajad` (Kasutajanimi, Parool, IP, AdminLevel, VIP, Raha, posX, posY, posZ) VALUES ('Test1', 'FD9D94340DBD72C11B37EBB0D2A19B4D05E00FD78E4E2CE89 23B9EA3A54E900DF181CFB112A8A73228D1F3551680E2AD970 1A4FCFB248FA7FA77B95180628BB2', '192.168.88.252', 0, 0, 0, 0.0, 0.0, 0.0"..
[21:42:22] [DEBUG] CMySQLQuery::Execute[KasutajaRegistreerimine(i)] - starting query execution
[21:42:22] [ERROR] CMySQLQuery::Execute[KasutajaRegistreerimine(i)] - (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 '' at line 1
[21:42:22] [DEBUG] CMySQLQuery::Execute[KasutajaRegistreerimine(i)] - error will be triggered in OnQueryError
[21:42:22] [DEBUG] CMySQLQuery::Execute[KasutajaRegistreerimine(i)] - data being passed to ProcessCallbacks()
[21:42:22] [DEBUG] CMySQLQuery::~CMySQLQuery() - deconstructor called
What have i missed ?