论坛交易区搜索报错

bdj

搜索地名。出现下面的：


Discuz! info: MySQL Query Error

User: bdj
Time: 2007-7-19 5:37pm
Script: /forumdisplay.php

SQL: SELECT t.* ,(SELECT COUNT(*) FROM [Table]posts WHERE tid=t.tid AND dateline>'1184827501')newreplies,g.price as gprice,g.locus as gaddress FROM [Table]threads t
LEFT JOIN [Table]members m ON m.uid=t.authorid
LEFT JOIN [Table]trades g ON g.tid=t.tid
WHERE t.fid='41' AND t.displayorder>=0 and t.typeid!='51' and m.s!='2' AND g.address LIKE '%深圳%'
ORDER BY t.displayorder DESC, t.lastpost DESC
LIMIT 0, 30
Error: Unknown column 'g.address' in 'where clause'
Errno.: 1054

Similar error report has beed dispatched to administrator before.