|
发表于 2023-4-15 07:44:10
|
显示全部楼层
升级表 pre_forum_post 出错,请手工执行以下升级语句后,再重新运行本升级程序:
升级SQL语句:
ALTER TABLE pre_forum_post CHANGE `tid` `tid` int(10) unsigned NOT NULL DEFAULT '0', ADD `repid` int(10) unsigned NOT NULL DEFAULT '0' AFTER `tid`, CHANGE `subject` `subject` varchar(255) NOT NULL DEFAULT '', ADD `lastupdate` int(10) unsigned NOT NULL DEFAULT '0' AFTER `dateline`, ADD `updateuid` mediumint(8) unsigned NOT NULL DEFAULT '0' AFTER `lastupdate`, ADD `premsg` text NOT NULL AFTER `updateuid`, CHANGE `useip` `useip` varchar(45) NOT NULL DEFAULT '', CHANGE `position` `position` int(10) unsigned NOT NULL
Error: Duplicate column name 'repid'
Errno.: 1060
手工运行也不行! |
|