chengwei 发表于 2007-9-9 17:28

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

Discuz! info: MySQL Query Error

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

SQL: SELECT t.* ,(SELECT COUNT(*) FROM posts WHERE tid=t.tid AND dateline>'1189036319')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 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 发表于 2007-9-9 17:36

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

HOPE 发表于 2007-9-9 22:51

已经修正，多谢。
页: [1]
查看完整版本: 友情提示一下。。。技术问题。