Unknown column

[1master1]

This new error is replicating for every few seconds

Code:

1 2 3 4 5 6 7 8 9 10 11

Type: 20 File: (Line no. 0) Message 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 xxx_threads t LEFT JOIN xxx_users u ON (u.uid = t.uid) WHERE t.fid IN (4,148,149) AND t.tid IN (0,'108','11') AND t.visible='1' AND t.closed NOT LIKE 'moved|%' ORDER BY t.dateline DESC LIMIT 0, 10

---

What is causing this?

[Skiilz]

Didn't you create a field called xthreads_desc? A description for your threads maybe?

[RateU]

(11-19-2010 05:24 AM)1master1 Wrote:  What is causing this?

And from what table the desc comes from?

[1master1]

yes, i created a thread desc field for a forum and i declared it correctly.

no clue, rateu

[RateU]

I think, when querying something, we need to know in which table the data stored..........

[ZiNgA BuRgA]

As said, the query doesn't know what "tfd.`desc`" is.
I presume you need to join a table for that to work.

[1master1]

i called the {$threaddescription) in thread view after the threadtitle in <thead>

{$threadname} - {$threaddecription}
is this causing the error?

[RateU]

(11-20-2010 11:59 PM)1master1 Wrote:  i called the {$threaddescription) in thread view after the threadtitle in <thead>

{$threadname} - {$threaddecription}
is this causing the error?

Do you mean by the "thread view" is showthread page?
I think the error comes from the script.

If all you want is thread description, we already have thread description example application.

[1master1]

yes rateu, i used in the showthread template.

[RateU]

If you use the XThreads example thread description application, you can add {$GLOBALS['threadfields']['desc']} variable in your showthread template for displaying the thread description in showthread page. Or maybe, it is not what you want to do?