|
Discuz! info: MySQL Query Error# i! a7 [; }0 W2 ~; O- U! M" l6 `
l! _& v* i' ~, m' R, vUser: aster
8 \' j d9 d: J" H0 A, CTime: 2007-3-19 10:03pm
$ K4 X* f2 j% \Script: /bbs/viewthread.php$ a. p" E- h" G3 }' a
8 m1 F% b( [5 k* j# C1 O' w
SQL: SELECT p.*, m.uid, m.famname, m.username, m.groupid, m.adminid, m.regdate, m.lastactivity, m.posts, m.digestposts, m.oltime,
7 a. s7 n: p% c2 Ym.pageviews, m.credits, m.extcredits1, m.extcredits2, m.extcredits3, m.extcredits4, m.extcredits5, m.extcredits6,
' J2 u6 y+ F k6 O; R% A2 pm.extcredits7, m.extcredits8, m.email, m.gender, m.showemail, m.invisible, m.xspacestatus, mf.nickname, mf.site,* r6 S* I/ g. K' |8 C" s! A
mf.icq, mf.qq, mf.yahoo, mf.msn, mf.taobao, mf.alipay, mf.location, mf.medals, mf.avatar, mf.avatarwidth, V$ F! ~; b3 U. W& _7 Q, V# F, V
mf.avatarheight, mf.sightml AS signature, mf.customstatus, mf.spacename , mf.field_3, mf.field_4% o Z$ ^! @. q4 J9 L) ]+ ]
FROM [Table]posts p
8 j+ i d4 x8 j7 O; d/ R5 ALEFT JOIN [Table]members m ON m.uid=p.authorid- k( {: z' w* t4 m9 p
LEFT JOIN [Table]memberfields mf ON mf.uid=m.uid8 J4 b% C2 O, D! ^4 ^
WHERE p.tid='48634' AND p.invisible='0' ORDER BY dateline LIMIT 0, 15
; ]* ?. G8 u* B$ qError: Unknown column 'm.famname' in 'field list'$ ?, X8 j! `; a1 S$ o+ }
Errno.: 1054- ]- n8 P* j1 u- w) a9 N, w( l
! n7 I6 o: R' a+ |Similar error report has beed dispatched to administrator before.
- J4 T2 q. W6 L
6 o" p- t& S% q, ~% f; |- s j# T$ t
9 T7 _2 q$ t; I2 p B这些都是什么?? |
|