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

Threaded Mode
How To Fix this error
keyvanik
Big Clucker
***
Posts: 101
Threads: 39
Joined: Mar 2015
Reputation: 0
#1

11.06.2015, 16:47
Hi i have These Errors On my mysql_log.txt

PHP код:
[17:37:51] [ERROR] CMySQLQuery::Execute[SendQuery] - (error #1054) Unknown column 'pHk' in 'field list'
[17:40:08] [ERROR] cache_get_row_int - invalid datatype
[17:40:08] [ERROR] cache_get_row_int - invalid datatype
[17:40:34] [ERROR] cache_get_row_int - invalid datatype
[17:40:34] [ERROR] cache_get_row_int - invalid datatype
[17:42:36] [ERROR] cache_get_row_int - invalid datatype
[17:42:36] [ERROR] cache_get_row_int - invalid datatype
[17:42:37] [ERROR] cache_get_row_int - invalid datatype
[17:42:37] [ERROR] cache_get_row_int - invalid datatype
[17:43:13] [ERROR] cache_get_row_int - invalid datatype
[17:43:13] [ERROR] cache_get_row_int - invalid datatype
[17:47:55] [ERROR] cache_get_row_int - invalid datatype
[17:47:55] [ERROR] cache_get_row_int - invalid datatype
[17:47:55] [ERROR] CMySQLQuery::Execute[SendQuery] - (error #1054) Unknown column 'pHk' in 'field list'
[17:48:43] [ERROR] cache_get_row_int - invalid datatype
[17:48:43] [ERROR] cache_get_row_int - invalid datatype
[19:01:24] [ERROR] CMySQLQuery::Execute[SendQuery] - (error #1054) Unknown column 'pHk' in 'field list'
[19:01:59] [ERROR] CMySQLQuery::Execute[SendQuery] - (error #1054) Unknown column 'pHk' in 'field list'
[20:41:42] [ERROR] CMySQLQuery::Execute[SendQuery] - (error #1054) Unknown column 'pHk' in 'field list'
[20:53:59] [ERROR] CMySQLQuery::Execute[SendQuery] - (error #1054) Unknown column 'pBanDays' in 'field list'
[22:06:32] [ERROR] CMySQLQuery::Execute[SendQuery] - (error #1054) Unknown column 'pHk' in 'field list'
[22:35:24] [ERROR] CMySQLQuery::Execute[SendQuery] - (error #1054) Unknown column 'pBanDays' in 'field list'
[09:14:04] [ERROR] CMySQLQuery::Execute[SendQuery] - (error #1054) Unknown column 'pHk' in 'field list'
[11:40:19] [ERROR] CMySQLQuery::Execute[SendQuery] - (error #1054) Unknown column 'pHk' in 'field list'
[14:22:48] [ERROR] CMySQLQuery::Execute[SendQuery] - (error #1054) Unknown column 'pBanDays' in 'field list'
[18:55:14] [ERROR] CMySQLQuery::Execute[SendQuery] - (error #1054) Unknown column 'pHk' in 'field list'
[19:47:43] [ERROR] CMySQLQuery::Execute[SendQuery] - (error #1054) Unknown column 'pHk' in 'field list'
[19:47:43] [ERROR] CMySQLQuery::Execute[SendQuery] - (error #1054) Unknown column 'pHk' in 'field list'
[20:44:41] [ERROR] CMySQLQuery::Execute[SendQuery] - (error #1054) Unknown column 'pHk' in 'field list'
[21:45:26] [ERROR] CMySQLQuery::Execute[SendQuery] - (error #1054) Unknown column 'pHk' in 'field list'
[09:33:53] [ERROR] CMySQLQuery::Execute[SendQuery] - (error #1054) Unknown column 'pBanDays' in 'field list'
[13:45:26] [ERROR] CMySQLQuery::Execute[SendQuery] - (error #1054) Unknown column 'pHk' in 'field list'
[15:29:25] [ERROR] CMySQLQuery::Execute[SendQuery] - (error #1054) Unknown column 'pHk' in 'field list'
[15:34:24] [ERROR] CMySQLQuery::Execute[SendQuery] - (error #1054) Unknown column 'pBanDays' in 'field list'
[15:40:05] [ERROR] CMySQLQuery::Execute[SendQuery] - (error #1054) Unknown column 'pBanDays' in 'field list'
[16:52:16] [ERROR] CMySQLQuery::Execute[SendQuery] - (error #1054) Unknown column 'pHk' in 'field list'
[18:01:45] [ERROR] CMySQLQuery::Execute[SendQuery] - (error #1054) Unknown column 'pHk' in 'field list'
[20:36:50] [ERROR] CMySQLQuery::Execute[SendQuery] - (error #1054) Unknown column 'pHk' in 'field list'
[20:39:28] [ERROR] CMySQLQuery::Execute[SendQuery] - (error #1054) Unknown column 'pHk' in 'field list'
[21:51:30] [ERROR] CMySQLQuery::Execute[SendQuery] - (error #1054) Unknown column 'pHk' in 'field list'
[00:47:13] [ERROR] CMySQLQuery::Execute[SendQuery] - (error #1054) Unknown column 'pBanDays' in 'field list'
[01:04:57] [ERROR] CMySQLQuery::Execute[SendQuery] - (error #1054) Unknown column 'pHk' in 'field list'
[01:14:11] [ERROR] CMySQLQuery::Execute[SendQuery] - (error #1054) Unknown column 'pBanDays' in 'field list'
[03:01:49] [ERROR] CMySQLQuery::Execute[SendQuery] - (error #1054) Unknown column 'pHk' in 'field list'
[03:03:43] [ERROR] CMySQLQuery::Execute[SendQuery] - (error #1054) Unknown column 'pHk' in 'field list'
[03:08:04] [ERROR] CMySQLQuery::Execute[SendQuery] - (error #1054) Unknown column 'pHk' in 'field list'
[03:14:01] [ERROR] CMySQLQuery::Execute[SendQuery] - (error #1054) Unknown column 'pHk' in 'field list'
[12:36:11] [ERROR] CMySQLQuery::Execute[SendQuery] - (error #1054) Unknown column 'pHk' in 'field list'
[12:47:15] [ERROR] CMySQLQuery::Execute[SendQuery] - (error #1054) Unknown column 'pHk' in 'field list'
[12:56:15] [ERROR] CMySQLQuery::Execute[SendQuery] - (error #1054) Unknown column 'pBanDays' in 'field list'
[13:01:01] [ERROR] CMySQLQuery::Execute[SendQuery] - (error #1054) Unknown column 'pBanDays' in 'field list'
[14:20:14] [ERROR] CMySQLQuery::Execute[SendQuery] - (error #1054) Unknown column 'pHk' in 'field list'
[14:39:48] [ERROR] CMySQLQuery::Execute[SendQuery] - (error #1054) Unknown column 'pHk' in 'field list'
[14:47:40] [ERROR] CMySQLQuery::Execute[SendQuery] - (error #1054) Unknown column 'pBanDays' in 'field list'
[16:08:52] [ERROR] CMySQLQuery::Execute[SendQuery] - (error #1054) Unknown column 'pHk' in 'field list'
[16:26:26] [ERROR] CMySQLQuery::Execute[SendQuery] - (error #1054) Unknown column 'pHk' in 'field list'
[16:30:42] [ERROR] CMySQLQuery::Execute[SendQuery] - (error #1054) Unknown column 'pHk' in 'field list'
[19:16:24] [ERROR] CMySQLQuery::Execute[SendQuery] - (error #1054) Unknown column 'pHk' in 'field list'
[20:46:52] [ERROR] CMySQLQuery::Execute[SendQuery] - (error #1054) Unknown column 'pHk' in 'field list' 
how to fix?
Find
Reply
fuckingcruse
Gangsta
****
Posts: 528
Threads: 70
Joined: Nov 2014
Reputation: 0
#2

11.06.2015, 17:05
Codes?
Find
Reply
sammp
Gangsta
****
Posts: 584
Threads: 51
Joined: Jan 2014
Reputation: 0
#3

11.06.2015, 17:09
pHk, pBanDays don't exist in the database. This doesn't require code to know the problem. Add them to the table
Find
Reply
keyvanik
Big Clucker
***
Posts: 101
Threads: 39
Joined: Mar 2015
Reputation: 0
#4

11.06.2015, 17:24
Quote:
Originally Posted by sammp
Посмотреть сообщение
pHk, pBanDays don't exist in the database. This doesn't require code to know the problem. Add them to the table
where i should make pBanDays On my Users database Or Banned Database?
Find
Reply
DetoNater
Huge Clucker
****
Posts: 253
Threads: 65
Joined: Feb 2013
Reputation: 0
#5

11.06.2015, 17:49
As it clearly says invalid datatype, you must have placed cache_get_row_int in a float field(instead use cache_get_row_float). Check the code, were the bans has been placed(see the query) and according to that create a table.
Find
Reply
keyvanik
Big Clucker
***
Posts: 101
Threads: 39
Joined: Mar 2015
Reputation: 0
#6

11.06.2015, 19:11
I have test i make pBanDays and my freind banned me for 1 day i see on database pBanDays is 1 but i can join server it's like kick
Find
Reply
keyvanik
Big Clucker
***
Posts: 101
Threads: 39
Joined: Mar 2015
Reputation: 0
#7

11.06.2015, 19:55
any body cant help me?
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