版主,我导入用户时出现如下提示:
由于我不懂数据库,请帮忙看一下是哪里的问题
代码:
数据库出现错误:
查询失败:
SELECT u.userid AS importuserid,u.username AS name,u.avatarrevision, u.membergroupids AS membergroupids,u.password AS password,u.email AS email,u.posts AS posts,u.gender,u.usertitle AS customtitle,u.pmtotal,u.pmunread,u.lastvisit AS lastvisit,u.lastactivity AS lastactivity,u.lastpost AS lastpost,u.homepage AS website,u.aim AS aim,u.qq AS qq,u.msn AS msn,u.icq AS icq,u.yahoo AS yahoo,ut.signature AS signature,u.joindate AS joindate, ca.filename AS avatarlocation,ca.avatardata AS avatardata,u.savemt AS mkaccount, u.ipaddress AS host,u.usergroupid AS importusergroupid,u.salt AS salt,u.options AS options, u.reputation, u.timezoneoffset AS timezoneoffset,ug.usergroupid,u.birthday_search AS birthday,av.avatarpath,uf.field2 as location , u.money as cash, u.bank as bank, u.goodnees as quintessence,u.referrerid
FROM mmkk.user u
LEFT JOIN mmkk.usertextfield ut on (ut.userid = u.userid)
LEFT JOIN mmkk.userfield uf on (uf.userid = u.userid)
LEFT JOIN mmkk.customavatar ca on (ca.userid = u.userid)
LEFT JOIN mmkk.avatar av on (av.avatarid = u.avatarid)
LEFT JOIN mx_usergroup ug on (u.usergroupid = ug.importusergroupid)
WHERE NOT(importusergroupid=1 AND ug.usergroupid!=2) ORDER BY importuserid LIMIT 0,300
MySQL 错误: Unknown column 'u.savemt' in 'field list'