How To Fix this error - 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: How To Fix this error (/showthread.php?tid=577434)
+- 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: How To Fix this error (/showthread.php?tid=577434)
How To Fix this error - keyvanik - 11.06.2015
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'
Re: How To Fix this error - fuckingcruse - 11.06.2015
Codes?
Re: How To Fix this error - sammp - 11.06.2015
pHk, pBanDays don't exist in the database. This doesn't require code to know the problem. Add them to the table
Re: How To Fix this error - keyvanik - 11.06.2015
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
|
Re: How To Fix this error - DetoNater - 11.06.2015
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.
Re: How To Fix this error - keyvanik - 11.06.2015
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
Re: How To Fix this error - keyvanik - 11.06.2015
any body cant help me?