Error mysql - Printable Version
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Error mysql (/showthread.php?tid=612069)
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Error mysql (/showthread.php?tid=612069)
Error mysql - Izaki - 13.07.2016
PHP код:
[03:25:08] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1
[03:25:08] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
Re: Error mysql - Untonyst - 13.07.2016
Show your SQl query. Is it possible you put an extra comma.
Re: Error mysql - Izaki - 13.07.2016
PHP код:
mysql_format(mysql, query, sizeof(query), "UPDATE `database` SET `pEXP` = %d, `Premium` = %d, `pAdminLevel` = %d,",
pInfo[playerid][pEXP], pInfo[playerid][Premium], pInfo[playerid][pAdminLevel]);
mysql_tquery(mysql, query, "", "");
Re: Error mysql - Untonyst - 13.07.2016
Код:
mysql_format(mysql, query, sizeof(query), "UPDATE `database` SET `pEXP` = %d, `Premium` = %d, `pAdminLevel` = %d,", pInfo[playerid][pEXP], pInfo[playerid][Premium], pInfo[playerid][pAdminLevel]); mysql_tquery(mysql, query, "", "");
Re: Error mysql - Vince - 13.07.2016
Where's the rest of it? A database isn't like a file. You need to specify which row(s) you want to update otherwise it will just ruin all rows in the database.
Re: Error mysql - Izaki - 13.07.2016
[03:57:23] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[03:57:23] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1
[03:57:23] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
error try
Re: Error mysql - Izaki - 13.07.2016
PHP код:
[03:40:14] [DEBUG] mysql_connect - host: "localhost", user: "root", database: "database", password: "****", port: 3306, autoreconnect: true, pool_size: 2
[03:40:14] [DEBUG] CMySQLHandle::Create - creating new connection..
[03:40:14] [DEBUG] CMySQLHandle::CMySQLHandle - constructor called
[03:40:14] [DEBUG] CMySQLHandle::Create - connection created (id: 1)
[03:40:14] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[03:40:14] [DEBUG] CMySQLConnection::Connect - connection was successful
[03:40:14] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[03:40:14] [DEBUG] mysql_errno - connection: 1
[03:40:14] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[03:40:14] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[03:40:14] [DEBUG] CMySQLConnection::Connect - connection was successful
[03:40:14] [DEBUG] CMySQLConnection::Connect - connection was successful
[03:40:14] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[03:40:14] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[03:40:14] [DEBUG] CMySQLConnection::Connect - connection was successful
[03:40:14] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[03:40:38] [DEBUG] mysql_format - connection: 1, len: 128, format: "SELECT `Password`, `ID` FROM `users` WHERE `Name` = '%e' LIMIT 1"
[03:40:38] [DEBUG] mysql_tquery - connection: 1, query: "SELECT `Password`, `ID` FROM `users` WHERE `Name` = 'damar' LIMI", callback: "OnAccountCheck", format: "i"
[03:40:38] [DEBUG] CMySQLQuery::Execute[OnAccountCheck] - starting query execution
[03:40:38] [DEBUG] CMySQLQuery::Execute[OnAccountCheck] - query was successfully executed within 0.396 milliseconds
[03:40:38] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[03:40:38] [DEBUG] Calling callback "OnAccountCheck"..
[03:40:38] [DEBUG] cache_get_data - connection: 1
[03:40:38] [DEBUG] cache_get_field_content - row: 0, field_name: "Password", connection: 1, max_len: 129
[03:40:38] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Password", data: "FD9D94340DBD72C11B37EBB0D2A19B4D05E00FD78E4E2CE8923B9EA3A54E900DF181CFB112A8A73228D1F3551680E2AD9701A4FCFB248FA7FA77B95180628BB2"
[03:40:38] [DEBUG] cache_get_field_content_int - row: 0, field_name: "ID", connection: 1
[03:40:38] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "ID", data: "1"
[03:40:38] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[03:40:43] [DEBUG] mysql_format - connection: 1, len: 100, format: "SELECT * FROM `users` WHERE `Name` = '%e' LIMIT 1"
[03:40:43] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `users` WHERE `Name` = 'damar' LIMIT 1", callback: "OnAccountLoad", format: "i"
[03:40:43] [DEBUG] CMySQLQuery::Execute[OnAccountLoad] - starting query execution
[03:40:43] [DEBUG] CMySQLQuery::Execute[OnAccountLoad] - query was successfully executed within 0.315 milliseconds
[03:40:43] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[03:40:43] [DEBUG] Calling callback "OnAccountLoad"..
[03:40:43] [DEBUG] cache_get_field_content_int - row: 0, field_name: "pAdminLevel", connection: 1
[03:40:43] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "pAdminLevel", data: "0"
[03:40:43] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Premium", connection: 1
[03:40:43] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Premium", data: "0"
[03:40:43] [DEBUG] cache_get_field_content_int - row: 0, field_name: "pEXP", connection: 1
[03:40:43] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "pEXP", data: "0"
[03:40:43] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[03:41:38] [DEBUG] mysql_format - connection: 1, len: 128, format: "SELECT `Password`, `ID` FROM `users` WHERE `Name` = '%e' LIMIT 1"
[03:41:38] [DEBUG] mysql_tquery - connection: 1, query: "SELECT `Password`, `ID` FROM `users` WHERE `Name` = 'damar' LIMI", callback: "OnAccountCheck", format: "i"
[03:41:38] [DEBUG] CMySQLQuery::Execute[OnAccountCheck] - starting query execution
[03:41:38] [DEBUG] CMySQLQuery::Execute[OnAccountCheck] - query was successfully executed within 0.435 milliseconds
[03:41:38] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[03:41:38] [DEBUG] Calling callback "OnAccountCheck"..
[03:41:38] [DEBUG] cache_get_data - connection: 1
[03:41:38] [DEBUG] cache_get_field_content - row: 0, field_name: "Password", connection: 1, max_len: 129
[03:41:38] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Password", data: "FD9D94340DBD72C11B37EBB0D2A19B4D05E00FD78E4E2CE8923B9EA3A54E900DF181CFB112A8A73228D1F3551680E2AD9701A4FCFB248FA7FA77B95180628BB2"
[03:41:38] [DEBUG] cache_get_field_content_int - row: 0, field_name: "ID", connection: 1
[03:41:38] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "ID", data: "1"
[03:41:38] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[03:41:41] [DEBUG] mysql_format - connection: 1, len: 100, format: "SELECT * FROM `users` WHERE `Name` = '%e' LIMIT 1"
[03:41:41] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `users` WHERE `Name` = 'damar' LIMIT 1", callback: "OnAccountLoad", format: "i"
[03:41:41] [DEBUG] CMySQLQuery::Execute[OnAccountLoad] - starting query execution
[03:41:41] [DEBUG] CMySQLQuery::Execute[OnAccountLoad] - query was successfully executed within 0.523 milliseconds
[03:41:41] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[03:41:41] [DEBUG] Calling callback "OnAccountLoad"..
[03:41:41] [DEBUG] cache_get_field_content_int - row: 0, field_name: "pAdminLevel", connection: 1
[03:41:41] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "pAdminLevel", data: "0"
[03:41:41] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Premium", connection: 1
[03:41:41] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Premium", data: "0"
[03:41:41] [DEBUG] cache_get_field_content_int - row: 0, field_name: "pEXP", connection: 1
[03:41:41] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "pEXP", data: "0"
[03:41:41] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[03:49:25] [DEBUG] mysql_connect - host: "localhost", user: "root", database: "database", password: "****", port: 3306, autoreconnect: true, pool_size: 2
[03:49:25] [DEBUG] CMySQLHandle::Create - creating new connection..
[03:49:25] [WARNING] CMySQLHandle::Create - connection already exists
[03:49:25] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[03:49:25] [DEBUG] CMySQLConnection::Connect - connection was successful
[03:49:25] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[03:49:25] [DEBUG] mysql_errno - connection: 1
[03:49:25] [DEBUG] mysql_format - connection: 1, len: 128, format: "SELECT `Password`, `ID` FROM `users` WHERE `Name` = '%e' LIMIT 1"
[03:49:25] [DEBUG] mysql_tquery - connection: 1, query: "SELECT `Password`, `ID` FROM `users` WHERE `Name` = 'damar' LIMI", callback: "OnAccountCheck", format: "i"
[03:49:25] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[03:49:25] [DEBUG] CMySQLConnection::Connect - connection was successful
[03:49:25] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[03:49:25] [DEBUG] CMySQLQuery::Execute[OnAccountCheck] - starting query execution
[03:49:25] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[03:49:25] [DEBUG] CMySQLConnection::Connect - connection was successful
[03:49:25] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[03:49:25] [DEBUG] CMySQLQuery::Execute[OnAccountCheck] - query was successfully executed within 0.703 milliseconds
[03:49:25] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[03:49:25] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[03:49:25] [DEBUG] CMySQLConnection::Connect - connection was successful
[03:49:25] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[03:49:25] [DEBUG] Calling callback "OnAccountCheck"..
[03:49:25] [DEBUG] cache_get_data - connection: 1
[03:49:25] [DEBUG] cache_get_field_content - row: 0, field_name: "Password", connection: 1, max_len: 129
[03:49:25] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Password", data: "FD9D94340DBD72C11B37EBB0D2A19B4D05E00FD78E4E2CE8923B9EA3A54E900DF181CFB112A8A73228D1F3551680E2AD9701A4FCFB248FA7FA77B95180628BB2"
[03:49:25] [DEBUG] cache_get_field_content_int - row: 0, field_name: "ID", connection: 1
[03:49:25] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "ID", data: "1"
[03:49:25] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[03:50:00] [DEBUG] mysql_format - connection: 1, len: 100, format: "SELECT * FROM `users` WHERE `Name` = '%e' LIMIT 1"
[03:50:00] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `users` WHERE `Name` = 'damar' LIMIT 1", callback: "OnAccountLoad", format: "i"
[03:50:00] [DEBUG] CMySQLQuery::Execute[OnAccountLoad] - starting query execution
[03:50:00] [DEBUG] CMySQLQuery::Execute[OnAccountLoad] - query was successfully executed within 0.470 milliseconds
[03:50:00] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[03:50:00] [DEBUG] Calling callback "OnAccountLoad"..
[03:50:00] [DEBUG] cache_get_field_content_int - row: 0, field_name: "pAdminLevel", connection: 1
[03:50:00] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "pAdminLevel", data: "0"
[03:50:00] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Premium", connection: 1
[03:50:00] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Premium", data: "0"
[03:50:00] [DEBUG] cache_get_field_content_int - row: 0, field_name: "pEXP", connection: 1
[03:50:00] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "pEXP", data: "0"
[03:50:00] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[03:50:38] [DEBUG] mysql_format - connection: 1, len: 128, format: "UPDATE `database` SET `pEXP` = %d, `Premium` = %d, `pAdminLevel` = %d,"
[03:50:38] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `database` SET `pEXP` = 0, `Premium` = 0, `pAdminLevel` =", callback: "(null)", format: "(null)"
[03:50:38] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[03:50:38] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1
[03:50:38] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[03:50:50] [DEBUG] mysql_connect - host: "localhost", user: "root", database: "database", password: "****", port: 3306, autoreconnect: true, pool_size: 2
[03:50:50] [DEBUG] CMySQLHandle::Create - creating new connection..
[03:50:50] [WARNING] CMySQLHandle::Create - connection already exists
[03:50:50] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[03:50:50] [DEBUG] CMySQLConnection::Connect - connection was successful
[03:50:50] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[03:50:50] [DEBUG] mysql_errno - connection: 1
[03:50:50] [DEBUG] mysql_format - connection: 1, len: 128, format: "SELECT `Password`, `ID` FROM `users` WHERE `Name` = '%e' LIMIT 1"
[03:50:50] [DEBUG] mysql_tquery - connection: 1, query: "SELECT `Password`, `ID` FROM `users` WHERE `Name` = 'damar' LIMI", callback: "OnAccountCheck", format: "i"
[03:50:50] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[03:50:50] [DEBUG] CMySQLConnection::Connect - connection was successful
[03:50:50] [DEBUG] CMySQLConnection::Connect - connection was successful
[03:50:50] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[03:50:50] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[03:50:50] [DEBUG] CMySQLQuery::Execute[OnAccountCheck] - starting query execution
[03:50:50] [DEBUG] CMySQLQuery::Execute[OnAccountCheck] - query was successfully executed within 0.384 milliseconds
[03:50:50] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[03:50:50] [DEBUG] Calling callback "OnAccountCheck"..
[03:50:50] [DEBUG] cache_get_data - connection: 1
[03:50:50] [DEBUG] cache_get_field_content - row: 0, field_name: "Password", connection: 1, max_len: 129
[03:50:50] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Password", data: "FD9D94340DBD72C11B37EBB0D2A19B4D05E00FD78E4E2CE8923B9EA3A54E900DF181CFB112A8A73228D1F3551680E2AD9701A4FCFB248FA7FA77B95180628BB2"
[03:50:50] [DEBUG] cache_get_field_content_int - row: 0, field_name: "ID", connection: 1
[03:50:50] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "ID", data: "1"
[03:50:50] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[03:50:50] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[03:50:50] [DEBUG] CMySQLConnection::Connect - connection was successful
[03:50:50] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[03:50:52] [DEBUG] mysql_format - connection: 1, len: 100, format: "SELECT * FROM `users` WHERE `Name` = '%e' LIMIT 1"
[03:50:52] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `users` WHERE `Name` = 'damar' LIMIT 1", callback: "OnAccountLoad", format: "i"
[03:50:52] [DEBUG] CMySQLQuery::Execute[OnAccountLoad] - starting query execution
[03:50:52] [DEBUG] CMySQLQuery::Execute[OnAccountLoad] - query was successfully executed within 0.402 milliseconds
[03:50:52] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[03:50:52] [DEBUG] Calling callback "OnAccountLoad"..
[03:50:52] [DEBUG] cache_get_field_content_int - row: 0, field_name: "pAdminLevel", connection: 1
[03:50:52] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "pAdminLevel", data: "0"
[03:50:52] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Premium", connection: 1
[03:50:52] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Premium", data: "0"
[03:50:52] [DEBUG] cache_get_field_content_int - row: 0, field_name: "pEXP", connection: 1
[03:50:52] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "pEXP", data: "0"
[03:50:52] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[03:56:11] [DEBUG] mysql_format - connection: 1, len: 128, format: "UPDATE `database` SET `pEXP` = %d, `Premium` = %d, `pAdminLevel` = %d,"
[03:56:11] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `database` SET `pEXP` = 1000, `Premium` = 0, `pAdminLevel", callback: "(null)", format: "(null)"
[03:56:11] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[03:56:11] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1
[03:56:11] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[03:56:43] [DEBUG] mysql_connect - host: "localhost", user: "root", database: "database", password: "****", port: 3306, autoreconnect: true, pool_size: 2
[03:56:43] [DEBUG] CMySQLHandle::Create - creating new connection..
[03:56:43] [DEBUG] CMySQLHandle::CMySQLHandle - constructor called
[03:56:43] [DEBUG] CMySQLHandle::Create - connection created (id: 1)
[03:56:43] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[03:56:43] [DEBUG] CMySQLConnection::Connect - connection was successful
[03:56:43] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[03:56:43] [DEBUG] mysql_errno - connection: 1
[03:56:43] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[03:56:43] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[03:56:43] [DEBUG] CMySQLConnection::Connect - connection was successful
[03:56:43] [DEBUG] CMySQLConnection::Connect - connection was successful
[03:56:43] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[03:56:43] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[03:56:43] [DEBUG] CMySQLConnection::Connect - connection was successful
[03:56:43] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[03:57:09] [DEBUG] mysql_format - connection: 1, len: 128, format: "SELECT `Password`, `ID` FROM `users` WHERE `Name` = '%e' LIMIT 1"
[03:57:09] [DEBUG] mysql_tquery - connection: 1, query: "SELECT `Password`, `ID` FROM `users` WHERE `Name` = 'damar' LIMI", callback: "OnAccountCheck", format: "i"
[03:57:09] [DEBUG] CMySQLQuery::Execute[OnAccountCheck] - starting query execution
[03:57:10] [DEBUG] CMySQLQuery::Execute[OnAccountCheck] - query was successfully executed within 51.862 milliseconds
[03:57:10] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[03:57:10] [DEBUG] Calling callback "OnAccountCheck"..
[03:57:10] [DEBUG] cache_get_data - connection: 1
[03:57:10] [DEBUG] cache_get_field_content - row: 0, field_name: "Password", connection: 1, max_len: 129
[03:57:10] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Password", data: "FD9D94340DBD72C11B37EBB0D2A19B4D05E00FD78E4E2CE8923B9EA3A54E900DF181CFB112A8A73228D1F3551680E2AD9701A4FCFB248FA7FA77B95180628BB2"
[03:57:10] [DEBUG] cache_get_field_content_int - row: 0, field_name: "ID", connection: 1
[03:57:10] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "ID", data: "1"
[03:57:10] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[03:57:14] [DEBUG] mysql_format - connection: 1, len: 100, format: "SELECT * FROM `users` WHERE `Name` = '%e' LIMIT 1"
[03:57:14] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `users` WHERE `Name` = 'damar' LIMIT 1", callback: "OnAccountLoad", format: "i"
[03:57:14] [DEBUG] CMySQLQuery::Execute[OnAccountLoad] - starting query execution
[03:57:14] [DEBUG] CMySQLQuery::Execute[OnAccountLoad] - query was successfully executed within 0.400 milliseconds
[03:57:14] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[03:57:14] [DEBUG] Calling callback "OnAccountLoad"..
[03:57:14] [DEBUG] cache_get_field_content_int - row: 0, field_name: "pAdminLevel", connection: 1
[03:57:14] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "pAdminLevel", data: "0"
[03:57:14] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Premium", connection: 1
[03:57:14] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Premium", data: "0"
[03:57:14] [DEBUG] cache_get_field_content_int - row: 0, field_name: "pEXP", connection: 1
[03:57:14] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "pEXP", data: "0"
[03:57:14] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[03:57:23] [DEBUG] mysql_format - connection: 1, len: 128, format: "UPDATE `database` SET `pEXP` = %d, `Premium` = %d, `pAdminLevel` = %d,"
[03:57:23] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `database` SET `pEXP` = 1000, `Premium` = 0, `pAdminLevel", callback: "(null)", format: "(null)"
[03:57:23] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[03:57:23] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1
[03:57:23] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError