SA-MP Forums Archive
mysql print log - Unknown - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: mysql print log - Unknown (/showthread.php?tid=648939)


mysql print log - Unknown - Mobtiesgangsa - 31.01.2018

PHP код:
[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', 'B5D6307C593FA4F100840334244ED5FD5D926D6682D19F95490EE14769CB01A85D253A46B3CE38DEA50B5F9AA25B017AEECA8E394CF352FA85D15C75325CC055', '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

Re: mysql print log - Unknown - jlalt - 31.01.2018

It says there's no column called password, can you show a pic from database table?

Re: mysql print log - Unknown - Mobtiesgangsa - 31.01.2018



Quote:

[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=0x2dc46
[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=0x2c107
[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=0x2c612
[08:46:34] [DEBUG] CConnectionPool::Queue(query=0x2c6128, this=0x2dc46
[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=0x2f3a6
[08:46:34] [DEBUG] CQuery::Execute(this=0x2c6128, connection=0x2f3a6
[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=0x2c612
[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=0x2c612
[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

Re: mysql print log - Unknown - Mugala - 31.01.2018

try to change structure for password or limit, it's probably too long.

Re: mysql print log - Unknown - Mobtiesgangsa - 31.01.2018

Quote:
Originally Posted by Mugalito
Посмотреть сообщение
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

Re: mysql print log - Unknown - jlalt - 31.01.2018

Код:
"CREATE TABLE IF NOT EXISTS `players` (`ID` int(11) AUTO_INCREMENT, `Name` varchar(24) NOT NULL, `Passwrod`
Код:
INSERT INTO `players` (`ID`, `Name`, `Password
PHP код:
                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); 


Re: mysql print log - Unknown - edyun - 31.01.2018

Your column is named "Passwrod" not "Password", change the script or the database accordingly.

Re: mysql print log - Unknown - Mugala - 31.01.2018

Quote:
Originally Posted by edyun
Посмотреть сообщение
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.

Re: mysql print log - Unknown - Mobtiesgangsa - 01.02.2018

Aww Damnit i that strugle was just for `password` in my query ill fix it Tnx guys everyone gets Rep