|
GBK X3.4升X3.5到了转码这一步出错了,求助大侠咋整
Discuz! Database Error
(1062) Duplicate entry '��e��r����G' for key 'username'
ALTER TABLE common_member_archive CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
PHP Debug
No. File Line Code
1 install/update_adult.php 411 discuz_database::query(%s)
2 source/class/discuz/discuz_database.php 142 db_driver_mysqli->query(%s, false, false)
3 source/class/db/db_driver_mysqli.php 147 db_driver_mysqli->halt(%s, %d, %s)
4 source/class/db/db_driver_mysqli.php 222 break()
5 金币最佳答案
进入数据库,执行语句:select uid from pre_ucenter_members where username in (select username from pre_ucenter_members group by convert(username using utf8mb4) collate utf8mb4_unicode_ci having count(1) > 1)
|
|