PDA

View Full Version : mysql print log - Unknown


Mobtiesgangsa
31/01/2018, 06:53 AM
[08:47:05] [ERROR] error #1054 while executing query "INSERT INTO `players` (`ID`, `Name`, `Password`, `IP`, `Admin`, `Money`, `Kills`, `Deaths`, `Scuicides`, `Skin`, `X`, `Y`, `Z`, `A`, `Interiour`) VALUES ('0', 'Player', 'B5D6307C593FA4F100840334244ED5FD5D926D6682D19F954 90EE14769CB01A85D253A46B3CE38DEA50B5F9AA25B017AEEC A8E394CF352FA85D15C75325CC055', '127.0.0.1', 0, 0, 0, 0, 0, '0', '0.000000', '0.000000', '0.000000', '0.000000', 0)": Unknown column 'Password' in 'field list'

new query[712];

GetPlayerIp(playerid, PlayerInfo[playerid][IP], 16);
GetPlayerName(playerid, PlayerInfo[playerid][Name], MAX_PLAYER_NAME);
WP_Hash(PlayerInfo[playerid][Password], 129, inputtext);

mysql_format(g_Handle,query, sizeof(query), "INSERT INTO `players` (`ID`, `Name`, `Password`, `IP`, `Admin`, `Money`, `Kills`, `Deaths`, `Scuicides`, `Skin`, `X`, `Y`, `Z`, `A`, `Interiour`) VALUES ('%i', '%e', '%e', '%e', 0, 0, 0, 0, 0, '%i', '%f', '%f', '%f', '%f', 0)",
PlayerInfo[playerid][ID],
PlayerInfo[playerid][Name],
PlayerInfo[playerid][Password],
PlayerInfo[playerid][IP],
PlayerInfo[playerid][Admin],
PlayerInfo[playerid][Money],
PlayerInfo[playerid][Kills],
PlayerInfo[playerid][Deaths],
PlayerInfo[playerid][Scuicides],
PlayerInfo[playerid][Skin],
PlayerInfo[playerid][P_X],
PlayerInfo[playerid][P_Y],
PlayerInfo[playerid][P_Z],
PlayerInfo[playerid][P_A],
PlayerInfo[playerid][Interior]);

mysql_tquery(g_Handle, query, "OnPlayerRegister", "d", playerid);


what is missing the php i added is for a unknown colum and the second is my pawn script

jlalt
31/01/2018, 06:55 AM
It says there's no column called password, can you show a pic from database table?

Mobtiesgangsa
31/01/2018, 07:00 AM
https://s17.postimg.org/moxid1t97/Untitled.jpg (https://postimg.org/image/moxid1t97/)

