MyBB Community Forums

Full Version: Unknown column
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Can i know what is causing this error?

Site has experienced an internal SQL error and cannot continue.

SQL Error:
    1054 - Unknown column 'tfd.desc' in 'field list'
Query:
    SELECT t.*, tfd.`desc` AS `xthreads_desc`, t.username AS threadusername, u.username, u.avatar FROM nstdb_threads t LEFT JOIN nstdb_users u ON (u.uid = t.uid) WHERE t.fid IN (148,149,163) AND t.tid IN (0,'345','324','256','108') AND t.visible='1' AND t.closed NOT LIKE 'moved|%' ORDER BY t.dateline DESC LIMIT 0, 10

checked the threadsfieldlist table for the tdesc column, but i dont find any.

anything to be added or merged to make it work?
Are you using pgSQL??
There is no column called tfd desc. Its a column CALLED desc. The tfd is shorthand for threadfields....Take a look at the reply I posted on Zinga's forum. At the very least if you are calling data from the threadfields table you would need to join to it......
SOLVED