|
|
Discuz! info: MySQL Query Error
" _5 J1 y7 u; `/ D: x; H
/ A# V# i4 _$ D9 y8 L4 eUser: aster
$ N- t7 G* u3 p7 D, o! Z5 mTime: 2007-3-19 10:03pm# k7 O( c, z3 Y$ X! _& i
Script: /bbs/viewthread.php
9 c8 I6 ]0 [1 j4 w' \ W. r
# d! Z* p( Y: r4 y- d# u( w1 ?SQL: SELECT p.*, m.uid, m.famname, m.username, m.groupid, m.adminid, m.regdate, m.lastactivity, m.posts, m.digestposts, m.oltime,
4 U: H( L; z9 n* \m.pageviews, m.credits, m.extcredits1, m.extcredits2, m.extcredits3, m.extcredits4, m.extcredits5, m.extcredits6,4 y7 f/ s \( m1 \" s2 L1 ^4 W. l
m.extcredits7, m.extcredits8, m.email, m.gender, m.showemail, m.invisible, m.xspacestatus, mf.nickname, mf.site,
0 z, k7 Z1 M$ Q. P4 p0 V# K R( Kmf.icq, mf.qq, mf.yahoo, mf.msn, mf.taobao, mf.alipay, mf.location, mf.medals, mf.avatar, mf.avatarwidth,3 |8 @5 D$ G$ j' Z" t5 P
mf.avatarheight, mf.sightml AS signature, mf.customstatus, mf.spacename , mf.field_3, mf.field_4
5 C: b" D2 t1 CFROM [Table]posts p# E: Q9 U+ z9 m; L) N
LEFT JOIN [Table]members m ON m.uid=p.authorid
: l: T; ^5 j p/ ]4 hLEFT JOIN [Table]memberfields mf ON mf.uid=m.uid! f5 k+ b7 l! s/ F
WHERE p.tid='48634' AND p.invisible='0' ORDER BY dateline LIMIT 0, 158 G# {9 F' d" I; q& S# G
Error: Unknown column 'm.famname' in 'field list'$ @+ {* q9 U2 {6 j4 P- P* R
Errno.: 1054
; A1 J+ Y2 ^ B: R" B! G' z- C+ h2 r/ B) w
Similar error report has beed dispatched to administrator before.3 m* z0 P b$ H x8 Y0 v- Q
Z# s0 s) a' d9 w7 w$ s
5 @" r3 L! ^4 c3 Q' C$ |. L! F这些都是什么？？ |
|
IP卡
狗仔卡
发表于 2007-3-19 22:05:25
提升卡
置顶卡
沉默卡
喧嚣卡
变色卡
千斤顶
显身卡
楼主
发表于 2007-3-19 22:13:36
