- [Type] 查询语句错误
- [1016] Can't open file: './discuzx/common_member_field_home.frm' (errno: 24)
- [Query] SELECT m.uid, m.username, m.groupid, m.adminid, m.regdate, m.credits, m.email, m.status AS memberstatus,
ms.lastactivity, ms.lastactivity, ms.invisible AS authorinvisible,
mc.*, mp.gender, mp.site, mp.icq, mp.qq, mp.yahoo, mp.msn, mp.taobao, mp.alipay,
mf.medals, mf.sightml AS signature, mf.customstatus, mh.privacy ,
mm.magicid
FROM common_member m
LEFT JOIN common_member_field_forum mf USING(uid)
LEFT JOIN common_member_status ms USING(uid)
LEFT JOIN common_member_count mc USING(uid)
LEFT JOIN common_member_profile mp USING(uid)
LEFT JOIN common_member_field_home mh USING(uid)
LEFT JOIN common_member_magic mm ON mm.uid=m.uid AND mm.num=1 AND mm.isuse=1
WHERE m.uid IN ('29587210','6640464','4899830','29453446','30785405','1806647','28700720','21527060','31389514','3813077','2527418','28803234','31143197','25305417','29563687','19859126','2616909','30298964','6053367','31567934')
|