早就想用,一直没时间来处理,今天我正好有点空,就转换下看看下面有很多相对专业的东西,熟悉的人一看就明白
按照官方转换说明,先打包论坛程序到dx2,上传xiuno并安装,安装后拷贝转化文件到根目录,开始升级
问题一:MySQL Query Error:REPLACE INTO xiuno_thread_type SET fid='37',typeid='1',oldtypeid='11',oldfid='0',typename='精品模板',rank='0',enable='1'. Unknown column 'oldtypeid' in 'field list'
说明:xiuno_thread_type表中缺少2个字段,无法插入,修正sql增加字段再运行升级
解决SQL:ALTER TABLE `xiuno_thread_type` ADD `oldtypeid` TINYINT( 2 ) UNSIGNED NOT NULL ,
ADD `oldfid` TINYINT( 2 ) UNSIGNED NOT NULL
问题二:MySQL Query Error:REPLACE INTO xiuno_forum SET fid='37',fup='1',name='杰奇模板',rank='1',threads='53',posts='244',todayposts='0',lasttid='363',brief='',accesson='0',modids='',modnames='',toptids='',orderby='0',seo_title='',seo_keywords=''. Unknown column 'fup' in 'field list'
说明:xiuno_forum表中缺少fup字段,无法插入,修正sql增加字段再运行升级
解决SQL:ALTER TABLE `xiuno_forum` ADD `fup` TINYINT( 1 ) UNSIGNED NOT NULL
问题三:MySQL Query Error:REPLACE INTO xiuno_user_ext SET gender='0',birthyear='0',birthmonth='0',birthday='0',province='',city='',county='',uid='3'. Table 'bbs.xiuno_user_ext' doesn't exist
说明:`xiuno_user_ext`表不存在
建表再升级
解决SQL:
CREATE TABLE IF NOT EXISTS `xiuno_user_ext` (
`uid` int(10) unsigned NOT NULL,
`gender` int(10) unsigned NOT NULL,
`birthyear` int(4) unsigned NOT NULL,
`birthmonth` tinyint(2) unsigned NOT NULL,
`birthday` tinyint(2) unsigned NOT NULL,
`province` tinyint(1) unsigned NOT NULL,
`city` char(15) NOT NULL,
`county` char(15) NOT NULL,
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
问题四:
MySQL Query Error:REPLACE INTO xiuno_friendlink SET linkid='12',type='1',rank='0',sitename='51模板',url='http://51muban.cn',logo='https://www.qiquanji.com/bbs/template/mobfound/style/v1/logo.png'. Table 'bbs.xiuno_friendlink' doesn't exist
说明:`xiuno_friendlink`表不存在
建表再升级
解决SQL:
CREATE TABLE IF NOT EXISTS `xiuno_friendlink` (
`linkid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`url` char(25) NOT NULL,
`logo` varchar(100) NOT NULL,
`rank` tinyint(2) unsigned NOT NULL,
`type` tinyint(1) unsigned NOT NULL,
`sitename` char(15) NOT NULL,
PRIMARY KEY (`linkid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
直到这里,才升级完毕,初步看了下,附件的付费积分好像清零了,这个有点问题,其他等待观察
原文链接:https://www.qiquanji.com/post/7442.html
本站声明:网站内容来源于网络,如有侵权,请联系我们,我们将及时处理。
微信扫码关注
更新实时通知