无忧启动论坛

 找回密码
 注册
搜索
系统gho:最纯净好用系统下载站Win To Go 极致利器(IXUNCIS固态U盘)广告联系 微信:wuyouceo QQ:184822951
查看: 14935|回复: 49

[分享] discuzX3.4数据库改用utf8mb4字符集,实现emoji表情符

    [复制链接]
发表于 2018-5-26 17:27:44 | 显示全部楼层 |阅读模式
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)

评分

参与人数 1无忧币 +5 收起 理由
我是来搞事的 + 5 拍马屁

查看全部评分

发表于 2018-5-26 18:54:23 | 显示全部楼层
帮顶,希望论坛里有熟悉数据库的大大帮早日解决。。。

点评

现在已经搞定程序,在测试机上可以发以前不能正常显示表情符了。  详情 回复 发表于 2018-5-26 19:25
回复

使用道具 举报

 楼主| 发表于 2018-5-26 19:25:58 | 显示全部楼层
pcfan120 发表于 2018-5-26 18:54
帮顶,希望论坛里有熟悉数据库的大大帮早日解决。。。

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

使用道具 举报

发表于 2018-5-26 22:08:43 | 显示全部楼层
打算把论坛升到DZX3.4???

点评

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

使用道具 举报

 楼主| 发表于 2018-5-26 22:17:16 | 显示全部楼层
邪恶海盗 发表于 2018-5-26 22:08
打算把论坛升到DZX3.4???

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

点评

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

使用道具 举报

发表于 2018-5-26 22:42:35 | 显示全部楼层
wuyou 发表于 2018-5-26 22:17
升级是肯定的,只是要做的准备工作很多很多。
最关键是服务器系统得重装。

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

点评

我也觉得主要是安全问题,现在都还经常有小广告刷进来,偶尔有莫名的好友出现。  详情 回复 发表于 2018-5-28 16:43
主要还是考虑安全问题,毕竟老系统问题多多。  详情 回复 发表于 2018-5-26 23:05
回复

使用道具 举报

 楼主| 发表于 2018-5-26 23:05:13 | 显示全部楼层
邪恶海盗 发表于 2018-5-26 22:42
个人认为没必要,反正流量又不高,没什么硬性需求...

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

点评

还有的还在用DZ5和7呢...  详情 回复 发表于 2018-5-26 23:09
回复

使用道具 举报

发表于 2018-5-26 23:09:27 | 显示全部楼层
wuyou 发表于 2018-5-26 23:05
主要还是考虑安全问题,毕竟老系统问题多多。

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

点评

低版本的系统,官方都不会提供补丁,就是一个不设防的系统,人家可以自由进出.  详情 回复 发表于 2018-5-27 06:18
回复

使用道具 举报

 楼主| 发表于 2018-5-27 06:18:28 | 显示全部楼层
邪恶海盗 发表于 2018-5-26 23:09
还有的还在用DZ5和7呢...

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

使用道具 举报

发表于 2018-5-27 07:21:32 | 显示全部楼层
版主辛苦了。。希望论坛越来越好。。
回复

使用道具 举报

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

点评

现在玩论坛的人也少了,很多论坛都关了,不象多年以前大家都有这个热情。  详情 回复 发表于 2018-5-27 20:58
回复

使用道具 举报

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

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

使用道具 举报

 楼主| 发表于 2018-5-27 22:12:01 | 显示全部楼层
测试一下 🐻
回复

使用道具 举报

 楼主| 发表于 2018-5-27 22:22:16 | 显示全部楼层
目前在虚拟机上,已成功升级本论坛程序到支持utf8mb4字符集的discuzX 3.4 20180101

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

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

  1. #!/bin/bash

  2. cd /home/bbs/others/
  3. sed -i '/DEFAULT CHARSET=utf8[^m]/s/DEFAULT CHARSET=utf8/&mb4 COLLATE=utf8mb4_general_ci/' bbs.sql
  4. sed -i 's/` char(255) /` char(230) /g' bbs.sql
  5. 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. alter table pre_common_admincp_perm modify perm varchar(230) NOT NULL;
  3. alter table pre_common_cache modify `cachekey` varchar(230) NOT NULL DEFAULT '' ;
  4. alter table pre_common_card modify `id` char(230) NOT NULL DEFAULT '';
  5. alter table pre_common_member_profile_setting modify `fieldid` varchar(230) NOT NULL DEFAULT '';
  6. alter table pre_common_member_security modify `fieldid` varchar(230) NOT NULL DEFAULT '';
  7. alter table pre_common_setting modify `skey` varchar(230) NOT NULL DEFAULT '';
  8. alter table pre_forum_groupfield modify `type` varchar(230) NOT NULL;
  9. alter table pre_home_favorite modify `idtype` varchar(230) NOT NULL DEFAULT '';
  10. alter table pre_mobile_setting modify `skey` varchar(230) NOT NULL DEFAULT '';
  11. alter table cdb_uc_badwords modify `find` varchar(230) NOT NULL DEFAULT '';
  12. alter table pre_common_addon modify `key` varchar(230) NOT NULL DEFAULT '';
  13. alter table pre_common_advertisement_custom modify `name` varchar(230) NOT NULL;
  14. alter table pre_portal_topic modify `name` varchar(230) NOT NULL DEFAULT '';

  15. ALTER DATABASE bbs CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

  16. alter table cdb_uc_admins convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  17. alter table cdb_uc_applications convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  18. alter table cdb_uc_badwords convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  19. alter table cdb_uc_domains convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  20. alter table cdb_uc_failedlogins convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

  21. alter table cdb_uc_feeds convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  22. alter table cdb_uc_friends convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  23. alter table cdb_uc_mailqueue convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  24. alter table cdb_uc_memberfields convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

  25. alter table cdb_uc_members convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  26. alter table cdb_uc_mergemembers convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  27. alter table cdb_uc_newpm convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  28. alter table cdb_uc_notelist convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  29. alter table cdb_uc_pm_indexes convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

  30. alter table cdb_uc_pm_lists convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  31. alter table cdb_uc_pm_members convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  32. alter table cdb_uc_pm_messages_0 convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  33. alter table cdb_uc_pm_messages_1 convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

  34. alter table cdb_uc_pm_messages_2 convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  35. alter table cdb_uc_pm_messages_3 convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  36. alter table cdb_uc_pm_messages_4 convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  37. alter table cdb_uc_pm_messages_5 convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  38. alter table cdb_uc_pm_messages_6 convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

  39. alter table cdb_uc_pm_messages_7 convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  40. alter table cdb_uc_pm_messages_8 convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  41. alter table cdb_uc_pm_messages_9 convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  42. alter table cdb_uc_pms convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  43. alter table cdb_uc_protectedmembers convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

  44. alter table cdb_uc_settings convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  45. alter table cdb_uc_sqlcache convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  46. alter table cdb_uc_tags convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  47. alter table cdb_uc_vars convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  48. alter table pre_common_addon convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  49. alter table pre_common_admincp_cmenu convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  50. alter table pre_common_admincp_group convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

  51. alter table pre_common_admincp_member convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  52. alter table pre_common_admincp_perm convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  53. alter table pre_common_admincp_session convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  54. alter table pre_common_admingroup convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  55. alter table pre_common_adminnote convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  56. alter table pre_common_advertisement convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  57. alter table pre_common_advertisement_custom convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

  58. alter table pre_common_banned convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  59. alter table pre_common_block convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  60. alter table pre_common_block_favorite convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  61. alter table pre_common_block_item convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  62. alter table pre_common_block_item_data convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

  63. alter table pre_common_block_permission convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  64. alter table pre_common_block_pic convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  65. alter table pre_common_block_style convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  66. alter table pre_common_block_xml convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  67. alter table pre_common_cache convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  68. alter table pre_common_card convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

  69. alter table pre_common_card_log convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  70. alter table pre_common_card_type convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  71. alter table pre_common_connect_guest convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  72. alter table pre_common_credit_log convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  73. alter table pre_common_credit_log_field convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  74. alter table pre_common_credit_rule convert to character set utf8mb4  COLLATE utf8mb4_general_ci;


  75. alter table pre_common_credit_rule_log convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  76. alter table pre_common_credit_rule_log_field convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  77. alter table pre_common_cron convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  78. alter table pre_common_devicetoken convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  79. alter table pre_common_district convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  80. alter table pre_common_diy_data convert to character set utf8mb4  COLLATE utf8mb4_general_ci;


  81. alter table pre_common_domain convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  82. alter table pre_common_failedip convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  83. alter table pre_common_failedlogin convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  84. alter table pre_common_friendlink convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  85. alter table pre_common_grouppm convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  86. alter table pre_common_invite convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

  87. alter table pre_common_magic convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  88. alter table pre_common_magiclog convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  89. alter table pre_common_mailcron convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  90. alter table pre_common_mailqueue convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  91. alter table pre_common_member convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  92. alter table pre_common_member_action_log convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

  93. alter table pre_common_member_archive convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  94. alter table pre_common_member_connect convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  95. alter table pre_common_member_count convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  96. alter table pre_common_member_count_archive convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  97. alter table pre_common_member_crime convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  98. alter table pre_common_member_field_forum convert to character set utf8mb4  COLLATE utf8mb4_general_ci;


  99. alter table pre_common_member_field_forum_archive convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  100. alter table pre_common_member_field_home convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  101. alter table pre_common_member_field_home_archive convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  102. alter table pre_common_member_forum_buylog convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  103. alter table pre_common_member_grouppm convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  104. alter table pre_common_member_log convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  105. alter table pre_common_member_magic convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

  106. alter table pre_common_member_medal convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  107. alter table pre_common_member_newprompt convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  108. alter table pre_common_member_profile convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  109. alter table pre_common_member_profile_archive convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  110. alter table pre_common_member_profile_setting convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  111. alter table pre_common_member_security convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  112. alter table pre_common_member_secwhite convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

  113. alter table pre_common_member_stat_field convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  114. alter table pre_common_member_stat_fieldcache convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  115. alter table pre_common_member_stat_search convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  116. alter table pre_common_member_stat_searchcache convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  117. alter table pre_common_member_status convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  118. alter table pre_common_member_status_archive convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  119. alter table pre_common_member_validate convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

  120. alter table pre_common_member_verify convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  121. alter table pre_common_member_verify_info convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  122. alter table pre_common_member_wechat convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  123. alter table pre_common_member_wechatmp convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  124. alter table pre_common_moderate convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  125. alter table pre_common_myapp convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

  126. alter table pre_common_myinvite convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  127. alter table pre_common_mytask convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  128. alter table pre_common_nav convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  129. alter table pre_common_onlinetime convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  130. alter table pre_common_optimizer convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  131. alter table pre_common_patch convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  132. alter table pre_common_plugin convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

  133. alter table pre_common_pluginvar convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  134. alter table pre_common_process convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  135. alter table pre_common_regip convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  136. alter table pre_common_relatedlink convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  137. alter table pre_common_remote_port convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  138. alter table pre_common_report convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  139. alter table pre_common_searchindex convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

  140. alter table pre_common_seccheck convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  141. alter table pre_common_secquestion convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  142. alter table pre_common_session convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  143. alter table pre_common_setting convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  144. alter table pre_common_smiley convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  145. alter table pre_common_sphinxcounter convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  146. alter table pre_common_stat convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

  147. alter table pre_common_statuser convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  148. alter table pre_common_style convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  149. alter table pre_common_stylevar convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  150. alter table pre_common_syscache convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  151. alter table pre_common_tag convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  152. alter table pre_common_tagitem convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  153. alter table pre_common_task convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

  154. alter table pre_common_taskvar convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  155. alter table pre_common_template convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  156. alter table pre_common_template_block convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  157. alter table pre_common_template_permission convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  158. alter table pre_common_uin_black convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  159. alter table pre_common_usergroup convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  160. alter table pre_common_usergroup_field convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  161. alter table pre_common_visit convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

  162. alter table pre_common_word convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  163. alter table pre_common_word_type convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  164. alter table pre_connect_disktask convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  165. alter table pre_connect_feedlog convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  166. alter table pre_connect_memberbindlog convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  167. alter table pre_connect_postfeedlog convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  168. alter table pre_connect_tlog convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

  169. alter table pre_connect_tthreadlog convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  170. alter table pre_forum_access convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  171. alter table pre_forum_activity convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  172. alter table pre_forum_activityapply convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  173. alter table pre_forum_announcement convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  174. alter table pre_forum_attachment convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  175. alter table pre_forum_attachment_0 convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  176. alter table pre_forum_attachment_1 convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  177. alter table pre_forum_attachment_2 convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  178. alter table pre_forum_attachment_3 convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

  179. alter table pre_forum_attachment_4 convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  180. alter table pre_forum_attachment_5 convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  181. alter table pre_forum_attachment_6 convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  182. alter table pre_forum_attachment_7 convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  183. alter table pre_forum_attachment_8 convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  184. alter table pre_forum_attachment_9 convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  185. alter table pre_forum_attachment_exif convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  186. alter table pre_forum_attachment_unused convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  187. alter table pre_forum_attachtype convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  188. alter table pre_forum_baidu_user convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  189. alter table pre_forum_bbcode convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  190. alter table pre_forum_collection convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

  191. alter table pre_forum_collectioncomment convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  192. alter table pre_forum_collectionfollow convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  193. alter table pre_forum_collectioninvite convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  194. alter table pre_forum_collectionrelated convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  195. alter table pre_forum_collectionteamworker convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  196. alter table pre_forum_collectionthread convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  197. alter table pre_forum_creditslog convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  198. alter table pre_forum_debate convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  199. alter table pre_forum_debatepost convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  200. alter table pre_forum_faq convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  201. alter table pre_forum_filter_post convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  202. alter table pre_forum_forum convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  203. alter table pre_forum_forum_threadtable convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

  204. alter table pre_forum_forumfield convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  205. alter table pre_forum_forumrecommend convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  206. alter table pre_forum_groupcreditslog convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  207. alter table pre_forum_groupfield convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  208. alter table pre_forum_groupinvite convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  209. alter table pre_forum_grouplevel convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  210. alter table pre_forum_groupranking convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  211. alter table pre_forum_groupuser convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  212. alter table pre_forum_hotreply_member convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  213. alter table pre_forum_hotreply_number convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  214. alter table pre_forum_imagetype convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  215. alter table pre_forum_medal convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

  216. alter table pre_forum_medallog convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  217. alter table pre_forum_memberrecommend convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  218. alter table pre_forum_moderator convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  219. alter table pre_forum_modwork convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  220. alter table pre_forum_newthread convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  221. alter table pre_forum_onlinelist convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  222. alter table pre_forum_order convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  223. alter table pre_forum_poll convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  224. alter table pre_forum_polloption convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  225. alter table pre_forum_polloption_image convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  226. alter table pre_forum_pollvoter convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  227. alter table pre_forum_post convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

  228. alter table pre_forum_post_location convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  229. alter table pre_forum_post_moderate convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  230. alter table pre_forum_post_tableid convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  231. alter table pre_forum_postcache convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  232. alter table pre_forum_postcomment convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  233. alter table pre_forum_postlog convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  234. alter table pre_forum_postposition convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  235. alter table pre_forum_poststick convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  236. alter table pre_forum_promotion convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  237. alter table pre_forum_ratelog convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

  238. alter table pre_forum_relatedthread convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  239. alter table pre_forum_replycredit convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  240. alter table pre_forum_rsscache convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  241. alter table pre_forum_sofa convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  242. alter table pre_forum_spacecache convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  243. alter table pre_forum_statlog convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  244. alter table pre_forum_thread convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  245. alter table pre_forum_thread_moderate convert to character set utf8mb4  COLLATE utf8mb4_general_ci;


  246. alter table pre_forum_threadaddviews convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  247. alter table pre_forum_threadcalendar convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  248. alter table pre_forum_threadclass convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  249. alter table pre_forum_threadclosed convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  250. alter table pre_forum_threaddisablepos convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  251. alter table pre_forum_threadhidelog convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  252. alter table pre_forum_threadhot convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  253. alter table pre_forum_threadimage convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

  254. alter table pre_forum_threadlog convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  255. alter table pre_forum_threadmod convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  256. alter table pre_forum_threadpartake convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  257. alter table pre_forum_threadpreview convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  258. alter table pre_forum_threadprofile convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  259. alter table pre_forum_threadprofile_group convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  260. alter table pre_forum_threadrush convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  261. alter table pre_forum_threadtype convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  262. alter table pre_forum_trade convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  263. alter table pre_forum_tradecomment convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

  264. alter table pre_forum_tradelog convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  265. alter table pre_forum_typeoption convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  266. alter table pre_forum_typeoptionvar convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  267. alter table pre_forum_typevar convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  268. alter table pre_forum_warning convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  269. alter table pre_home_album convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  270. alter table pre_home_album_category convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  271. alter table pre_home_appcreditlog convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  272. alter table pre_home_blacklist convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

  273. alter table pre_home_blog convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  274. alter table pre_home_blog_category convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  275. alter table pre_home_blog_moderate convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  276. alter table pre_home_blogfield convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  277. alter table pre_home_class convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  278. alter table pre_home_click convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  279. alter table pre_home_clickuser convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  280. alter table pre_home_comment convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

  281. alter table pre_home_comment_moderate convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  282. alter table pre_home_docomment convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  283. alter table pre_home_doing convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  284. alter table pre_home_doing_moderate convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  285. alter table pre_home_favorite convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  286. alter table pre_home_feed convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  287. alter table pre_home_feed_app convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  288. alter table pre_home_follow convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  289. alter table pre_home_follow_feed convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

  290. alter table pre_home_follow_feed_archiver convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  291. alter table pre_home_friend convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  292. alter table pre_home_friend_request convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

  293. alter table pre_home_friendlog convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  294. alter table pre_home_notification convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

  295. alter table pre_home_pic convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  296. alter table pre_home_pic_moderate convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  297. alter table pre_home_picfield convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  298. alter table pre_home_poke convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

  299. alter table pre_home_pokearchive convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  300. alter table pre_home_share convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  301. alter table pre_home_share_moderate convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  302. alter table pre_home_show convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  303. alter table pre_home_specialuser convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  304. alter table pre_home_userapp convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  305. alter table pre_home_userappfield convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  306. alter table pre_home_visitor convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  307. alter table pre_mobile_setting convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

  308. alter table pre_mobile_wechat_authcode convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  309. alter table pre_mobile_wechat_masssend convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  310. alter table pre_mobile_wechat_resource convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  311. alter table pre_mobile_wsq_threadlist convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  312. alter table pre_mobileoem_member convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  313. alter table pre_mobileoem_pushthreads convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  314. alter table pre_portal_article_content convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  315. alter table pre_portal_article_count convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  316. alter table pre_portal_article_moderate convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  317. alter table pre_portal_article_related convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

  318. alter table pre_portal_article_title convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  319. alter table pre_portal_article_trash convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  320. alter table pre_portal_attachment convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  321. alter table pre_portal_category convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  322. alter table pre_portal_category_permission convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  323. alter table pre_portal_comment convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  324. alter table pre_portal_comment_moderate convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  325. alter table pre_portal_rsscache convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  326. alter table pre_portal_topic convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

  327. alter table pre_portal_topic_pic convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  328. alter table pre_security_evilpost convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  329. alter table pre_security_eviluser convert to character set utf8mb4  COLLATE utf8mb4_general_ci;
  330. 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.成功
回复

使用道具 举报

发表于 2018-5-28 09:21:59 | 显示全部楼层
回复

使用道具 举报

 楼主| 发表于 2018-5-28 09:44:57 | 显示全部楼层
0.jpeg

用表情符当用户名,很有个性!

0.jpeg

可以用很酷的用户名
回复

使用道具 举报

发表于 2018-5-28 11:06:12 | 显示全部楼层
MYSQL都8了?我还活在5的时代。。

点评

是啊,mysql 8 正式版已出,没有出6和7,从5直接到8.  详情 回复 发表于 2018-5-28 11:16
回复

使用道具 举报

 楼主| 发表于 2018-5-28 11:16:08 | 显示全部楼层
熄灭的火焰 发表于 2018-5-28 11:06
MYSQL都8了?我还活在5的时代。。

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

使用道具 举报

发表于 2018-5-28 11:19:16 | 显示全部楼层
本帖最后由 熄灭的火焰 于 2018-5-28 11:20 编辑

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

点评

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

使用道具 举报

 楼主| 发表于 2018-5-28 11:20:42 | 显示全部楼层
熄灭的火焰 发表于 2018-5-28 11:19
对了emoji表情怎么发,&#x1F44D        &#xE727        &#xE4F9        &#xE00E        &#xFEB97        👍

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

点评

哦哦,恭喜试验成功  详情 回复 发表于 2018-5-28 11:28
回复

使用道具 举报

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

哦哦,恭喜试验成功

点评

现在要做的事,就是先把一切影响导入的隐患先消除掉,简化今后论坛正式升级的手续,减少停机的时间。  详情 回复 发表于 2018-5-28 20:00
回复

使用道具 举报

发表于 2018-5-28 16:43:50 | 显示全部楼层
邪恶海盗 发表于 2018-5-26 22:42
个人认为没必要,反正流量又不高,没什么硬性需求...

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

使用道具 举报

 楼主| 发表于 2018-5-28 20:00:38 | 显示全部楼层
熄灭的火焰 发表于 2018-5-28 11:28
哦哦,恭喜试验成功

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

使用道具 举报

 楼主| 发表于 2018-5-29 19:14:30 | 显示全部楼层
目前还是存在数据导入不完整,有显示重复,解决中。
回复

使用道具 举报

 楼主| 发表于 2018-5-31 07:05:38 | 显示全部楼层
转载:Discuz X前台删除了DIY模块,后台“模块管理”中却删不掉怎么办?解决

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



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

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

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

使用道具 举报

 楼主| 发表于 2018-6-1 00:37:55 | 显示全部楼层
发现 InnoDB 导入数据的速度好慢好慢,可能只有 MyISAM 的十分之一。
回复

使用道具 举报

 楼主| 发表于 2018-6-1 10:55:36 | 显示全部楼层
这几天一直没转顺利,很大原因在于不知道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 则可以.
回复

使用道具 举报

 楼主| 发表于 2018-6-1 15:44:37 | 显示全部楼层
对现有的库或表转换字符集
如库名bbs,表名 table1

  1. ALTER DATABASE bbs CHARACTER SET utf8mb4 COLLATE utf8mb4_bin; 
  2. ALTER TABLE table1 CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin; 
复制代码
回复

使用道具 举报

发表于 2018-7-1 22:47:22 | 显示全部楼层
测试转换utf8mb4数据库会出错吗?我上面人很多 !哪种方法比较完美呢 各给建议  现数据库UTF8 停机时间长就麻烦!

点评

最好先在本地虚拟机环境(一般人比较难做到这一点)下先进行数据转换,没有问题以后,再导数据到实机上。  详情 回复 发表于 2018-8-16 10:53
回复

使用道具 举报

 楼主| 发表于 2018-8-16 10:53:51 | 显示全部楼层
liaofabiao 发表于 2018-7-1 22:47
测试转换utf8mb4数据库会出错吗?我上面人很多 !哪种方法比较完美呢 各给建议  现数据库UTF8 停机时间长就 ...

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

使用道具 举报

您需要登录后才可以回帖 登录 | 注册

本版积分规则

小黑屋|手机版|Archiver|捐助支持|无忧启动 ( 闽ICP备05002490号-1 )

闽公网安备 35020302032614号

GMT+8, 2022-8-19 14:08

Powered by Discuz! X3.3

© 2001-2017 Comsenz Inc.

快速回复 返回顶部 返回列表