MySQL Formats
#6

Okay thanks.

I have an issue of it not adding my name, password or IP when creating a row, on quitting it updates other variables.

This is the error

Quote:

[19:00:56] [DEBUG] mysql_format - connection: 1, len: 2024, format: "INSERT INTO `accounts` (`Name`, `Password`, `IP`, `Admin`, `VIP`, `Caps`, `PosX`, `PosY`, `PosZ`, `PosA`, `Health, `Armour`, `Sk..."
[19:00:56] [DEBUG] mysql_tquery - connection: 1, query: "INSERT INTO `accounts` (`Name`, `Password`, `IP`, `Admin`, `VIP`", callback: "(null)", format: "i"
[19:00:56] [DEBUG] mysql_format - connection: 1, len: 2024, format: "INSERT INTO `accounts` (`TimeH`, `TimeM`, `Infection`, `Storage`, `Item1`, `Item2`, `Item3`, `Item4`, `Item5`, `Item6`, `Item7`,..."
[19:00:56] [DEBUG] mysql_tquery - connection: 1, query: "INSERT INTO `accounts` (`TimeH`, `TimeM`, `Infection`, `Storage`", callback: "OnAccountRegister", format: "i"
[19:00:56] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[19:00:56] [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 'Armour`, `Skin`, `Thirst`, `Hunger`, `Banned`, `Bans`, `Kicks`, `Warns`, `Muted`' at line 1
[19:00:56] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError

Reply


Messages In This Thread
MySQL Formats - by theonethatownz - 21.03.2016, 17:57
Re: MySQL Formats - by SickAttack - 21.03.2016, 18:13
Re: MySQL Formats - by zPain - 21.03.2016, 18:27
Re: MySQL Formats - by theonethatownz - 21.03.2016, 18:39
Re: MySQL Formats - by zPain - 21.03.2016, 18:49
Re: MySQL Formats - by theonethatownz - 21.03.2016, 19:10
Re: MySQL Formats - by Konstantinos - 22.03.2016, 13:43

Forum Jump:


Users browsing this thread: 1 Guest(s)