Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
 SQL Error While Filtering
Cobalt60 Offline
Junior Member
**
Posts: 6
Joined: Jan 2020
Post: #3
RE: SQL Error While Filtering
Full error:

<error>
<dateline>1578505893</dateline>
<script></script>
<line>0</line>
<type>20</type>

<friendly_type>MyBB SQL Error</friendly_type>

<message>SQL Error: 1054 - Unknown column 'tfd.xtldcat' in 'where clause'
Query: SELECT COUNT(tid) AS threads FROM iioc_threads t WHERE fid = '44'  AND (t.visible IN (1,-1,0)) AND tfd.`xtldcat` IN ("Filter-word")  </message>

<back_trace>#0  errorHandler->log_error(20, SQL Error: 1054 - Unknown column 'tfd.xtldcat' in 'where clause'
Query: SELECT COUNT(tid) AS threads FROM iioc_threads t WHERE fid = '44'  AND (t.visible IN (1,-1,0)) AND tfd.`xtldcat` IN ("Filter-word")  , , 0) called at [/hp/bv/ab/cf/www/forum-url/inc/class_error.php:189]
#1  errorHandler->error(20, Array ([error_no] => 1054,[error] => Unknown column 'tfd.xtldcat' in 'where clause',[query] => SELECT COUNT(tid) AS threads FROM iioc_threads t WHERE fid = '44'  AND (t.visible IN (1,-1,0)) AND tfd.`xtldcat` IN ("Filter-word")  )) called at [/hp/bv/ab/cf/www/forum-url/inc/db_mysqli.php:597]
#2  DB_MySQLi->error(SELECT COUNT(tid) AS threads FROM iioc_threads t WHERE fid = '44'  AND (t.visible IN (1,-1,0)) AND tfd.`xtldcat` IN ("Filter-word")  ) called at [/hp/bv/ab/cf/www/forum-url/inc/db_mysqli.php:337]
#3  DB_MySQLi->query(SELECT COUNT(tid) AS threads FROM iioc_threads t WHERE fid = '44'  AND (t.visible IN (1,-1,0)) AND tfd.`xtldcat` IN ("Filter-word")  , 0, 0) called at [/hp/bv/ab/cf/www/forum-url/inc/plugins/xthreads.php(878) : eval()'d code:8]
#4  _objcont_3->query(SELECT COUNT(tid) AS threads FROM iioc_threads t WHERE fid = '44'  AND (t.visible IN (1,-1,0)) AND tfd.`xtldcat` IN ("Filter-word")  ) called at [/hp/bv/ab/cf/www/forum-url/inc/db_mysqli.php:789]
#5  DB_MySQLi->simple_select(threads t, COUNT(tid) AS threads, fid = '44'  AND (t.visible IN (1,-1,0)) AND tfd.`xtldcat` IN ("Filter-word")  , Array ()) called at [/hp/bv/ab/cf/www/forum-url/inc/plugins/xthreads.php(878) : eval()'d code:24]
#6  _objcont_6->simple_select(threads t, COUNT(tid) AS threads, fid = '44'  AND (t.visible IN (1,-1,0)) AND tfd.`xtldcat` IN ("Filter-word")  ) called at [/hp/bv/ab/cf/www/forum-url/forumdisplay.php:610]
</back_trace>
</error>
(This post was last modified: 01-09-2020 04:11 AM by Cobalt60.)
01-09-2020 03:47 AM
Find all posts by this user Quote this message in a reply

« Next Oldest | Next Newest »

Messages In This Thread
SQL Error While Filtering - cheefin - 01-06-2020, 06:04 PM
RE: SQL Error While Filtering - Cobalt60 - 01-09-2020, 12:37 AM
RE: SQL Error While Filtering - Cobalt60 - 01-09-2020 03:47 AM
RE: SQL Error While Filtering - Cobalt60 - 01-09-2020, 04:40 PM
RE: SQL Error While Filtering - dada732 - 02-27-2020, 09:11 AM
RE: SQL Error While Filtering - nier3 - 03-24-2020, 10:09 PM
RE: SQL Error While Filtering - RateU - 04-26-2020, 03:26 AM

 Standard Tools
Forum Jump: