discuzX3.4数据库改用utf8mb4字符集，实现emoji表情符

wuyou

discuzX 3.4 默认字符集是utf8,安装后无法发一些表情符，也不能用表情符当用户名。

现在做测试改成 utf8mb4

测试机环境
centos 7.5
mysql 8.0.11
php 7.2.5
apache 2.4.6

一、全新安装

下载补丁文件，替换加入到discuzX 3.4 2018.01.01官方原版文件中，即可完成安装。

patch_utf8mb4.zip (47.35 KB, 下载次数: 104)

2018-5-27 10:12 上传

点击文件名下载附件

二、换服务器升级安装（内容更新中）

1.导出旧空间上数据库的表结构文件struct.sql 和 数据文件data.sql  

1. mysqldump -d -u root -p$mysqlpass bbs > struct.sql
   
2. mysqldump -t -u root -p$mysqlpass bbs --default-character-set=UTF8 > data.sql

复制代码

2.修改表结构文件 struct.sql，

_ci结尾的校对集大小写不敏感，即不区分大小写,ci是 case insensitive, 即 "大小写不敏感", a 和 A 会在字符判断中会被当做一样的.
凡是在以前导入中提示 ERROR 1062 (23000): Duplicate entry 'xxxx' for key 'username' 之类的提示，往往出在选用不当的校对集引起的。
本次升级调试时使用了_ci的校对集，就遇到这个问题，象 'Avaloń' 与 'avalon' 被认为是重复，导致导入失败。

校对集 COLLATE=utf8mb4_bin 是区分大小写，可以防止旧库中有KEY属性的论坛用户名ABC、abc导入时被认为是重复的问题。

修改struct.sql

DEFAULT CHARSET=gbk 全部改成 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin
varchar(255) 修改值
char(255) 修改值

callsed 文件内容

1. /^CREATE TABLE `pre_common_addon`/,/^) ENGINE=MyISAM/s/`key` varchar(255)/`key` varchar(250)/
   
2. /^CREATE TABLE `pre_common_admincp_perm`/,/^) ENGINE=MyISAM/s/`perm` varchar(255)/`perm` varchar(244)/
   
3. /^CREATE TABLE `pre_common_advertisement_custom`/,/^) ENGINE=MyISAM/s/`name` varchar(255)/`name` varchar(250)/
   
4. /^CREATE TABLE `pre_common_cache`/,/^) ENGINE=MyISAM/s/`cachekey` varchar(255)/`cachekey` varchar(250)/
   
5. /^CREATE TABLE `pre_common_card`/,/^) ENGINE=MyISAM/s/`id` char(255)/`id` char(250)/
   
6. /^CREATE TABLE `pre_common_member_profile_setting`/,/^) ENGINE=MyISAM/s/`fieldid` varchar(255)/`fieldid` varchar(250)/
   
7. /^CREATE TABLE `pre_common_member_security`/,/^) ENGINE=MyISAM/s/`fieldid` varchar(255)/`fieldid` varchar(242)/
   
8. /^CREATE TABLE `pre_common_setting`/,/^) ENGINE=MyISAM/s/`skey` varchar(255)/`skey` varchar(250)/
   
9. /^CREATE TABLE `pre_forum_groupfield`/,/^) ENGINE=MyISAM/s/`type` varchar(255)/`type` varchar(242)/
   
10. /^CREATE TABLE `pre_home_favorite`/,/^) ENGINE=MyISAM/s/`idtype` varchar(255)/`idtype` varchar(232)/
    
11. /^CREATE TABLE `pre_mobile_setting`/,/^) ENGINE=MyISAM/s/`skey` varchar(255)/`skey` varchar(250)/
    
12. /^CREATE TABLE `pre_portal_topic`/,/^) ENGINE=MyISAM/s/`name` varchar(255)/`name` varchar(250)/
    
13. /^CREATE TABLE `cdb_uc_badwords`/,/^) ENGINE=MyISAM/s/`find` varchar(255)/`find` varchar(250)/
    
14. s/DEFAULT CHARSET=gbk/DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin/

复制代码

在linux shell 下执行以下命令进行替换

1. sed -i -f callsed struct.sql

复制代码

也可以在mysql 命令行下先修改原库(注意先备份数据库）

1. USE bbs;
   
2. 
   
3. ALTER TABLE `pre_common_addon` MODIFY COLUMN `key` varchar(250);
   
4. ALTER TABLE `pre_common_admincp_perm` MODIFY COLUMN `perm` varchar(244);
   
5. ALTER TABLE `pre_common_advertisement_custom` MODIFY COLUMN `name` varchar(250);
   
6. ALTER TABLE `pre_common_cache` MODIFY COLUMN `cachekey` varchar(250);
   
7. ALTER TABLE `pre_common_card` MODIFY COLUMN `id` char(250);
   
8. ALTER TABLE `pre_common_member_profile_setting` MODIFY COLUMN `fieldid` varchar(250);
   
9. ALTER TABLE `pre_common_member_security` MODIFY COLUMN `fieldid` varchar(242);
   
10. ALTER TABLE `pre_common_setting` MODIFY COLUMN `skey` varchar(250);
    
11. ALTER TABLE `pre_forum_groupfield` MODIFY COLUMN `type` varchar(242);
    
12. ALTER TABLE `pre_home_favorite` MODIFY COLUMN `idtype` varchar(232);
    
13. ALTER TABLE `pre_mobile_setting` MODIFY COLUMN `skey` varchar(250);
    
14. ALTER TABLE `pre_portal_topic` MODIFY COLUMN `name` varchar(250);
    
15. ALTER TABLE `cdb_uc_badwords` MODIFY COLUMN `find` varchar(250);

复制代码

3.在新空间的 mysql命令行下，导入struct.sql 和 数据文件data.sql  

1. USE bbs;
   
2. SOURCE struct.sql;
   
3. SOURCE data.sql

复制代码

4.恢复旧空间的web数据库到新空间上，修改以下文件，将第一次出现连接库的'gbk' 改为 'utf8mb4'.每个文件只改一处。
config/config_global.php
config/config_global.php
uc_server/data/config.inc.php

5.按官方升级要求，上传官方版文件替换，进后台 > 工具 > 更新缓存。
另外还有source/class/table/下面三个文件需要更新，具体见本帖上方发的全新安装补丁包中提取。
table_common_usergroup.php
table_forum_announcement.php
table_forum_forum.php

6.界面 > 编辑器设置 > Discuz!代码，删除那些不可用的标签，可解决因使用Discuz标签而导致帖子内容无法正常显示的问题。

7.升级安装成功

目前仍存在问题：编辑正在投放的广告位时无内容显示。

这次还发现有一个分页标签，点下方的2可以看下一页，一直没用过这个标签，第一次用。

pcfan120

帮顶，希望论坛里有熟悉数据库的大大帮早日解决。。。

wuyou

pcfan120 发表于 2018-5-26 18:54
帮顶，希望论坛里有熟悉数据库的大大帮早日解决。。。

现在已经搞定程序，在测试机上可以发以前不能正常显示表情符了。

邪恶海盗

打算把论坛升到DZX3.4???

wuyou

邪恶海盗 发表于 2018-5-26 22:08
打算把论坛升到DZX3.4???

升级是肯定的，只是要做的准备工作很多很多。
最关键是服务器系统得重装。

邪恶海盗

wuyou 发表于 2018-5-26 22:17
升级是肯定的，只是要做的准备工作很多很多。
最关键是服务器系统得重装。

个人认为没必要,反正流量又不高,没什么硬性需求...

wuyou

邪恶海盗 发表于 2018-5-26 22:42
个人认为没必要,反正流量又不高,没什么硬性需求...

主要还是考虑安全问题，毕竟老系统问题多多。

邪恶海盗

wuyou 发表于 2018-5-26 23:05
主要还是考虑安全问题，毕竟老系统问题多多。

还有的还在用DZ5和7呢...

wuyou

邪恶海盗 发表于 2018-5-26 23:09
还有的还在用DZ5和7呢...

低版本的系统，官方都不会提供补丁，就是一个不设防的系统，人家可以自由进出.

pcfan120

版主辛苦了。。希望论坛越来越好。。

起舞

在非DZ官方论坛能看到谈论论坛安装升级的帖子好惊讶。不禁想起多年前和朋友一起往论坛安装各种插件的往事。

wuyou

起舞 发表于 2018-5-27 20:29
在非DZ官方论坛能看到谈论论坛安装升级的帖子好惊讶。不禁想起多年前和朋友一起往论坛安装各种插件的往事。

现在玩论坛的人也少了，很多论坛都关了，不象多年以前大家都有这个热情。

wuyou

测试一下 🐻

wuyou

目前在虚拟机上，已成功升级本论坛程序到支持utf8mb4字符集的discuzX 3.4 20180101

1.直接处理备份的、编码是 utf8 的bbs.sql文件，简单粗暴的办法，就是将文件中的所有出现

DEFAULT CHARSET=utf8 改为 DEFAULT CHARSET=utf8mb4
char(255) 改为 char(230)    //可能会出现误改帖中相同内容

1. #!/bin/bash
   
2. 
   
3. cd /home/bbs/others/
   
4. sed -i '/DEFAULT CHARSET=utf8[^m]/s/DEFAULT CHARSET=utf8/&mb4 COLLATE=utf8mb4_general_ci/' bbs.sql
   
5. sed -i 's/` char(255) /` char(230) /g' bbs.sql
   
6. sed -i 's/` varchar(255) /` varchar(230) /g' bbs.sql

复制代码

再导入bbs.sql到数据库，同时更新 三个 config文件中的utf8 为 utf8mb4

2.对已经运行utf8版，直接处理。

现有的方法是：

1.在成功运行utf8的论坛的基础上，进入mysql 命令行，运行以下代码，注意一次运行十行以内代码，不然会出错。
注意，以下cdb_uc_开头的表是可能不是你库中的表，请自行修正。

1. use bbs;
   
2. 
   
3. alter table pre_common_admincp_perm modify perm varchar(230) NOT NULL;
   
4. alter table pre_common_cache modify `cachekey` varchar(230) NOT NULL DEFAULT '' ;
   
5. alter table pre_common_card modify `id` char(230) NOT NULL DEFAULT '';
   
6. alter table pre_common_member_profile_setting modify `fieldid` varchar(230) NOT NULL DEFAULT '';
   
7. alter table pre_common_member_security modify `fieldid` varchar(230) NOT NULL DEFAULT '';
   
8. alter table pre_common_setting modify `skey` varchar(230) NOT NULL DEFAULT '';
   
9. alter table pre_forum_groupfield modify `type` varchar(230) NOT NULL;
   
10. alter table pre_home_favorite modify `idtype` varchar(230) NOT NULL DEFAULT '';
    
11. alter table pre_mobile_setting modify `skey` varchar(230) NOT NULL DEFAULT '';
    
12. alter table cdb_uc_badwords modify `find` varchar(230) NOT NULL DEFAULT '';
    
13. alter table pre_common_addon modify `key` varchar(230) NOT NULL DEFAULT '';
    
14. alter table pre_common_advertisement_custom modify `name` varchar(230) NOT NULL;
    
15. alter table pre_portal_topic modify `name` varchar(230) NOT NULL DEFAULT '';
    
16. 
    
17. ALTER DATABASE bbs CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
    
18. 
    
19. alter table cdb_uc_admins convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
    
20. alter table cdb_uc_applications convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
    
21. alter table cdb_uc_badwords convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
    
22. alter table cdb_uc_domains convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
    
23. alter table cdb_uc_failedlogins convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
    
24. 
    
25. alter table cdb_uc_feeds convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
    
26. alter table cdb_uc_friends convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
    
27. alter table cdb_uc_mailqueue convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
    
28. alter table cdb_uc_memberfields convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
    
29. 
    
30. alter table cdb_uc_members convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
    
31. alter table cdb_uc_mergemembers convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
    
32. alter table cdb_uc_newpm convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
    
33. alter table cdb_uc_notelist convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
    
34. alter table cdb_uc_pm_indexes convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
    
35. 
    
36. alter table cdb_uc_pm_lists convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
    
37. alter table cdb_uc_pm_members convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
    
38. alter table cdb_uc_pm_messages_0 convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
    
39. alter table cdb_uc_pm_messages_1 convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
    
40. 
    
41. alter table cdb_uc_pm_messages_2 convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
    
42. alter table cdb_uc_pm_messages_3 convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
    
43. alter table cdb_uc_pm_messages_4 convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
    
44. alter table cdb_uc_pm_messages_5 convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
    
45. alter table cdb_uc_pm_messages_6 convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
    
46. 
    
47. alter table cdb_uc_pm_messages_7 convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
    
48. alter table cdb_uc_pm_messages_8 convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
    
49. alter table cdb_uc_pm_messages_9 convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
    
50. alter table cdb_uc_pms convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
    
51. alter table cdb_uc_protectedmembers convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
    
52. 
    
53. alter table cdb_uc_settings convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
    
54. alter table cdb_uc_sqlcache convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
    
55. alter table cdb_uc_tags convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
    
56. alter table cdb_uc_vars convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
    
57. alter table pre_common_addon convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
    
58. alter table pre_common_admincp_cmenu convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
    
59. alter table pre_common_admincp_group convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
    
60. 
    
61. alter table pre_common_admincp_member convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
    
62. alter table pre_common_admincp_perm convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
    
63. alter table pre_common_admincp_session convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
    
64. alter table pre_common_admingroup convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
    
65. alter table pre_common_adminnote convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
    
66. alter table pre_common_advertisement convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
    
67. alter table pre_common_advertisement_custom convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
    
68. 
    
69. alter table pre_common_banned convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
    
70. alter table pre_common_block convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
    
71. alter table pre_common_block_favorite convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
    
72. alter table pre_common_block_item convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
    
73. alter table pre_common_block_item_data convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
    
74. 
    
75. alter table pre_common_block_permission convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
    
76. alter table pre_common_block_pic convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
    
77. alter table pre_common_block_style convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
    
78. alter table pre_common_block_xml convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
    
79. alter table pre_common_cache convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
    
80. alter table pre_common_card convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
    
81. 
    
82. alter table pre_common_card_log convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
    
83. alter table pre_common_card_type convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
    
84. alter table pre_common_connect_guest convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
    
85. alter table pre_common_credit_log convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
    
86. alter table pre_common_credit_log_field convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
    
87. alter table pre_common_credit_rule convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
    
88. 
    
89. 
    
90. alter table pre_common_credit_rule_log convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
    
91. alter table pre_common_credit_rule_log_field convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
    
92. alter table pre_common_cron convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
    
93. alter table pre_common_devicetoken convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
    
94. alter table pre_common_district convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
    
95. alter table pre_common_diy_data convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
    
96. 
    
97. 
    
98. alter table pre_common_domain convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
    
99. alter table pre_common_failedip convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
    
100. alter table pre_common_failedlogin convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
101. alter table pre_common_friendlink convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
102. alter table pre_common_grouppm convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
103. alter table pre_common_invite convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
104. 
     
105. alter table pre_common_magic convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
106. alter table pre_common_magiclog convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
107. alter table pre_common_mailcron convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
108. alter table pre_common_mailqueue convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
109. alter table pre_common_member convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
110. alter table pre_common_member_action_log convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
111. 
     
112. alter table pre_common_member_archive convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
113. alter table pre_common_member_connect convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
114. alter table pre_common_member_count convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
115. alter table pre_common_member_count_archive convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
116. alter table pre_common_member_crime convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
117. alter table pre_common_member_field_forum convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
118. 
     
119. 
     
120. alter table pre_common_member_field_forum_archive convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
121. alter table pre_common_member_field_home convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
122. alter table pre_common_member_field_home_archive convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
123. alter table pre_common_member_forum_buylog convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
124. alter table pre_common_member_grouppm convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
125. alter table pre_common_member_log convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
126. alter table pre_common_member_magic convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
127. 
     
128. alter table pre_common_member_medal convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
129. alter table pre_common_member_newprompt convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
130. alter table pre_common_member_profile convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
131. alter table pre_common_member_profile_archive convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
132. alter table pre_common_member_profile_setting convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
133. alter table pre_common_member_security convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
134. alter table pre_common_member_secwhite convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
135. 
     
136. alter table pre_common_member_stat_field convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
137. alter table pre_common_member_stat_fieldcache convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
138. alter table pre_common_member_stat_search convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
139. alter table pre_common_member_stat_searchcache convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
140. alter table pre_common_member_status convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
141. alter table pre_common_member_status_archive convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
142. alter table pre_common_member_validate convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
143. 
     
144. alter table pre_common_member_verify convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
145. alter table pre_common_member_verify_info convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
146. alter table pre_common_member_wechat convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
147. alter table pre_common_member_wechatmp convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
148. alter table pre_common_moderate convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
149. alter table pre_common_myapp convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
150. 
     
151. alter table pre_common_myinvite convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
152. alter table pre_common_mytask convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
153. alter table pre_common_nav convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
154. alter table pre_common_onlinetime convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
155. alter table pre_common_optimizer convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
156. alter table pre_common_patch convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
157. alter table pre_common_plugin convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
158. 
     
159. alter table pre_common_pluginvar convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
160. alter table pre_common_process convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
161. alter table pre_common_regip convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
162. alter table pre_common_relatedlink convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
163. alter table pre_common_remote_port convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
164. alter table pre_common_report convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
165. alter table pre_common_searchindex convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
166. 
     
167. alter table pre_common_seccheck convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
168. alter table pre_common_secquestion convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
169. alter table pre_common_session convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
170. alter table pre_common_setting convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
171. alter table pre_common_smiley convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
172. alter table pre_common_sphinxcounter convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
173. alter table pre_common_stat convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
174. 
     
175. alter table pre_common_statuser convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
176. alter table pre_common_style convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
177. alter table pre_common_stylevar convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
178. alter table pre_common_syscache convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
179. alter table pre_common_tag convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
180. alter table pre_common_tagitem convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
181. alter table pre_common_task convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
182. 
     
183. alter table pre_common_taskvar convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
184. alter table pre_common_template convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
185. alter table pre_common_template_block convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
186. alter table pre_common_template_permission convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
187. alter table pre_common_uin_black convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
188. alter table pre_common_usergroup convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
189. alter table pre_common_usergroup_field convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
190. alter table pre_common_visit convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
191. 
     
192. alter table pre_common_word convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
193. alter table pre_common_word_type convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
194. alter table pre_connect_disktask convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
195. alter table pre_connect_feedlog convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
196. alter table pre_connect_memberbindlog convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
197. alter table pre_connect_postfeedlog convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
198. alter table pre_connect_tlog convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
199. 
     
200. alter table pre_connect_tthreadlog convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
201. alter table pre_forum_access convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
202. alter table pre_forum_activity convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
203. alter table pre_forum_activityapply convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
204. alter table pre_forum_announcement convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
205. alter table pre_forum_attachment convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
206. alter table pre_forum_attachment_0 convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
207. alter table pre_forum_attachment_1 convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
208. alter table pre_forum_attachment_2 convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
209. alter table pre_forum_attachment_3 convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
210. 
     
211. alter table pre_forum_attachment_4 convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
212. alter table pre_forum_attachment_5 convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
213. alter table pre_forum_attachment_6 convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
214. alter table pre_forum_attachment_7 convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
215. alter table pre_forum_attachment_8 convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
216. alter table pre_forum_attachment_9 convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
217. alter table pre_forum_attachment_exif convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
218. alter table pre_forum_attachment_unused convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
219. alter table pre_forum_attachtype convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
220. alter table pre_forum_baidu_user convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
221. alter table pre_forum_bbcode convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
222. alter table pre_forum_collection convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
223. 
     
224. alter table pre_forum_collectioncomment convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
225. alter table pre_forum_collectionfollow convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
226. alter table pre_forum_collectioninvite convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
227. alter table pre_forum_collectionrelated convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
228. alter table pre_forum_collectionteamworker convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
229. alter table pre_forum_collectionthread convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
230. alter table pre_forum_creditslog convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
231. alter table pre_forum_debate convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
232. alter table pre_forum_debatepost convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
233. alter table pre_forum_faq convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
234. alter table pre_forum_filter_post convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
235. alter table pre_forum_forum convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
236. alter table pre_forum_forum_threadtable convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
237. 
     
238. alter table pre_forum_forumfield convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
239. alter table pre_forum_forumrecommend convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
240. alter table pre_forum_groupcreditslog convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
241. alter table pre_forum_groupfield convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
242. alter table pre_forum_groupinvite convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
243. alter table pre_forum_grouplevel convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
244. alter table pre_forum_groupranking convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
245. alter table pre_forum_groupuser convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
246. alter table pre_forum_hotreply_member convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
247. alter table pre_forum_hotreply_number convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
248. alter table pre_forum_imagetype convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
249. alter table pre_forum_medal convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
250. 
     
251. alter table pre_forum_medallog convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
252. alter table pre_forum_memberrecommend convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
253. alter table pre_forum_moderator convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
254. alter table pre_forum_modwork convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
255. alter table pre_forum_newthread convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
256. alter table pre_forum_onlinelist convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
257. alter table pre_forum_order convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
258. alter table pre_forum_poll convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
259. alter table pre_forum_polloption convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
260. alter table pre_forum_polloption_image convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
261. alter table pre_forum_pollvoter convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
262. alter table pre_forum_post convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
263. 
     
264. alter table pre_forum_post_location convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
265. alter table pre_forum_post_moderate convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
266. alter table pre_forum_post_tableid convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
267. alter table pre_forum_postcache convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
268. alter table pre_forum_postcomment convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
269. alter table pre_forum_postlog convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
270. alter table pre_forum_postposition convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
271. alter table pre_forum_poststick convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
272. alter table pre_forum_promotion convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
273. alter table pre_forum_ratelog convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
274. 
     
275. alter table pre_forum_relatedthread convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
276. alter table pre_forum_replycredit convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
277. alter table pre_forum_rsscache convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
278. alter table pre_forum_sofa convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
279. alter table pre_forum_spacecache convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
280. alter table pre_forum_statlog convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
281. alter table pre_forum_thread convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
282. alter table pre_forum_thread_moderate convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
283. 
     
284. 
     
285. alter table pre_forum_threadaddviews convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
286. alter table pre_forum_threadcalendar convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
287. alter table pre_forum_threadclass convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
288. alter table pre_forum_threadclosed convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
289. alter table pre_forum_threaddisablepos convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
290. alter table pre_forum_threadhidelog convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
291. alter table pre_forum_threadhot convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
292. alter table pre_forum_threadimage convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
293. 
     
294. alter table pre_forum_threadlog convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
295. alter table pre_forum_threadmod convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
296. alter table pre_forum_threadpartake convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
297. alter table pre_forum_threadpreview convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
298. alter table pre_forum_threadprofile convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
299. alter table pre_forum_threadprofile_group convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
300. alter table pre_forum_threadrush convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
301. alter table pre_forum_threadtype convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
302. alter table pre_forum_trade convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
303. alter table pre_forum_tradecomment convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
304. 
     
305. alter table pre_forum_tradelog convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
306. alter table pre_forum_typeoption convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
307. alter table pre_forum_typeoptionvar convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
308. alter table pre_forum_typevar convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
309. alter table pre_forum_warning convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
310. alter table pre_home_album convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
311. alter table pre_home_album_category convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
312. alter table pre_home_appcreditlog convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
313. alter table pre_home_blacklist convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
314. 
     
315. alter table pre_home_blog convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
316. alter table pre_home_blog_category convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
317. alter table pre_home_blog_moderate convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
318. alter table pre_home_blogfield convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
319. alter table pre_home_class convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
320. alter table pre_home_click convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
321. alter table pre_home_clickuser convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
322. alter table pre_home_comment convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
323. 
     
324. alter table pre_home_comment_moderate convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
325. alter table pre_home_docomment convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
326. alter table pre_home_doing convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
327. alter table pre_home_doing_moderate convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
328. alter table pre_home_favorite convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
329. alter table pre_home_feed convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
330. alter table pre_home_feed_app convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
331. alter table pre_home_follow convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
332. alter table pre_home_follow_feed convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
333. 
     
334. alter table pre_home_follow_feed_archiver convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
335. alter table pre_home_friend convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
336. alter table pre_home_friend_request convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
337. 
     
338. alter table pre_home_friendlog convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
339. alter table pre_home_notification convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
340. 
     
341. alter table pre_home_pic convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
342. alter table pre_home_pic_moderate convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
343. alter table pre_home_picfield convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
344. alter table pre_home_poke convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
345. 
     
346. alter table pre_home_pokearchive convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
347. alter table pre_home_share convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
348. alter table pre_home_share_moderate convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
349. alter table pre_home_show convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
350. alter table pre_home_specialuser convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
351. alter table pre_home_userapp convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
352. alter table pre_home_userappfield convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
353. alter table pre_home_visitor convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
354. alter table pre_mobile_setting convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
355. 
     
356. alter table pre_mobile_wechat_authcode convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
357. alter table pre_mobile_wechat_masssend convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
358. alter table pre_mobile_wechat_resource convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
359. alter table pre_mobile_wsq_threadlist convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
360. alter table pre_mobileoem_member convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
361. alter table pre_mobileoem_pushthreads convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
362. alter table pre_portal_article_content convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
363. alter table pre_portal_article_count convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
364. alter table pre_portal_article_moderate convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
365. alter table pre_portal_article_related convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
366. 
     
367. alter table pre_portal_article_title convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
368. alter table pre_portal_article_trash convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
369. alter table pre_portal_attachment convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
370. alter table pre_portal_category convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
371. alter table pre_portal_category_permission convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
372. alter table pre_portal_comment convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
373. alter table pre_portal_comment_moderate convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
374. alter table pre_portal_rsscache convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
375. alter table pre_portal_topic convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
376. 
     
377. alter table pre_portal_topic_pic convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
378. alter table pre_security_evilpost convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
379. alter table pre_security_eviluser convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
     
380. alter table pre_security_failedlog convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

复制代码

2.修改以下文件中的utf8,改为utf8mb4.
config/config_global.php
config/config_ucenter.php
uc_server/data/config.inc.php

3.成功

yynq

wuyou

用表情符当用户名，很有个性！



可以用很酷的用户名

熄灭的火焰

MYSQL都8了？我还活在5的时代。。

wuyou

熄灭的火焰 发表于 2018-5-28 11:06
MYSQL都8了？我还活在5的时代。。

是啊，mysql 8 正式版已出，没有出6和7,从5直接到8.

熄灭的火焰

对了emoji表情怎么发，👍                                󾮗        👍

wuyou

熄灭的火焰 发表于 2018-5-28 11:19
对了emoji表情怎么发，&#x1F44D        &#xE727        &#xE4F9        &#xE00E        &#xFEB97        👍

现在论坛还没有正式升级程序，显示不了。
我是在虚拟机上测试的。

熄灭的火焰

wuyou 发表于 2018-5-28 11:20
现在论坛还没有正式升级程序，显示不了。
我是在虚拟机上测试的。

哦哦，恭喜试验成功

holley2008

邪恶海盗 发表于 2018-5-26 22:42
个人认为没必要,反正流量又不高,没什么硬性需求...

我也觉得主要是安全问题，现在都还经常有小广告刷进来，偶尔有莫名的好友出现。

wuyou

熄灭的火焰 发表于 2018-5-28 11:28
哦哦，恭喜试验成功

现在要做的事，就是先把一切影响导入的隐患先消除掉，简化今后论坛正式升级的手续，减少停机的时间。

wuyou

目前还是存在数据导入不完整，有显示重复，解决中。

wuyou

转载：Discuz X前台删除了DIY模块，后台“模块管理”中却删不掉怎么办？解决

今天重做首页，先统一在前台将所有“原来的DIY模块"删除，然后新建，但是做完后去后台一看，靠，很多删掉了的“原来的DIY模块"在“后台-门户-模块管理”中还存在着，只是“所在页面”一栏被标示为“未填写”了，而且还没有可以删除的按钮。这个怎么回事以及怎么办啊。



哈，今天官方刚好有张帖子说这事，原文如下：

今天看见很多人说自己明明已在前台删除了某个DIY模块，它在后台“门户-模块管理”中却仍然存在，被标示为“未填写”，且无法被删除，无聊就去试了一下，用多种顺序试过。
结果发现原因简单得要死。。。。。。
这个仅仅是因为删除模块的时候，不是“先删模块再删嵌套该模块的框架”，而是“直接删除嵌套该模块的框架”。直接删除嵌套该模块的框架，模块在前台是没有了，但后台并没有接到删除该模块的指令。
“模块”的菜单是蓝色，“框架”的菜单是红色的，先删蓝色再删红色，保证没有任何问题。
想偷懒将“模块”与“框架”同时删除，那是要付出代价的。
任何时候偷懒都要付出更大的代价。

如果已经出现问题了，那么......
1、去数据库的pre_common_block表里删除“门户-模块管理”中多余的模块。
2、去数据库的pre_common_diy_data表里删除“门户-页面管理”中多余的页面。

1. truncate table pre_common_diy_data;

复制代码

wuyou

发现 InnoDB 导入数据的速度好慢好慢，可能只有 MyISAM 的十分之一。

wuyou

这几天一直没转顺利，很大原因在于不知道mysql 校对集对大小写敏感差异。

以下是转载网上的

utf8_bin跟utf8_general_ci的区别

ci是 case insensitive, 即 "大小写不敏感", a 和 A 会在字符判断中会被当做一样的;

bin 是二进制, a 和 A 会区别对待.

例如你运行:

SELECT * FROM table WHERE txt = 'a'

那么在utf8_bin中你就找不到 txt = 'A' 的那一行, 而 utf8_general_ci 则可以.

wuyou

对现有的库或表转换字符集
如库名bbs，表名 table1

1. ALTER DATABASE bbs CHARACTER SET utf8mb4 COLLATE utf8mb4_bin; 
   
2. ALTER TABLE table1 CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin; 

复制代码

liaofabiao

测试转换utf8mb4数据库会出错吗？我上面人很多 ！哪种方法比较完美呢 各给建议  现数据库UTF8 停机时间长就麻烦！

wuyou

liaofabiao 发表于 2018-7-1 22:47
测试转换utf8mb4数据库会出错吗？我上面人很多 ！哪种方法比较完美呢 各给建议  现数据库UTF8 停机时间长就 ...

最好先在本地虚拟机环境（一般人比较难做到这一点）下先进行数据转换，没有问题以后，再导数据到实机上。