[Help] MySQL error (error #1064)
#1

Mysql log

Код:
[14:53:39] [DEBUG] mysql_connect - host: "127.0.0.7", user: "root", database: "server_zombie", password: "****", port: 3306, autoreconnect: true, pool_size: 2
[14:53:39] [DEBUG] CMySQLHandle::Create - creating new connection..
[14:53:39] [DEBUG] CMySQLHandle::CMySQLHandle - constructor called
[14:53:39] [DEBUG] CMySQLHandle::Create - connection created (id: 1)
[14:53:39] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[14:53:39] [DEBUG] CMySQLConnection::Connect - connection was successful
[14:53:39] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[14:53:39] [DEBUG] mysql_errno - connection: 1
[14:53:39] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[14:53:39] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[14:53:39] [DEBUG] CMySQLConnection::Connect - connection was successful
[14:53:39] [DEBUG] CMySQLConnection::Connect - connection was successful
[14:53:39] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[14:53:39] [DEBUG] CMySQLConnection::Connect - connection was successful
[14:53:39] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[14:53:39] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[14:54:06] [DEBUG] mysql_format - connection: 1, len: 128, format: "SELECT `Password`, `ID` FROM `players` WHERE `Username` = '%e' LIMIT 1"
[14:54:06] [DEBUG] mysql_tquery - connection: 1, query: "SELECT `Password`, `ID` FROM `players` WHERE `Username` = '[root", callback: "OnAccountCheck", format: "i"
[14:54:06] [DEBUG] CMySQLQuery::Execute[OnAccountCheck] - starting query execution
[14:54:06] [DEBUG] CMySQLQuery::Execute[OnAccountCheck] - query was successfully executed within 0.617 milliseconds
[14:54:06] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[14:54:06] [DEBUG] Calling callback "OnAccountCheck"..
[14:54:06] [DEBUG] cache_get_data - connection: 1
[14:54:06] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[14:54:09] [DEBUG] mysql_tquery - connection: 1, query: "INSERT INTO `players`(`Death`, `Username`, `Password`, `IP`, `Ad", callback: "OnAccountRegister", format: "i"
[14:54:09] [DEBUG] CMySQLQuery::Execute[OnAccountRegister] - starting query execution
[14:54:09] [ERROR] CMySQLQuery::Execute[OnAccountRegister] - (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
[14:54:09] [DEBUG] CMySQLQuery::Execute[OnAccountRegister] - error will be triggered in OnQueryError
Gamemode:

http://pastebin.com/4HdWtjrL
Reply
#2

Put " between the first ( and last )
Reply
#3

Quote:
Originally Posted by Jimmy0wns
Посмотреть сообщение
Put " between the first ( and last )
excuse me?,
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)