MySQL Issue
#1

Hello,

I've just started working on a script again after a long break from sa-mp, and it appears an error occurred while I was working on the MySQL part of things.

Код:
[09:49:53] [DEBUG] CMySQLHandle::Create - creating new connection..
[09:49:53] [DEBUG] CMySQLHandle::CMySQLHandle - constructor called
[09:49:53] [DEBUG] CMySQLHandle::Create - connection created (id: 1)
[09:49:53] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[09:49:53] [DEBUG] CMySQLConnection::Connect - connection was successful
[09:49:53] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[09:49:53] [DEBUG] mysql_errno - connection: 1
[09:49:53] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[09:49:53] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[09:49:53] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[09:49:53] [DEBUG] CMySQLConnection::Connect - connection was successful
[09:49:53] [DEBUG] CMySQLConnection::Connect - connection was successful
bled
[09:49:53] [DEBUG] CMySQLConnection::Connect - connection was successful
[09:49:53] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[09:49:53] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[09:52:20] [DEBUG] mysql_format - connection: 1, len: 128, format: "SELECT 'Password', 'PlayerID' FROM 'samp_accounts' WHERE 'Username'='%e' LIMIT 1"
[09:52:20] [DEBUG] mysql_tquery - connection: 1, query: "SELECT 'Password', 'PlayerID' FROM 'samp_accounts' WHERE 'Userna", callback: "OnAccountCheck", format: "i"
[09:52:20] [DEBUG] CMySQLQuery::Execute[OnAccountCheck] - starting query execution
[09:52:20] [ERROR] CMySQLQuery::Execute[OnAccountCheck] - (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 ''samp_accounts' WHERE 'Username'='R' LIMIT 1' at line 1
[09:52:20] [DEBUG] CMySQLQuery::Execute[OnAccountCheck] - error will be triggered in OnQueryError
[09:53:23] [DEBUG] mysql_format - connection: 1, len: 2048, format: "UPDATE 'samp_accounts' SET 'MaskOn'='%d', 'Admin'='%d', 'Helper'='%d', 'Money'='%d', 'Level'='%d', 'Age'='%d', 'Gender'='%d', 'O..."
[09:53:23] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE 'samp_accounts' SET 'MaskOn'='0', 'Admin'='0', 'Helper'='", callback: "(null)", format: "(null)"
[09:53:23] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[09:53:23] [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 ''samp_accounts' SET 'MaskOn'='0', 'Admin'='0', 'Helper'='0', 'Money'='0', 'Level' at line 1
[09:53:23] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[09:54:46] [DEBUG] mysql_connect - host: "localhost", user: "root", database: "roleplay", password: "****", port: 3306, autoreconnect: true, pool_size: 2
[09:54:46] [DEBUG] CMySQLHandle::Create - creating new connection..
[09:54:46] [DEBUG] CMySQLHandle::CMySQLHandle - constructor called
[09:54:46] [DEBUG] CMySQLHandle::Create - connection created (id: 1)
[09:54:46] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[09:54:46] [DEBUG] CMySQLConnection::Connect - connection was successful
[09:54:46] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[09:54:46] [DEBUG] mysql_errno - connection: 1
[09:54:46] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[09:54:46] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[09:54:46] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[09:54:46] [DEBUG] CMySQLConnection::Connect - connection was successful
[09:54:46] [DEBUG] CMySQLConnection::Connect - connection was successful
[09:54:46] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[09:54:46] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[10:07:56] [DEBUG] mysql_connect - host: "localhost", user: "root", database: "roleplay", password: "****", port: 3306, autoreconnect: true, pool_size: 2
[10:07:56] [DEBUG] CMySQLHandle::Create - creating new connection..
[10:07:56] [DEBUG] CMySQLHandle::CMySQLHandle - constructor called
[10:07:56] [DEBUG] CMySQLHandle::Create - connection created (id: 1)
[10:07:56] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[10:07:56] [DEBUG] CMySQLConnection::Connect - connection was successful
[10:07:56] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[10:07:56] [DEBUG] mysql_errno - connection: 1
[10:07:56] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[10:07:56] [DEBUG] CMySQLConnection::Connect - connection was successful
[10:07:56] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[10:07:56] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[10:07:56] [DEBUG] CMySQLConnection::Connect - connection was successful
[10:07:56] [DEBUG] CMySQLConnection::Connect - connection was successful
[10:07:56] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[10:07:56] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[10:08:23] [DEBUG] mysql_format - connection: 1, len: 128, format: "SELECT 'Password', 'PlayerID' FROM 'samp_accounts' WHERE 'Username'='%e' LIMIT 1"
[10:08:23] [DEBUG] mysql_tquery - connection: 1, query: "SELECT 'Password', 'PlayerID' FROM 'samp_accounts' WHERE 'Userna", callback: "OnAccountCheck", format: "i"
[10:08:23] [DEBUG] CMySQLQuery::Execute[OnAccountCheck] - starting query execution
[10:08:23] [ERROR] CMySQLQuery::Execute[OnAccountCheck] - (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 ''samp_accounts' WHERE 'Username'='R' LIMIT 1' at line 1
[10:08:23] [DEBUG] CMySQLQuery::Execute[OnAccountCheck] - error will be triggered in OnQueryError
[10:08:35] [DEBUG] mysql_format - connection: 1, len: 2048, format: "UPDATE 'samp_accounts' SET 'MaskOn'='%d', 'Admin'='%d', 'Helper'='%d', 'Money'='%d', 'Level'='%d', 'Age'='%d', 'Gender'='%d', 'O..."
[10:08:35] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE 'samp_accounts' SET 'MaskOn'='0', 'Admin'='0', 'Helper'='", callback: "(null)", format: "(null)"
[10:08:35] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[10:08:35] [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 ''samp_accounts' SET 'MaskOn'='0', 'Admin'='0', 'Helper'='0', 'Money'='0', 'Level' at line 1
[10:08:35] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
Thank you for whoever helps me!
Reply


Messages In This Thread
MySQL Issue - by ChromeAmazing - 25.10.2015, 15:12
Re: MySQL Issue - by AndySedeyn - 25.10.2015, 15:17
Re: MySQL Issue - by ChromeAmazing - 25.10.2015, 15:21
Re: MySQL Issue - by AndySedeyn - 25.10.2015, 15:24
Re: MySQL Issue - by ChromeAmazing - 25.10.2015, 15:27
Re: MySQL Issue - by ChromeAmazing - 25.10.2015, 18:03
Re: MySQL Issue - by AndySedeyn - 25.10.2015, 18:05
Re: MySQL Issue - by ChromeAmazing - 25.10.2015, 18:36
Re: MySQL Issue - by ChromeAmazing - 25.10.2015, 20:57
Re: MySQL Issue - by ChromeAmazing - 28.10.2015, 23:37

Forum Jump:


Users browsing this thread: 1 Guest(s)