Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
 SQL Error While Filtering
dada732 Offline
Junior Member
**
Posts: 1
Joined: Feb 2020
Post: #7
RE: SQL Error While Filtering
hello

i have the same problem after testing the job portal modified  on my website

SQL Error:
1054 - Unknown column 'tfd.xtjpcat' in 'where clause'
Query:
SELECT COUNT(tid) AS threads FROM mybbq6_threads t WHERE fid = '4' AND (t.visible IN (1)) AND tfd.`xtjpcat` IN ("surencheres")

i go to the "xt_forumdhooks.php" page and see the line

$dbt = '
static $done_t = false;
if(!$done_t && ($table == "threads" || $table == "threads t") && $fields == "COUNT(tid) AS threads") {
$done_t = true;
$table = "threads t LEFT JOIN {$this->table_prefix}threadfields_data tfd ON t.tid=tfd.tid";
$fields = "COUNT(t.tid) AS threads";
$conditions = xthreads_forumdisplay_filter_fixqcond($conditions);
$options = array("limit" => 1);
}
';

what's the problem?

cordially[/i]
02-27-2020 09:11 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: