升级后编辑内容显示查询失败

升级后编辑内容显示查询失败

killerfan 2018-05-08 10:57:21

从5.6.0.20170105一步一步的升级到了6.0.0.20180404。在内容管理界面。找到某一条内容编辑时显示查询失败: SELECT aid,title,subtitle,catid,typeid,tag,spid,toppost,introduce,introduce_len,mtitle,description,keyword,image,thumb,content,isecoding,checked,template,showform,pics,linkto,grade,htmlrule,ishtml,attr1,attr2,listorder,attr3,adddate FROM `cmseasy_archive` WHERE `aid`="16" and (state IS NULL or state<>"-1") ORDER BY 1 desc limit 1
1054
Unknown column "subtitle" in "field list"

    用户管理也提示错误:查询失败: SELECT userid,username,nickname,groupid,checked,ilock FROM `cmseasy_user` ORDER BY `userid` DESC limit 0,12
    1054
    Unknown column "ilock" in "field list"

    赞(0)参加讨论打赏

    subtitle 数据表未升级成功

    赞(0)参加讨论打赏