友情提示一下。。。技术问题。

chengwei

Discuz! info: MySQL Query Error

User:
Time: 2007-9-9 5:26pm
Script: /forumdisplay.php

SQL: SELECT t.* ,(SELECT COUNT(*) FROM [Table]posts WHERE tid=t.tid AND dateline>'1189036319')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 IN (0, 1) 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.

chengwei

忘记说了，错误是出现在交易界面中的按照地点查找交易信息的地方。。。望版主检查一下。。。

HOPE

已经修正，多谢。