[08:46:34] [DEBUG] mysql_init_options()
[08:46:34] [DEBUG] mysql_init_options: return value: '1'
[08:46:34] [DEBUG] mysql_set_option(1, 0)
[08:46:34] [DEBUG] mysql_set_option: return value: '1'
[08:46:34] [DEBUG] mysql_global_options(0, 1)
[08:46:34] [DEBUG] mysql_global_options: return value: '1'
[08:46:34] [DEBUG] mysql_connect("127.0.0.1", "root", "*****", "test", 1)
[08:46:34] [DEBUG] CHandleManager::Create(this=0x2d3350, host='127.0.0.1', user='root', pass='****', db='test', options=0x2c8670)
[08:46:34] [WARNING] mysql_connect: no password specified
[08:46:34] [DEBUG] CConnection::CConnection(this=0x2dc3a8, host='127.0.0.1', user='root', passw='****', db='test', options=0x2c8670)
[08:46:34] [DEBUG] CConnection::CConnection - new connection = 0x2a07f0
[08:46:34] [DEBUG] CConnection::CConnection(this=0x2f90020, host='127.0.0.1', user='root', passw='****', db='test', options=0x2c8670)
[08:46:34] [DEBUG] CConnection::CConnection - new connection = 0x2e72d0
[08:46:34] [DEBUG] CThreadedConnection::WorkerFunc(this=0x2f90020, connection=0x2f90020)
[08:46:34] [DEBUG] CThreadedConnection::CThreadedConnection(this=0x2f 90020, connection=0x2f90020)
[08:46:34] [DEBUG] CConnectionPool::CConnectionPool(size=2, this=0x2dc468)
[08:46:34] [DEBUG] CConnection::CConnection(this=0x3120020, host='127.0.0.1', user='root', passw='****', db='test', options=0x2c8670)
[08:46:34] [DEBUG] CConnection::CConnection - new connection = 0x2f3a68
[08:46:34] [DEBUG] CThreadedConnection::WorkerFunc(this=0x3120020, connection=0x3120020)
[08:46:34] [DEBUG] CThreadedConnection::CThreadedConnection(this=0x31 20020, connection=0x3120020)
[08:46:34] [DEBUG] CConnection::CConnection(this=0x32b0020, host='127.0.0.1', user='root', passw='****', db='test', options=0x2c8670)
[08:46:34] [DEBUG] CConnection::CConnection - new connection = 0x2fcb20
[08:46:34] [DEBUG] CThreadedConnection::WorkerFunc(this=0x32b0020, connection=0x32b0020)
[08:46:34] [DEBUG] CThreadedConnection::CThreadedConnection(this=0x32 b0020, connection=0x32b0020)
[08:46:34] [DEBUG] CHandleManager::Create - new handle = 0x2c1078
[08:46:34] [DEBUG] mysql_connect: return value: '1'
[08:46:34] [DEBUG] mysql_errno(1)
[08:46:34] [DEBUG] CHandle::GetErrorId(this=0x2c1078)
[08:46:34] [DEBUG] CConnection::GetError(this=0x2dc3a8, connection=0x2a07f0)
[08:46:34] [DEBUG] CHandle::GetErrorId - return value: true, error id: '0', error msg: ''
[08:46:34] [DEBUG] mysql_errno: return value: '0'
[08:46:34] [DEBUG] mysql_format(1, 0x01E8B650, 1024, "CREATE TABLE IF NOT EXISTS `players` (`ID` int(11) AUTO_INCREMENT, `Name` varchar(24) NOT NULL, `Passwrod` varchar(129) NOT NULL, `IP` varchar(16) NOT NULL, `Admin` int(11) NOT NULL, `Money` int(11) NOT NULL, `Kills` int(11) NOT NULL, `Deaths` int(11) NOT NULL, `Scuicides` int(11) NOT NULL, `Skin` int(11) NOT NULL, `X` float NOT NULL, `Y` float NOT NULL, `Z` float NOT NULL, `A` float NOT NULL, `Interior` int(11) NOT NULL, PRIMARY KEY (`ID`))")
[08:46:34] [DEBUG] mysql_format: return value: '445'
[08:46:34] [DEBUG] mysql_pquery(1, "CREATE TABLE IF NOT EXISTS `players` (`ID` int(11) AUTO_INCREMENT, `Name` varchar(24) NOT NULL, `Passwrod` varchar(129) NOT NULL, `IP` varchar(16) NOT NULL, `Admin` int(11) NOT NULL, `Money` int(11) NOT NULL, `Kills` int(11) NOT NULL, `Deaths` int(11) NOT NULL, `Scuicides` int(11) NOT NULL, `Skin` int(11) NOT NULL, `X` float NOT NULL, `Y` float NOT NULL, `Z` float NOT NULL, `A` float NOT NULL, `Interior` int(11) NOT NULL, PRIMARY KEY (`ID`))", "", "")
[08:46:34] [DEBUG] CCallback::Create(amx=0x13ba7e0, name='', format='', params=0x1e8b638, param_offset=5)
[08:46:34] [DEBUG] CHandle::Execute(this=0x2c1078, type=2, query=0x2c6128)
[08:46:34] [DEBUG] CConnectionPool::Queue(query=0x2c6128, this=0x2dc468)
[08:46:34] [DEBUG] CHandle::Execute - return value: true
[08:46:34] [DEBUG] mysql_pquery: return value: '1'
[08:46:34] [DEBUG] CConnection::Execute(query=0x2c6128, this=0x3120020, connection=0x2f3a68)
[08:46:34] [DEBUG] CQuery::Execute(this=0x2c6128, connection=0x2f3a68)
[08:46:34] [DEBUG] CResultSet::Create(connection=0x2f3a68, query_str='CREATE TABLE IF NOT EXISTS `players` (`ID` int(11) AUTO_INCREMENT, `Name` varchar(24) NOT NULL, `Passwrod` varchar(129) NOT NULL, `IP` varchar(16) NOT NULL, `Admin` int(11) NOT NULL, `Money` int(11) NOT NULL, `Kills` int(11) NOT NULL, `Deaths` int(11) NOT NULL, `Scuicides` int(11) NOT NULL, `Skin` int(11) NOT NULL, `X` float NOT NULL, `Y` float NOT NULL, `Z` float NOT NULL, `A` float NOT NULL, `Interior` int(11) NOT NULL, PRIMARY KEY (`ID`))')
[08:46:34] [DEBUG] created new resultset '0x2da0e0'
[08:46:34] [DEBUG] fetched MySQL result '0x0'
[08:46:58] [DEBUG] mysql_format(1, 0x01E8C3EC, 128, "SELECT * FROM `players` WHERE `Name` = '%e' LIMIT 1")
[08:46:58] [DEBUG] CHandle::EscapeString(this=0x2c1078, src='Player')
[08:46:58] [DEBUG] CConnection::EscapeString(src='Player', this=0x2dc3a8, connection=0x2a07f0)
[08:46:58] [DEBUG] CHandle::EscapeString - return value: true, escaped string: 'Player'
[08:46:58] [DEBUG] mysql_format: return value: '55'
[08:46:58] [DEBUG] mysql_tquery(1, "SELECT * FROM `players` WHERE `Name` = 'Player' LIMIT 1", "OnPlayerCheck", "i")
[08:46:58] [DEBUG] CCallback::Create(amx=0x13ba7e0, name='OnPlayerCheck', format='i', params=0x1e8c3d4, param_offset=5)
[08:46:58] [DEBUG] CCallback::Create - callback index for 'OnPlayerCheck': 4
[08:46:58] [DEBUG] processing specifier 'i' with parameter index 0
[08:46:58] [DEBUG] retrieved and pushed value '0'
[08:46:58] [DEBUG] created delayed callback with 1 parameter
[08:46:58] [DEBUG] CHandle::Execute(this=0x2c1078, type=1, query=0x2c6128)
[08:46:58] [DEBUG] CHandle::Execute - return value: true
[08:46:58] [DEBUG] mysql_tquery: return value: '1'
[08:46:58] [DEBUG] CConnection::Execute(query=0x2c6128, this=0x2f90020, connection=0x2e72d0)
[08:46:58] [DEBUG] CQuery::Execute(this=0x2c6128, connection=0x2e72d0)
[08:46:58] [DEBUG] CResultSet::Create(connection=0x2e72d0, query_str='SELECT * FROM `players` WHERE `Name` = 'Player' LIMIT 1')
[08:46:58] [DEBUG] created new resultset '0x2da070'
[08:46:58] [DEBUG] fetched MySQL result '0x2c64a8'
[08:46:58] [DEBUG] allocated 0 bytes for PAWN result
[08:46:58] [DEBUG] CCallback::Execute(amx=0x13ba7e0, index=4, num_params=1)
[08:46:58] [DEBUG] processing internal specifier 'c'
[08:46:58] [DEBUG] pushed value '0' onto AMX stack
[08:46:58] [DEBUG] executing AMX callback with index '4'
[08:46:58] [DEBUG] cache_get_row_count(0x01E8C23C)
[08:46:58] [DEBUG] cache_get_row_count: return value: '1'
[08:46:58] [DEBUG] AMX callback executed with error '0'
[08:47:05] [DEBUG] mysql_format(1, 0x01E8BB1C, 712, "INSERT INTO `players` (`ID`, `Name`, `Password`, `IP`, `Admin`, `Money`, `Kills`, `Deaths`, `Scuicides`, `Skin`, `X`, `Y`, `Z`, `A`, `Interiour`) VALUES ('%i', '%e', '%e', '%e', 0, 0, 0, 0, 0, '%i', '%f', '%f', '%f', '%f', 0)")
[08:47:05] [DEBUG] CHandle::EscapeString(this=0x2c1078, src='Player')
[08:47:05] [DEBUG] CConnection::EscapeString(src='Player', this=0x2dc3a8, connection=0x2a07f0)
[08:47:05] [DEBUG] CHandle::EscapeString - return value: true, escaped string: 'Player'
[08:47:05] [DEBUG] CHandle::EscapeString(this=0x2c1078, src='B5D6307C593FA4F100840334244ED5FD5D926D6682D19 F95490EE14769CB01A85D253A46B3CE38DEA50B5F9AA25B017 AEECA8E394CF352FA85D15C75325CC055')
[08:47:05] [DEBUG] CConnection::EscapeString(src='B5D6307C593FA4F1008 40334244ED5FD5D926D6682D19F95490EE14769CB01A85D253 A46B3CE38DEA50B5F9AA25B017AEECA8E394CF352FA85D15C7 5325CC055', this=0x2dc3a8, connection=0x2a07f0)
[08:47:05] [DEBUG] CHandle::EscapeString - return value: true, escaped string: 'B5D6307C593FA4F100840334244ED5FD5D926D6682D19F954 90EE14769CB01A85D253A46B3CE38DEA50B5F9AA25B017AEEC A8E394CF352FA85D15C75325CC055'
[08:47:05] [DEBUG] CHandle::EscapeString(this=0x2c1078, src='127.0.0.1')
[08:47:05] [DEBUG] CConnection::EscapeString(src='127.0.0.1', this=0x2dc3a8, connection=0x2a07f0)
[08:47:05] [DEBUG] CHandle::EscapeString - return value: true, escaped string: '127.0.0.1'
[08:47:05] [DEBUG] mysql_format: return value: '384'
[08:47:05] [DEBUG] mysql_tquery(1, "INSERT INTO `players` (`ID`, `Name`, `Password`, `IP`, `Admin`, `Money`, `Kills`, `Deaths`, `Scuicides`, `Skin`, `X`, `Y`, `Z`, `A`, `Interiour`) VALUES ('0', 'Player', 'B5D6307C593FA4F100840334244ED5FD5D926D6682D19F954 90EE14769CB01A85D253A46B3CE38DEA50B5F9AA25B017AEEC A8E394CF352FA85D15C75325CC055', '127.0.0.1', 0, 0, 0, 0, 0, '0', '0.000000', '0.000000', '0.000000', '0.000000', 0)", "OnPlayerRegister", "d")
[08:47:05] [DEBUG] CCallback::Create(amx=0x13ba7e0, name='OnPlayerRegister', format='d', params=0x1e8bb04, param_offset=5)
[08:47:05] [DEBUG] CCallback::Create - callback index for 'OnPlayerRegister': 21
[08:47:05] [DEBUG] processing specifier 'd' with parameter index 0
[08:47:05] [DEBUG] retrieved and pushed value '0'
[08:47:05] [DEBUG] created delayed callback with 1 parameter
[08:47:05] [DEBUG] CHandle::Execute(this=0x2c1078, type=1, query=0x2c6128)
[08:47:05] [DEBUG] CConnection::Execute(query=0x2c6128, this=0x2f90020, connection=0x2e72d0)
[08:47:05] [DEBUG] CQuery::Execute(this=0x2c6128, connection=0x2e72d0)
[08:47:05] [ERROR] error #1054 while executing query "INSERT INTO `players` (`ID`, `Name`, `Password`, `IP`, `Admin`, `Money`, `Kills`, `Deaths`, `Scuicides`, `Skin`, `X`, `Y`, `Z`, `A`, `Interiour`) VALUES ('0', 'Player', 'B5D6307C593FA4F100840334244ED5FD5D926D6682D19F954 90EE14769CB01A85D253A46B3CE38DEA50B5F9AA25B017AEEC A8E394CF352FA85D15C75325CC055', '127.0.0.1', 0, 0, 0, 0, 0, '0', '0.000000', '0.000000', '0.000000', '0.000000', 0)": Unknown column 'Password' in 'field list'
[08:47:05] [DEBUG] CConnection::GetError(this=0x2f90020, connection=0x2e72d0)
[08:47:05] [DEBUG] CHandle::Execute - return value: true
[08:47:05] [DEBUG] mysql_tquery: return value: '1'
[08:47:05] [DEBUG] CCallback::Create(amx=0x13ba7e0, name='OnQueryError', format='dsssd)


here is my localhost nothing got inserted and here is a quote of mysql from log folder

Mugala
31/01/2018, 07:23 AM
try to change structure for password or limit, it's probably too long.

Mobtiesgangsa
31/01/2018, 10:29 AM
try to change structure for password or limit, it's probably too long.

im using whirlpool to hash passwords for me its easy to script passhashes with it and its size is 128 ~ 129 and + 1 as null

jlalt
31/01/2018, 06:05 PM
"CREATE TABLE IF NOT EXISTS `players` (`ID` int(11) AUTO_INCREMENT, `Name` varchar(24) NOT NULL, `Passwrod`


INSERT INTO `players` (`ID`, `Name`, `Password


new query[712];

GetPlayerIp(playerid, PlayerInfo[playerid][IP], 16);
GetPlayerName(playerid, PlayerInfo[playerid][Name], MAX_PLAYER_NAME);
WP_Hash(PlayerInfo[playerid][Password], 129, inputtext);

mysql_format(g_Handle,query, sizeof(query), "INSERT INTO `players` (`ID`, `Name`, `Passwrod`, `IP`, `Admin`, `Money`, `Kills`, `Deaths`, `Scuicides`, `Skin`, `X`, `Y`, `Z`, `A`, `Interiour`) VALUES ('%i', '%e', '%e', '%e', 0, 0, 0, 0, 0, '%i', '%f', '%f', '%f', '%f', 0)",
PlayerInfo[playerid][ID],
PlayerInfo[playerid][Name],
PlayerInfo[playerid][Password],
PlayerInfo[playerid][IP],
PlayerInfo[playerid][Admin],
PlayerInfo[playerid][Money],
PlayerInfo[playerid][Kills],
PlayerInfo[playerid][Deaths],
PlayerInfo[playerid][Scuicides],
PlayerInfo[playerid][Skin],
PlayerInfo[playerid][P_X],
PlayerInfo[playerid][P_Y],
PlayerInfo[playerid][P_Z],
PlayerInfo[playerid][P_A],
PlayerInfo[playerid][Interior]);

mysql_tquery(g_Handle, query, "OnPlayerRegister", "d", playerid);

edyun
31/01/2018, 06:25 PM
Your column is named "Passwrod" not "Password", change the script or the database accordingly.

Mugala
31/01/2018, 07:54 PM
Your column is named "Passwrod" not "Password", change the script or the database accordingly.

this guy is right, in your database it's Passwrod and not Password.

Mobtiesgangsa
01/02/2018, 12:28 PM
Aww Damnit i that strugle was just for `password` in my query ill fix it Tnx guys everyone gets Rep