|
Discuz! info: MySQL Query Error; |3 y. a, D5 c$ w8 w& a9 L
' c3 {( |3 g7 @- G( A8 w- \User: aster$ h* K! }2 U7 r4 J: G
Time: 2007-3-19 10:03pm
& z, S$ E5 F7 z% V6 B+ ~ ]Script: /bbs/viewthread.php
9 c2 Y( h" P, d3 f& F3 K/ K8 Y" m2 Z( }. a; c
SQL: SELECT p.*, m.uid, m.famname, m.username, m.groupid, m.adminid, m.regdate, m.lastactivity, m.posts, m.digestposts, m.oltime,
7 q" a1 W3 B( r! |* J& d( l4 Z/ Hm.pageviews, m.credits, m.extcredits1, m.extcredits2, m.extcredits3, m.extcredits4, m.extcredits5, m.extcredits6,
. W% k1 d0 m' K- n" W4 D; c6 em.extcredits7, m.extcredits8, m.email, m.gender, m.showemail, m.invisible, m.xspacestatus, mf.nickname, mf.site,$ r3 D$ e" p' E6 |" O% [
mf.icq, mf.qq, mf.yahoo, mf.msn, mf.taobao, mf.alipay, mf.location, mf.medals, mf.avatar, mf.avatarwidth,
: G; n$ a9 O- y* Rmf.avatarheight, mf.sightml AS signature, mf.customstatus, mf.spacename , mf.field_3, mf.field_4
) o0 {, P% F' q7 B- B) G+ K8 TFROM [Table]posts p6 i: k% Z/ n4 Q) u6 h* G: M' l
LEFT JOIN [Table]members m ON m.uid=p.authorid1 F" [# z* R* A2 e9 c
LEFT JOIN [Table]memberfields mf ON mf.uid=m.uid
7 T9 f# y0 P7 n. lWHERE p.tid='48634' AND p.invisible='0' ORDER BY dateline LIMIT 0, 157 m" e1 A( g) E% L& H) R
Error: Unknown column 'm.famname' in 'field list'5 B" q$ j0 z3 {' r! O
Errno.: 1054
2 c2 \; m) q" }- f/ y) A7 g! _% @) H1 m
Similar error report has beed dispatched to administrator before.
* I) M8 l" C& E3 U; F) o) E6 e% N9 D2 y8 f# Q3 r$ u
, w/ d: o7 L0 D& [
这些都是什么?? |
|