论坛交易区搜索报错
搜索地名。出现下面的：Discuz! info: MySQL Query Error
User: bdj
Time: 2007-7-19 5:37pm
Script: /forumdisplay.php
SQL: SELECT t.* ,(SELECT COUNT(*) FROM posts WHERE tid=t.tid AND dateline>'1184827501')newreplies,g.price as gprice,g.locus as gaddress FROM threads t
LEFT JOIN members m ON m.uid=t.authorid
LEFT JOIN 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.
页:
[1]