重新恢复到3.4 升级3.5 又出现的问题 (1062) Duplicate entry '��e��r����G' for key 'username' ALTER TABLE common_me
2023-01-16 23:21 来自 xiao9469 发布@ Discuz!问题求助
3.4 升级3.5 又出现的问题
(1062) Duplicate entry '��e��r����G' for key 'username'
ALTER TABLE common_member_archive CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
这个是编码问题吗？需要如何解决
28293
(1062) Duplicate entry '��e��r����G' for key 'username'
ALTER TABLE common_member_archive CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
这个是编码问题吗？需要如何解决
28293
社区升级时出现1062错误，Duplicate entry for key 'username'
2023-02-06 08:31 来自 惧愁人 发布@ Discuz! X3.5专区
看了一下数据库，common_member_archive这个表和后面的表都没有转换完。前面的转换成功了。
不知道应该怎么解决？
Discuz! Database Error
(1062) Duplicate entry '������������' for key 'username'ALTER TABLE common_member_archive CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
PHP Debug
No.FileLineCode
1install/update_adult.php411discuz_database::query()
2source/class/discuz/discuz_database.php142db_driver_mysqli->query()
3source/class/db/db_driver_mysqli.php147db_driver_mysqli->halt()
4source/class/db/db_drive
不知道应该怎么解决？
Discuz! Database Error
(1062) Duplicate entry '������������' for key 'username'ALTER TABLE common_member_archive CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
PHP Debug
No.FileLineCode
1install/update_adult.php411discuz_database::query()
2source/class/discuz/discuz_database.php142db_driver_mysqli->query()
3source/class/db/db_driver_mysqli.php147db_driver_mysqli->halt()
4source/class/db/db_drive
