1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help

Threaded Mode
Error mysql
Izaki
Big Clucker
***
Posts: 81
Threads: 38
Joined: Sep 2014
Reputation: 0
#1

13.07.2016, 20:36
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 
please help
Find
Reply
Untonyst
Big Clucker
***
Posts: 65
Threads: 3
Joined: Dec 2015
Reputation: 0
#2

13.07.2016, 20:45
Show your SQl query. Is it possible you put an extra comma.
Find
Reply
Izaki
Big Clucker
***
Posts: 81
Threads: 38
Joined: Sep 2014
Reputation: 0
#3

13.07.2016, 20:47
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, "", ""); 
Find
Reply
Untonyst
Big Clucker
***
Posts: 65
Threads: 3
Joined: Dec 2015
Reputation: 0
#4

13.07.2016, 20:53
Код:
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, "", "");
Find
Reply
Vince
Spam Machine
*****
Posts: 10,066
Threads: 38
Joined: Sep 2007
Reputation: 0
#5

13.07.2016, 20:57
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.
Find
Reply
Izaki
Big Clucker
***
Posts: 81
Threads: 38
Joined: Sep 2014
Reputation: 0
#6

13.07.2016, 20:59
[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
Find
Reply
Izaki
Big Clucker
***
Posts: 81
Threads: 38
Joined: Sep 2014
Reputation: 0
#7

13.07.2016, 21:03
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 
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


Users browsing this thread: 1 Guest(s)
  1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help