升级程序让我手工运行SQL New
2023-11-28 15:27 来自 𝕷𝖎𝖑𝖏𝖆𝖈𝖐 发布@ Discuz! X3.5专区
运行提示错误#1060 - Duplicate column name 'repid'
但是刷新页面升级页面，又提示升级成功继续了下一步升级 我现在需要怎么做啊
ALTER TABLE pre_forum_post CHANGE `pid` `pid` int(10) unsigned NOT NULL, CHANGE `fid` `fid` mediumint(8) unsigned NOT NULL DEFAULT '0', CHANGE `tid` `tid` int(10) unsigned NOT NULL DEFAULT '0', ADD `repid` int(10) unsigned NOT NULL DEFAULT '0' AFTER `tid`, CHANGE `authorid` `authorid` mediumint(8) unsigned NOT NULL DEFAULT '0', CHANGE `subject` `subject` varchar(255) NOT NULL DEFAULT '', CHANGE `dateline` `dateline`
但是刷新页面升级页面，又提示升级成功继续了下一步升级 我现在需要怎么做啊
ALTER TABLE pre_forum_post CHANGE `pid` `pid` int(10) unsigned NOT NULL, CHANGE `fid` `fid` mediumint(8) unsigned NOT NULL DEFAULT '0', CHANGE `tid` `tid` int(10) unsigned NOT NULL DEFAULT '0', ADD `repid` int(10) unsigned NOT NULL DEFAULT '0' AFTER `tid`, CHANGE `authorid` `authorid` mediumint(8) unsigned NOT NULL DEFAULT '0', CHANGE `subject` `subject` varchar(255) NOT NULL DEFAULT '', CHANGE `dateline` `dateline`
3.4升级3.5出错 (1060) Duplicate column name 'secmobicc'
2023-02-28 11:31 来自 浅生 发布@ Discuz! X3.5专区
Discuz! Database ErrorTime: 2023-02-28 18:29:36 IP: 1.30.109.129 BackTraceID: ae21839c3a8af2cb65ee07e48b2abd00
(1060) Duplicate column name 'secmobicc'ALTER TABLE common_member_archive MODIFY COLUMN email varchar(255) NOT NULL DEFAULT '', ADD COLUMN `secmobile` varchar(12) NOT NULL DEFAULT '' AFTER `password`, ADD COLUMN `secmobicc` varchar(3) NOT NULL DEFAULT '' AFTER `password`, ADD COLUMN `secmobilestatus` tinyint(1) NOT NULL DEFAULT '0' AFTER avatarstatus, ADD KEY secmobile (`secmobile`, `s
(1060) Duplicate column name 'secmobicc'ALTER TABLE common_member_archive MODIFY COLUMN email varchar(255) NOT NULL DEFAULT '', ADD COLUMN `secmobile` varchar(12) NOT NULL DEFAULT '' AFTER `password`, ADD COLUMN `secmobicc` varchar(3) NOT NULL DEFAULT '' AFTER `password`, ADD COLUMN `secmobilestatus` tinyint(1) NOT NULL DEFAULT '0' AFTER avatarstatus, ADD KEY secmobile (`secmobile`, `s
