1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help

Threaded Mode
mysql print log - Unknown
Mobtiesgangsa
Big Clucker
***
Posts: 155
Threads: 36
Joined: Oct 2016
Reputation: 0
#1

31.01.2018, 06:53
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
Find
Reply
jlalt
Banned
Posts: 1,266
Threads: 6
Joined: Oct 2014
#2

31.01.2018, 06:55
It says there's no column called password, can you show a pic from database table?
Find
Reply
Mobtiesgangsa
Big Clucker
***
Posts: 155
Threads: 36
Joined: Oct 2016
Reputation: 0
#3

31.01.2018, 07:00


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
Find
Reply
Mugala
High-roller
*****
Posts: 1,176
Threads: 2
Joined: Nov 2012
Reputation: 0
#4

31.01.2018, 07:23
try to change structure for password or limit, it's probably too long.
Find
Reply
Mobtiesgangsa
Big Clucker
***
Posts: 155
Threads: 36
Joined: Oct 2016
Reputation: 0
#5

31.01.2018, 10:29
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
Find
Reply
jlalt
Banned
Posts: 1,266
Threads: 6
Joined: Oct 2014
#6

31.01.2018, 18:05
Код:
"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); 
Find
Reply
edyun
Big Clucker
***
Posts: 144
Threads: 12
Joined: Sep 2014
Reputation: 0
#7

31.01.2018, 18:25
Your column is named "Passwrod" not "Password", change the script or the database accordingly.
Find
Reply
Mugala
High-roller
*****
Posts: 1,176
Threads: 2
Joined: Nov 2012
Reputation: 0
#8

31.01.2018, 19:54
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.
Find
Reply
Mobtiesgangsa
Big Clucker
***
Posts: 155
Threads: 36
Joined: Oct 2016
Reputation: 0
#9

01.02.2018, 12:28
Aww Damnit i that strugle was just for `password` in my query ill fix it Tnx guys everyone gets Rep
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


Users browsing this thread: 1 Guest(s)
  1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help