[已解決]請問這樣是有什麼問題?
Discuz! info: MySQL Query Error
User: 牙俊
Time: 2008-7-1 6:25pm
Script: /redirect.php
SQL: SELECT p.*, mp.*, m.uid, m.username AS username, m.groupid, m.adminid, m.regdate, m.lastactivity, m.posts, m.digestposts, m.oltime,
m.pageviews, m.credits, m.extcredits1, m.extcredits2, m.extcredits3, m.extcredits4, m.extcredits5, m.extcredits6,
m.extcredits7, m.extcredits8, m.email, m.gender, m.showemail, m.hw, m.invisible, m.xspacestatus, mf.nickname, mf.site,
mf.icq, mf.qq, mf.yahoo, mf.msn, mf.taobao, mf.alipay, mf.location, mf.medals, mf.avatar, mf.avatarwidth,
mf.avatarheight, mf.sightml AS signature, mf.customstatus, mf.spacename , mf.useimages
FROM [Table]posts p
LEFT JOIN [Table]members m ON m.uid=p.authorid
LEFT JOIN [Table]mypetdata mp ON mp.username=p.author
LEFT JOIN [Table]memberfields mf ON mf.uid=m.uid
WHERE p.tid='911' AND p.invisible='0' ORDER BY dateline LIMIT 0, 10
Error: Unknown column 'mf.useimages' in 'field list'
Errno.: 1054
Similar error report has beed dispatched to administrator before.
[ 本帖最後由 牙俊〞 於 2008-7-2 13:15 編輯 ]
|