3.4升级到3.5，请教一个数据库删除重复值的问题
2023-03-08 16:10 来自 浅生 发布@ Discuz! X3.5专区
昨晚3.4升级到3.5期间，遇到出错提示：
提示信息如下：
升级表 pre_forum_hotreply_number 出错,请手工执行以下升级语句后,再重新运行本升级程序:
升级SQL语句:
ALTER TABLE pre_forum_hotreply_number CHANGE `pid` `pid` int(10) unsigned NOT NULL DEFAULT '0', CHANGE `tid` `tid` int(10) unsigned NOT NULL DEFAULT '0', CHANGE `support` `support` smallint(6) unsigned NOT NULL DEFAULT '0', CHANGE `against` `against` smallint(6) unsigned NOT NULL DEFAULT '0', CHANGE `total` `total` mediumint(8) unsigned NOT NULL DEFAULT '0', ADD PRIMARY KEY (pid)
运行后提示
提示信息如下：
升级表 pre_forum_hotreply_number 出错,请手工执行以下升级语句后,再重新运行本升级程序:
升级SQL语句:
ALTER TABLE pre_forum_hotreply_number CHANGE `pid` `pid` int(10) unsigned NOT NULL DEFAULT '0', CHANGE `tid` `tid` int(10) unsigned NOT NULL DEFAULT '0', CHANGE `support` `support` smallint(6) unsigned NOT NULL DEFAULT '0', CHANGE `against` `against` smallint(6) unsigned NOT NULL DEFAULT '0', CHANGE `total` `total` mediumint(8) unsigned NOT NULL DEFAULT '0', ADD PRIMARY KEY (pid)
运行后提示
