问题描述:
我执行后,社区导航设置,添加导航时,依然显示如下错误:
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 ;
新闻热点
疑难解答