|
|
Discuz! info: MySQL Query Error6 u( C6 S5 y0 V4 p" z) z. b2 j
" }& {& D4 R/ z( J5 }1 W0 l7 V- t
User: aster1 d) z+ W: n, O1 O
Time: 2007-3-19 10:03pm
' E+ V6 W4 h: }$ K1 A& qScript: /bbs/viewthread.php
5 A% ~- ~- h, Z6 G9 Y# s& Z) U4 p" m6 |7 Z# E
SQL: SELECT p.*, m.uid, m.famname, m.username, m.groupid, m.adminid, m.regdate, m.lastactivity, m.posts, m.digestposts, m.oltime,& @/ z8 k$ K# k. b- O8 e$ e
m.pageviews, m.credits, m.extcredits1, m.extcredits2, m.extcredits3, m.extcredits4, m.extcredits5, m.extcredits6,# d6 S2 f4 d: Q" Z9 k
m.extcredits7, m.extcredits8, m.email, m.gender, m.showemail, m.invisible, m.xspacestatus, mf.nickname, mf.site,
$ F- f: p+ Q% s6 x* I6 D$ ?. f; E4 {mf.icq, mf.qq, mf.yahoo, mf.msn, mf.taobao, mf.alipay, mf.location, mf.medals, mf.avatar, mf.avatarwidth,
3 {5 `( O7 ] L6 \% Imf.avatarheight, mf.sightml AS signature, mf.customstatus, mf.spacename , mf.field_3, mf.field_4' z6 s" ^5 ^: }7 I# p" a
FROM [Table]posts p9 Y5 ?2 X# a+ f6 _$ X- z
LEFT JOIN [Table]members m ON m.uid=p.authorid" g# P4 J, R$ g/ A e
LEFT JOIN [Table]memberfields mf ON mf.uid=m.uid1 D2 t) x5 U3 M8 @6 U9 V ^7 {
WHERE p.tid='48634' AND p.invisible='0' ORDER BY dateline LIMIT 0, 15# U- ]! E8 m Q) V
Error: Unknown column 'm.famname' in 'field list'
& \, k4 Z2 S& m" h" T& sErrno.: 1054
6 v9 o* m$ w9 X' Z* g5 _: H6 v8 T9 P; u0 M. Q5 H
Similar error report has beed dispatched to administrator before.
, m x* t6 \, p# d3 V/ r1 M- u# ^4 ?$ i8 [
4 ~& ^8 s, |) }- I2 z6 X这些都是什么？？ |
|
IP卡
狗仔卡
发表于 2007-3-19 22:05:25
提升卡
置顶卡
沉默卡
喧嚣卡
变色卡
千斤顶
显身卡
楼主
发表于 2007-3-19 22:13:36
