SA-MP Forums Archive
[Ajuda] Erro no SQL - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: Non-English (https://sampforum.blast.hk/forumdisplay.php?fid=9)
+--- Forum: Languages (https://sampforum.blast.hk/forumdisplay.php?fid=33)
+---- Forum: Português/Portuguese (https://sampforum.blast.hk/forumdisplay.php?fid=34)
+---- Thread: [Ajuda] Erro no SQL (/showthread.php?tid=542939)



Erro no SQL - StrondaXxT - 23.10.2014

Estou com esses erros
Код:
[10:17:25] [DEBUG] mysql_connect - host: "127.0.0.1", user: "root", database: "server2", password: "****", port: 3306, autoreconnect: true, pool_size: 0
[10:17:25] [DEBUG] CMySQLHandle::Create - creating new connection..
[10:17:25] [DEBUG] CMySQLHandle::CMySQLHandle - constructor called
[10:17:25] [DEBUG] CMySQLHandle::Create - connection created (id: 1)
[10:17:25] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[10:17:25] [DEBUG] CMySQLConnection::Connect - connection was successful
[10:17:25] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[10:17:25] [DEBUG] mysql_errno - connection: 1
[10:17:25] [DEBUG] mysql_connect - host: "127.0.0.1", user: "root", database: "server2", password: "****", port: 3306, autoreconnect: true, pool_size: 0
[10:17:25] [DEBUG] CMySQLHandle::Create - creating new connection..
[10:17:25] [WARNING] CMySQLHandle::Create - connection already exists
[10:17:25] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[10:17:25] [DEBUG] CMySQLConnection::Connect - connection was successful
[10:17:25] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[10:17:25] [DEBUG] mysql_errno - connection: 1
[10:17:25] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[10:17:25] [DEBUG] CMySQLConnection::Connect - connection was successful
[10:17:25] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[10:17:25] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[10:17:25] [DEBUG] CMySQLConnection::Connect - connection was successful
[10:17:25] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[10:17:44] [DEBUG] mysql_format - connection: 1, len: 128, format: "SELECT `Password`, `ID` FROM `players` WHERE `Username` = '%e' LIMIT 1"
[10:17:44] [DEBUG] mysql_tquery - connection: 1, query: "SELECT `Password`, `ID` FROM `players` WHERE `Username` = 'teste", callback: "ChecarConta", format: "i"
[10:17:44] [DEBUG] CMySQLQuery::Execute[ChecarConta] - starting query execution
[10:17:44] [DEBUG] CMySQLQuery::Execute[ChecarConta] - query was successfully executed within 0.559 milliseconds
[10:17:44] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[10:17:44] [DEBUG] Calling callback "ChecarConta"..
[10:17:44] [DEBUG] cache_get_data - connection: 1
[10:17:44] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[10:17:49] [DEBUG] mysql_format - connection: 1, len: 128, format: "INSERT INTO `players` (`Username`, `Password`, `IP`, `Admin`, `ModoAdmin`, `Money`, `Genero`, `Skin`, `Org`,`Cargo`,`Doenca`,`Ma..."
[10:17:49] [ERROR] mysql_format - destination size is too small
[10:17:49] [DEBUG] mysql_tquery - connection: 1, query: "INSERT INTO `players` (`Username`, `Password`, `IP`, `Admin`, `M", callback: "CriarConta", format: "i"
[10:17:49] [DEBUG] CMySQLQuery::Execute[CriarConta] - starting query execution
[10:17:49] [ERROR] CMySQLQuery::Execute[CriarConta] - (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
[10:17:49] [DEBUG] CMySQLQuery::Execute[CriarConta] - error will be triggered in OnQueryError
[10:17:53] [DEBUG] mysql_format - connection: 1, len: 128, format: "UPDATE `players` SET `Admin`=%d, `ModoAdmin`=%d,`Money`=%d, `Genero`=%d, `Skin`=%d,`Org`=%d,`Cargo`=%d,`Doenca`=%d, WHERE `ID`=%..."
[10:17:53] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `players` SET `Admin`=0, `ModoAdmin`=0,`Money`=0, `Genero", callback: "(null)", format: "(null)"
[10:17:53] [DEBUG] mysql_format - connection: 1, len: 128, format: "UPDATE `players` SET `Matou`=%d,`Morreu`=%d,`Casado`=%d,`Level`=%d,`Respeito`=%d,`Aviso`=%d,`Banido`=%d,	WHERE `ID`=%d"
[10:17:53] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `players` SET `Matou`=0,`Morreu`=0,`Casado`=0,`Level`=0,`", callback: "(null)", format: "(null)"
[10:17:53] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[10:17:53] [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 'WHERE `ID`=0' at line 1
[10:17:53] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[10:17:53] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[10:17:53] [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 'WHERE `ID`=0' at line 1
[10:17:53] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
Como resolver? Nгo tenho praticidade com sql to bem no inicio e me deparei com esse problema.


Re: Erro no SQL - StrondaXxT - 23.10.2014

Ja resolvi


Re: Erro no SQL - Dolby - 23.10.2014

Poste no tуpico como foi resolvido, assim podendo ajudar futuras pessoas com o mesmo problema.

Abraзos.