|
Discuz! info: MySQL Query Error/ P4 ~+ o# o) k' Z- l7 K
9 P0 M7 }" m B4 _
User: aster9 I, O6 M. W0 x- Z1 Y5 E% X3 g
Time: 2007-3-19 10:03pm7 v3 k2 y5 M0 j! E* N. C
Script: /bbs/viewthread.php- k' E3 u) w, W9 M. r" n w
9 Y" d6 G9 ]; }, B) d" A, \SQL: SELECT p.*, m.uid, m.famname, m.username, m.groupid, m.adminid, m.regdate, m.lastactivity, m.posts, m.digestposts, m.oltime,% a' w4 i- y( C- f2 b
m.pageviews, m.credits, m.extcredits1, m.extcredits2, m.extcredits3, m.extcredits4, m.extcredits5, m.extcredits6,4 ~1 W6 r4 I' Z$ d
m.extcredits7, m.extcredits8, m.email, m.gender, m.showemail, m.invisible, m.xspacestatus, mf.nickname, mf.site,+ U/ }2 _3 }1 P# L/ n
mf.icq, mf.qq, mf.yahoo, mf.msn, mf.taobao, mf.alipay, mf.location, mf.medals, mf.avatar, mf.avatarwidth,/ A! r k& o" k& B
mf.avatarheight, mf.sightml AS signature, mf.customstatus, mf.spacename , mf.field_3, mf.field_4; y1 p4 ]& M/ v, N' B! j8 [/ G/ g4 v
FROM [Table]posts p
% p9 t1 P2 d7 W. b1 bLEFT JOIN [Table]members m ON m.uid=p.authorid" l8 o5 h! J6 _" l* D3 g
LEFT JOIN [Table]memberfields mf ON mf.uid=m.uid
& T! c6 M$ a1 {WHERE p.tid='48634' AND p.invisible='0' ORDER BY dateline LIMIT 0, 15
+ n4 p, d9 H4 ]: |/ I) V. S# yError: Unknown column 'm.famname' in 'field list'
& c4 A2 _$ K4 ~/ n4 mErrno.: 1054
% k$ U" r" S e( I9 s S9 G4 f& A- @% {" X
Similar error report has beed dispatched to administrator before.0 S% z5 H3 p& P8 B% }& r. h
- z% R. s* q; i4 ?! R! M
+ U, l9 M. j! F这些都是什么?? |
|