[Thom9son]

Quote:

[22:47:01] [DEBUG] mysql_connect - host: "localhost", user: "root", database: "testserver", password: "****", port: 3306, autoreconnect: true [22:47:01] [DEBUG] CMySQLHandle::Create - creating new connection.. [22:47:01] [DEBUG] CMySQLHandle::CMySQLHandle - constructor called [22:47:01] [DEBUG] CMySQLHandle::Create - connection created with ID = 1 [22:47:01] [DEBUG] CMySQLConnection::Connect - connection was successful [22:47:01] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [22:47:01] [DEBUG] CMySQLConnection::Connect - connection was successful [22:47:01] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [22:47:01] [DEBUG] mysql_errno - connection: 1 [22:47:29] [DEBUG] mysql_format - connection: 1, len: 128, format: "SELECT Password, ID FROM accounts WHERE Name = '%e' LIMIT 1" [22:47:29] [DEBUG] mysql_tquery - connection: 1, query: "SELECT Password, ID FROM accounts WHERE Name = 'Ethan Bennett' L", callback: "OnAccountCheck", format: "i" [22:47:29] [DEBUG] CMySQLQuery::CMySQLQuery() - constructor called [22:47:29] [DEBUG] mysql_tquery - scheduling query "SELECT Password, ID FROM accounts WHERE Name = 'Ethan Bennett' LIMIT 1".. [22:47:29] [DEBUG] CMySQLQuery::Execute[OnAccountCheck(i)] - starting query execution [22:47:29] [DEBUG] CMySQLQuery::Execute[OnAccountCheck(i)] - query was successful [22:47:29] [DEBUG] CMySQLResult::CMySQLResult() - constructor called [22:47:29] [DEBUG] CMySQLQuery::Execute[OnAccountCheck(i)] - data being passed to ProcessCallbacks() [22:47:29] [DEBUG] Calling callback "OnAccountCheck".. [22:47:29] [DEBUG] cache_get_data - connection: 1 [22:47:29] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called [22:47:29] [DEBUG] CMySQLQuery::~CMySQLQuery() - deconstructor called [22:47:34] [DEBUG] mysql_format - connection: 1, len: 512, format: "INSERT INTO `accounts` (`Name`, `Password`, `IP`, `PlayerX`, `PlayerY`, `PlayerZ`, `AdminLevel`) VALUES ('%e', '%e', '%e', 0, 0,..." [22:47:34] [DEBUG] mysql_tquery - connection: 1, query: "INSERT INTO `accounts` (`Name`, `Password`, `IP`, `PlayerX`, `Pl", callback: "OnAccountRegister", format: "i" [22:47:34] [DEBUG] CMySQLQuery::CMySQLQuery() - constructor called [22:47:34] [DEBUG] mysql_tquery - scheduling query "INSERT INTO `accounts` (`Name`, `Password`, `IP`, `PlayerX`, `PlayerY`, `PlayerZ`, `AdminLevel`) VALUES ('Ethan Bennett', 'FB380494E942AEF09D400CF0ED83C96D3A42FD0A273A9D5CE 4F4F1B9CCC6B7C2FA88C7FBE129E944D47FEA8CBC712EAD281 C42CFD18CEEC6D9722158EF8ADB9A', '127.0.0.1', 0, 0, 0)".. [22:47:34] [DEBUG] CMySQLQuery::Execute[OnAccountRegister(i)] - starting query execution [22:47:34] [ERROR] CMySQLQuery::Execute[OnAccountRegister(i)] - (error #1136) Column count doesn't match value count at row 1 [22:47:34] [DEBUG] CMySQLQuery::Execute[OnAccountRegister(i)] - error will be triggered in OnQueryError [22:47:34] [DEBUG] CMySQLQuery::Execute[OnAccountRegister(i)] - data being passed to ProcessCallbacks() [22:47:34] [DEBUG] CMySQLQuery::~CMySQLQuery() - deconstructor called [22:47:36] [DEBUG] mysql_format - connection: 1, len: 128, format: "UPDATE `accounts` SET `PlayerX` = %f, `PlayerY` = %f, `PlayerZ` = %f WHERE `ID` = %d" [22:47:36] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `accounts` SET `PlayerX` = 50.000000, `PlayerY` = 50.0000", callback: "(null)", format: "(null)" [22:47:36] [DEBUG] CMySQLQuery::CMySQLQuery() - constructor called [22:47:36] [DEBUG] mysql_tquery - scheduling query "UPDATE `accounts` SET `PlayerX` = 50.000000, `PlayerY` = 50.000000, `PlayerZ` = 50.000000 WHERE `ID` = 0".. [22:47:36] [DEBUG] CMySQLQuery::Execute[()] - starting query execution [22:47:36] [DEBUG] CMySQLQuery::Execute[()] - query was successful [22:47:36] [DEBUG] CMySQLQuery::Execute[()] - no callback specified, skipping result saving [22:47:36] [DEBUG] CMySQLQuery::Execute[()] - data being passed to ProcessCallbacks() [22:47:36] [DEBUG] CMySQLQuery::~CMySQLQuery() - deconstructor called

So, the accounts are not storing when I register an account. Can anyone see the problem from this? Or this:

My code for inserting accounts into the database:

Quote:

forward OnAccountRegister(playerid); public OnAccountRegister(playerid) { new query[500]; mysql_format(mysql,query,sizeof(query),"INSERT INTO `accounts` (`id`, `Name`, `Password`, `AdminLevel`, `PlayerX`, `PlayerY`, `PlayerZ`) VALUES ('%i' , '%e' , '%s' , 0, '741.282', '-1414.34', '0.0')",PlayerStats[playerid][id],GetName(playerid),udb_hash(PlayerStats[playerid][Password])); printf("[Registration] New account registered. Database ID: [%d]", PlayerStats[playerid][id]); mysql_tquery(mysql, query, "OnAccountLoad", "i", playerid); SpawnPlayer(playerid); return 1; }