8.0升级8.3出现数据库出现：Unknown column 'selflisttype' in 'field list' ( 1054 ) ...

问题描述：

我执行后，社区导航设置，添加导航时，依然显示如下错误：

Query Error: INSERT INTO pw_nav SET `upid` ='0', `title` ='留言', `link` ='http://www.123.cn/liuyan', `style` ='|||', `pos` ='bbs,o,area,srch,group', `alt` ='', `target` ='1', `view` ='6', `isshow` ='1', `floattype` ='cross', `listtype` ='space', `selflisttype` ='space', `type` ='main'

The URL Is:

http://www.xxx.cn/admin.php?adminjob=customnav&adminitem=navmain&verify=40cd9a56&

MySQL Server Error:

Unknown column 'selflisttype' in 'field list' ( 1054 ) 查看错误相关信息

解决方法：

你这字段肯定少了不是一两个

删了出错的表

然后执行

CREATE TABLE IF NOT EXISTS `pw_nav` (

`nid` smallint(6) NOT NULL AUTO_INCREMENT,

`nkey` varchar(32) NOT NULL DEFAULT '',

`type` varchar(32) NOT NULL DEFAULT '',

`title` char(50) NOT NULL DEFAULT '',

`style` char(50) NOT NULL DEFAULT '',

`link` char(100) NOT NULL DEFAULT '',

`alt` char(50) NOT NULL DEFAULT '',

`pos` char(32) NOT NULL,

`target` tinyint(3) NOT NULL DEFAULT '0',

`view` smallint(6) NOT NULL DEFAULT '0',

`upid` smallint(6) NOT NULL DEFAULT '0',

`isshow` tinyint(3) NOT NULL DEFAULT '0',

`floattype` varchar(10) NOT NULL DEFAULT '',

`listtype` varchar(10) NOT NULL DEFAULT '',

`selflisttype` varchar(10) NOT NULL DEFAULT '',

PRIMARY KEY (`nid`)

) ENGINE=MyISAM DEFAULT CHARSET=gbk AUTO_INCREMENT=1 ;