[theonethatownz]

Quote:

[22:00:04] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [22:00:26] [DEBUG] mysql_format - connection: 1, len: 128, format: "SELECT `Password`, `ID` FROM `accounts` WHERE `Name` = '%e' LIMIT 1" [22:00:26] [DEBUG] mysql_tquery - connection: 1, query: "SELECT `Password`, `ID` FROM `accounts` WHERE `Name` = 'Adalsigi", callback: "OnAccountCheck", format: "i" [22:00:26] [DEBUG] CMySQLQuery::Execute[OnAccountCheck] - starting query execution [22:00:26] [DEBUG] CMySQLQuery::Execute[OnAccountCheck] - query was successfully executed within 0.686 milliseconds [22:00:26] [DEBUG] CMySQLResult::CMySQLResult() - constructor called [22:00:26] [DEBUG] Calling callback "OnAccountCheck".. [22:00:26] [DEBUG] cache_get_data - connection: 1 [22:00:26] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called [22:00:29] [DEBUG] mysql_format - connection: 1, len: 512, format: "INSERT INTO `accounts` (`Name`, `Password`, `IP`, `Admin`, `VIP`, `Money`, `PosX`, `PosY`, `PosZ`, `PosA`, `Skin`, `Thirst`, `Hu..." [22:00:29] [DEBUG] mysql_format - connection: 1, len: 512, format: "INSERT INTO `accounts` (`Item1`, `Item2`, `Item3`, `Item4`, `Item5`, `Item6`, `Item7`, `Item8`, `Item9`, `Item10`) VALUES (0, 0,..." [22:00:29] [DEBUG] mysql_tquery - connection: 1, query: "INSERT INTO `accounts` (`Item1`, `Item2`, `Item3`, `Item4`, `Ite", callback: "OnAccountRegister", format: "i" [22:00:29] [DEBUG] CMySQLQuery::Execute[OnAccountRegister] - starting query execution [22:00:29] [DEBUG] CMySQLQuery::Execute[OnAccountRegister] - query was successfully executed within 51.794 milliseconds [22:00:29] [DEBUG] CMySQLResult::CMySQLResult() - constructor called [22:00:29] [DEBUG] Calling callback "OnAccountRegister".. [22:00:29] [DEBUG] cache_insert_id - connection: 1 [22:00:29] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called [22:00:31] [DEBUG] mysql_format - connection: 1, len: 128, format: "UPDATE `accounts` SET `Money` = %d, `PosX` = %f, `PosY` = %f, `PosZ` = %f, `PosA` = %f, `Skin` = %d, `Thirst` = %d, `Hunger` = %..." [22:00:31] [ERROR] mysql_format - destination size is too small [22:00:31] [DEBUG] mysql_format - connection: 1, len: 128, format: "UPDATE `accounts` SET `Item1` = %d, `Item2` = %d, `Item3` = %d, `Item4` = %d, `Item5` = %d, `Item6` = %d, `Item7` = %d, `Item8` ..." [22:00:31] [ERROR] mysql_format - destination size is too small [22:00:31] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `accounts` SET `Item1` = 0, `Item2` = 0, `Item3` = 0, `It", callback: "(null)", format: "(null)" [22:00:31] [DEBUG] CMySQLQuery::Execute[] - starting query execution [22:00:31] [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 [22:00:31] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError

Anyone know the issue?

[itsCody]

Increase the query string size

[theonethatownz]

Increased to 1024, mysql fields blank inside database?

[theonethatownz]

No errors inside mysql_log

Quote:

[22:25:32] [DEBUG] mysql_format - connection: 1, len: 1024, format: "UPDATE `accounts` SET `Money` = %d, `PosX` = %f, `PosY` = %f, `PosZ` = %f, `PosA` = %f, `Skin` = %d, `Thirst` = %d, `Hunger` = %..." [22:25:32] [DEBUG] mysql_format - connection: 1, len: 1024, format: "UPDATE `accounts` SET `Item1` = %d, `Item2` = %d, `Item3` = %d, `Item4` = %d, `Item5` = %d, `Item6` = %d, `Item7` = %d, `Item8` ..." [22:25:32] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `accounts` SET `Item1` = 0, `Item2` = 0, `Item3` = 0, `It", callback: "(null)", format: "(null)" [22:25:32] [DEBUG] CMySQLQuery::Execute[] - starting query execution [22:25:32] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 67.944 milliseconds [22:25:32] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving

but it's not writing anything to the mysql, though it was earlier?

[theonethatownz]

This is the section it writes the inital info into the table

Код:

            GetPlayerName(playerid, playername, sizeof(playername)); 
            GetPlayerIp(playerid, playerip, sizeof(playerip)); 
            WP_Hash(Player[playerid][Password], 129, inputtext); 
            mysql_format(mysql, query, sizeof(query), "INSERT INTO `accounts` (`Name`, `Password`, `IP`, `Admin`, `VIP`, `Money`, `PosX`, `PosY`, `PosZ`, `PosA`, `Skin`, `Thirst`, `Hunger`, `Banned`, `Bans`, `Kicks`, `Warns`, `Muted`, `Quests`, `TimeH`, `TimeM`, `Infection`) VALUES ('%e', '%e', '%e', 0, 0, 0, %f, %f, %f, %f, 23, 100, 100, 0, 0, 0, 0, 0, 0, 0, 0, 0)", playername, Player[playerid][Password], playerip, SPAWN_X, SPAWN_Y, SPAWN_Z, SPAWN_A); 

			mysql_format(mysql, query, sizeof(query), "INSERT INTO `accounts` (`Item1`, `Item2`, `Item3`, `Item4`, `Item5`, `Item6`, `Item7`, `Item8`, `Item9`, `Item10`, `Storage`) VALUES (0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0)"); 
			
            mysql_tquery(mysql, query, "OnAccountRegister", "i", playerid);

[theonethatownz]

This is the section it writes the inital info into the table

Код:

            GetPlayerName(playerid, playername, sizeof(playername)); 
            GetPlayerIp(playerid, playerip, sizeof(playerip)); 
            WP_Hash(Player[playerid][Password], 129, inputtext); 
            mysql_format(mysql, query, sizeof(query), "INSERT INTO `accounts` (`Name`, `Password`, `IP`, `Admin`, `VIP`, `Money`, `PosX`, `PosY`, `PosZ`, `PosA`, `Skin`, `Thirst`, `Hunger`, `Banned`, `Bans`, `Kicks`, `Warns`, `Muted`, `Quests`, `TimeH`, `TimeM`, `Infection`) VALUES ('%e', '%e', '%e', 0, 0, 0, %f, %f, %f, %f, 23, 100, 100, 0, 0, 0, 0, 0, 0, 0, 0, 0)", playername, Player[playerid][Password], playerip, SPAWN_X, SPAWN_Y, SPAWN_Z, SPAWN_A); 

			mysql_format(mysql, query, sizeof(query), "INSERT INTO `accounts` (`Item1`, `Item2`, `Item3`, `Item4`, `Item5`, `Item6`, `Item7`, `Item8`, `Item9`, `Item10`, `Storage`) VALUES (0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0)"); 
			
            mysql_tquery(mysql, query, "OnAccountRegister", "i", playerid);