Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
 SQL Error While Filtering
cheefin Offline
Junior Member
**
Posts: 1
Joined: Jan 2020
Post: #1
SQL Error While Filtering
I am getting an SQL while filtering my threads by a custom field. I have the exact same setup on another board which is version 1.8.21 as the board im working now which is version 1.8.22. I dont know if this update has something to do with it or not.

The forum im making is a marketplace forum for online accounts. I have a field called trdfplat which holds the value for which platform the account is on (xbox, ps4, etc.). This is the SQL error im recieving.

SQL Error:
1054 - Unknown column 'tfd.trdfplat' in 'where clause'
Query:
SELECT COUNT(tid) AS threads FROM mybb_threads t WHERE fid = '36' AND (t.visible IN (1,-1,0)) AND tfd.`trdfplat` IN ("Xbox")

Any help would be great! Thank you.
01-06-2020 06:04 PM
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: