无忧启动论坛

标题: discuzX3.4数据库改用utf8mb4字符集，实现emoji表情符 [打印本页]
作者: wuyou    时间: 2018-5-26 17:27
标题: discuzX3.4数据库改用utf8mb4字符集，实现emoji表情符
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, 下载次数: 105)

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

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;

  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可以看下一页，一直没用过这个标签，第一次用。


如果ENGINE使用InnoDB，则修改
ENGINE=MyISAM 全部替换为 ENGINE=InnoDB

并将所有有auto_increment 属性的，加为KEY。
如 id 有auto_increment属性，则在相应段加上一行 KEY  `id`  (`id`),  (如果已有完全相同这一行就不要加）

以下是这次解决问题过程，没兴趣的可不看：

1.常规安装，然后导出数据库，修改默认字符集

sed -i '/DEFAULT CHARSET=utf8[^m]/s/DEFAULT CHARSET=utf8/&mb4/' bbs.sql

2.使用ENGINE=MyISAM ，如果直接导入bbs.sql，会出错，提示如下：

ERROR 1071 (42000) at line 104: Specified key was too long; max key length is 1000 bytes
ERROR 1146 (42S02) at line 115: Table 'bbs.pre_common_admincp_perm' doesn't exist
ERROR 1146 (42S02) at line 116: Table 'bbs.pre_common_admincp_perm' doesn't exist
ERROR 1146 (42S02) at line 117: Table 'bbs.pre_common_admincp_perm' doesn't exist
ERROR 1146 (42S02) at line 118: Table 'bbs.pre_common_admincp_perm' doesn't exist
ERROR 1071 (42000) at line 631: Specified key was too long; max key length is 1000 bytes
ERROR 1146 (42S02) at line 643: Table 'bbs.pre_common_cache' doesn't exist
ERROR 1146 (42S02) at line 644: Table 'bbs.pre_common_cache' doesn't exist
ERROR 1146 (42S02) at line 645: Table 'bbs.pre_common_cache' doesn't exist
ERROR 1071 (42000) at line 655: Specified key was too long; max key length is 1000 bytes
ERROR 1146 (42S02) at line 677: Table 'bbs.pre_common_card' doesn't exist
ERROR 1146 (42S02) at line 678: Table 'bbs.pre_common_card' doesn't exist
ERROR 1146 (42S02) at line 679: Table 'bbs.pre_common_card' doesn't exist
ERROR 1071 (42000) at line 1831: Specified key was too long; max key length is 1000 bytes
ERROR 1146 (42S02) at line 1857: Table 'bbs.pre_common_member_profile_setting' doesn't exist
ERROR 1146 (42S02) at line 1858: Table 'bbs.pre_common_member_profile_setting' doesn't exist
ERROR 1146 (42S02) at line 1859: Table 'bbs.pre_common_member_profile_setting' doesn't exist
ERROR 1146 (42S02) at line 1860: Table 'bbs.pre_common_member_profile_setting' doesn't exist
ERROR 1071 (42000) at line 1870: Specified key was too long; max key length is 1000 bytes
ERROR 1146 (42S02) at line 1888: Table 'bbs.pre_common_member_security' doesn't exist
ERROR 1146 (42S02) at line 1889: Table 'bbs.pre_common_member_security' doesn't exist
ERROR 1146 (42S02) at line 1890: Table 'bbs.pre_common_member_security' doesn't exist
ERROR 1071 (42000) at line 2673: Specified key was too long; max key length is 1000 bytes
ERROR 1146 (42S02) at line 2684: Table 'bbs.pre_common_setting' doesn't exist
ERROR 1146 (42S02) at line 2685: Table 'bbs.pre_common_setting' doesn't exist
ERROR 1146 (42S02) at line 2686: Table 'bbs.pre_common_setting' doesn't exist
ERROR 1146 (42S02) at line 2687: Table 'bbs.pre_common_setting' doesn't exist
ERROR 1071 (42000) at line 4800: Specified key was too long; max key length is 1000 bytes
ERROR 1146 (42S02) at line 4816: Table 'bbs.pre_forum_groupfield' doesn't exist
ERROR 1146 (42S02) at line 4817: Table 'bbs.pre_forum_groupfield' doesn't exist
ERROR 1146 (42S02) at line 4818: Table 'bbs.pre_forum_groupfield' doesn't exist
ERROR 1071 (42000) at line 7101: Specified key was too long; max key length is 1000 bytes
ERROR 1146 (42S02) at line 7120: Table 'bbs.pre_home_favorite' doesn't exist
ERROR 1146 (42S02) at line 7121: Table 'bbs.pre_home_favorite' doesn't exist
ERROR 1146 (42S02) at line 7122: Table 'bbs.pre_home_favorite' doesn't exist
ERROR 1071 (42000) at line 7797: Specified key was too long; max key length is 1000 bytes
ERROR 1146 (42S02) at line 7808: Table 'bbs.pre_mobile_setting' doesn't exist
ERROR 1146 (42S02) at line 7809: Table 'bbs.pre_mobile_setting' doesn't exist
ERROR 1146 (42S02) at line 7810: Table 'bbs.pre_mobile_setting' doesn't exist
ERROR 1146 (42S02) at line 7811: Table 'bbs.pre_mobile_setting' doesn't exist
ERROR 1071 (42000) at line 8567: Specified key was too long; max key length is 1000 bytes
ERROR 1146 (42S02) at line 8582: Table 'bbs.pre_ucenter_badwords' doesn't exist
ERROR 1146 (42S02) at line 8583: Table 'bbs.pre_ucenter_badwords' doesn't exist
ERROR 1146 (42S02) at line 8584: Table 'bbs.pre_ucenter_badwords' doesn't exist

处理方法1：
-----------------
根据 ERROR 1071 (42000) at line 104: Specified key was too long; max key length is 1000 bytes 提示，查找 bbs.sql 文件相应行104行及后续10行：

sed -n '104,114p' bbs.sql


CREATE TABLE `pre_common_admincp_perm` (
  `cpgroupid` smallint(6) unsigned NOT NULL,
  `perm` varchar(255) NOT NULL,
  UNIQUE KEY `cpgroupperm` (`cpgroupid`,`perm`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pre_common_admincp_perm`
--

可以看出 UNIQUE KEY `cpgroupperm` (`cpgroupid`,`perm`) 定义的长度 是 (6+255) * 4 > 1000 , 只要把`perm` varchar 值改小，使其总和不要超过1000即可。
现在改为 230.

sed -i '106s/255/230/' bbs.sql


其他类似提示的行做同样的修改，成功导入数据库。

处理方法2：
-----------------
根据上面提示中出现的所有表，对安装文件先做处理

pre_ucenter_badwords 表：对应查 uc_badwords  ，从 uc_server/install/uc.sql  修改
其他表在 install/data/install.sql 修改

官方原始文件 config 下的所有.php文件中的 utf8 都改为 utf8mb4
注意 utf-8 不要改动。

改好以下文件
install/data/install.sql
uc_server/install/uc.sql

修改 install/include/install_var.php

define('DBCHARSET', 'utf8');     改为    define('DBCHARSET', 'utf8mb4');

再进行安装。


现在发帖，就可以正常使用表情符了,用户名都可以用表情符注册！

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

现在已经搞定程序，在测试机上可以发以前不能正常显示表情符了。
作者: 邪恶海盗    时间: 2018-5-26 22:08
打算把论坛升到DZX3.4???
作者: wuyou    时间: 2018-5-26 22:17
邪恶海盗 发表于 2018-5-26 22:08
打算把论坛升到DZX3.4???

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

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

主要还是考虑安全问题，毕竟老系统问题多多。
作者: 邪恶海盗    时间: 2018-5-26 23:09
wuyou 发表于 2018-5-26 23:05
主要还是考虑安全问题，毕竟老系统问题多多。

还有的还在用DZ5和7呢...
作者: wuyou    时间: 2018-5-27 06:18
邪恶海盗 发表于 2018-5-26 23:09
还有的还在用DZ5和7呢...

低版本的系统，官方都不会提供补丁，就是一个不设防的系统，人家可以自由进出.
作者: pcfan120    时间: 2018-5-27 07:21
版主辛苦了。。希望论坛越来越好。。
作者: 起舞    时间: 2018-5-27 20:29
在非DZ官方论坛能看到谈论论坛安装升级的帖子好惊讶。不禁想起多年前和朋友一起往论坛安装各种插件的往事。
作者: wuyou    时间: 2018-5-27 20:58
起舞 发表于 2018-5-27 20:29
在非DZ官方论坛能看到谈论论坛安装升级的帖子好惊讶。不禁想起多年前和朋友一起往论坛安装各种插件的往事。

现在玩论坛的人也少了，很多论坛都关了，不象多年以前大家都有这个热情。
作者: wuyou    时间: 2018-5-27 22:12
测试一下 🐻
作者: wuyou    时间: 2018-5-27 22:22
目前在虚拟机上，已成功升级本论坛程序到支持utf8mb4字符集的discuzX 3.4 20180101

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

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

  1. #!/bin/bash

  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;

  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 '';

  17. ALTER DATABASE bbs CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

  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;

  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;

  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;

  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;

  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;

  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;

  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;

  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;

  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;

  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;

  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;


  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;


  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;

  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;

  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;


  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;

  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;

  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;

  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;

  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;

  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;

  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;

  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;

  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;

  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;

  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;

  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;

  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;

  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;

  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;

  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;

  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;


  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;

  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;

  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;

  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;

  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;

  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;

  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;

  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;

  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;

  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;

  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;

  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    时间: 2018-5-28 09:21
作者: wuyou    时间: 2018-5-28 09:44


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



可以用很酷的用户名
作者: 熄灭的火焰    时间: 2018-5-28 11:06
MYSQL都8了？我还活在5的时代。。
作者: wuyou    时间: 2018-5-28 11:16
熄灭的火焰 发表于 2018-5-28 11:06
MYSQL都8了？我还活在5的时代。。

是啊，mysql 8 正式版已出，没有出6和7,从5直接到8.
作者: 熄灭的火焰    时间: 2018-5-28 11:19
本帖最后由 熄灭的火焰 于 2018-5-28 11:20 编辑

对了emoji表情怎么发，👍                                󾮗        👍
作者: wuyou    时间: 2018-5-28 11:20
熄灭的火焰 发表于 2018-5-28 11:19
对了emoji表情怎么发，&#x1F44D        &#xE727        &#xE4F9        &#xE00E        &#xFEB97        👍

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

哦哦，恭喜试验成功
作者: holley2008    时间: 2018-5-28 16:43
邪恶海盗 发表于 2018-5-26 22:42
个人认为没必要,反正流量又不高,没什么硬性需求...

我也觉得主要是安全问题，现在都还经常有小广告刷进来，偶尔有莫名的好友出现。
作者: wuyou    时间: 2018-5-28 20:00
熄灭的火焰 发表于 2018-5-28 11:28
哦哦，恭喜试验成功

现在要做的事，就是先把一切影响导入的隐患先消除掉，简化今后论坛正式升级的手续，减少停机的时间。
作者: wuyou    时间: 2018-5-29 19:14
目前还是存在数据导入不完整，有显示重复，解决中。
作者: wuyou    时间: 2018-5-31 07:05
转载：Discuz X前台删除了DIY模块，后台“模块管理”中却删不掉怎么办？解决

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



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

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

如果已经出现问题了，那么......
1、去数据库的pre_common_block表里删除“门户-模块管理”中多余的模块。
2、去数据库的pre_common_diy_data表里删除“门户-页面管理”中多余的页面。
  1. truncate table pre_common_diy_data;
复制代码
作者: wuyou    时间: 2018-6-1 00:37
发现 InnoDB 导入数据的速度好慢好慢，可能只有 MyISAM 的十分之一。
作者: wuyou    时间: 2018-6-1 10:55
这几天一直没转顺利，很大原因在于不知道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    时间: 2018-6-1 15:44
对现有的库或表转换字符集
如库名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    时间: 2018-7-1 22:47
测试转换utf8mb4数据库会出错吗？我上面人很多 ！哪种方法比较完美呢 各给建议  现数据库UTF8 停机时间长就麻烦！
作者: wuyou    时间: 2018-8-16 10:53
liaofabiao 发表于 2018-7-1 22:47
测试转换utf8mb4数据库会出错吗？我上面人很多 ！哪种方法比较完美呢 各给建议  现数据库UTF8 停机时间长就 ...

最好先在本地虚拟机环境（一般人比较难做到这一点）下先进行数据转换，没有问题以后，再导数据到实机上。
作者: osp@qq.com    时间: 2018-10-30 17:11
zhichi@@@@@@@@@@@
作者: osp@qq.com    时间: 2018-10-30 17:11
ding@################
作者: wangyu1314    时间: 2018-10-30 17:29
大佬牛逼，我们也为改utf8mb4这个事伤透脑筋。
作者: qxhdly    时间: 2018-10-30 17:48
版主辛苦了。
作者: wangyu1314    时间: 2018-12-2 22:39
我的VBB也改了这个的。。
作者: hygx.org    时间: 2019-8-10 11:49
听说修改完可以完美支持偏僻汉字，特来测试：𣹳  𡖊  
作者: blankplay    时间: 2019-10-15 21:20
钉钉
作者: 51xixi    时间: 2019-12-2 11:10
感谢楼主，已经完美支持emoji表情符
作者: ully    时间: 2019-12-16 22:46
VIP会员 大元帅
作者: nenge    时间: 2020-1-7 19:17
我也去试试
作者: 小小华    时间: 2020-2-20 00:46
无忧启动
作者: lonhowe    时间: 2020-6-30 18:33
版主辛苦了。。希望论坛越来越好。。
作者: ydyd883    时间: 2020-7-16 16:12
大佬，全新安装的patch文件现在有版本更新吗，因为我看到你后面的帖子说转换过程有问题的说
作者: tans123    时间: 2020-7-17 12:55
感谢分享
作者: henimabiA1    时间: 2020-8-4 16:12
怎么下载？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？
作者: wuyovooo    时间: 2020-8-6 18:34
进来学习一下
作者: ninglie    时间: 2020-9-25 19:59
辛苦了
作者: kevinqin    时间: 2020-9-29 10:30
新安装最新版本， 怎么  
作者: ninglie    时间: 2020-11-24 03:16
没有问题
作者: abcuiopa    时间: 2021-4-19 21:47
看看
作者: 骑猪看月出    时间: 2022-11-23 12:49
辛苦了。。希望论坛越来越好
作者: 骑猪看月出    时间: 2022-11-23 12:49
下载不了的
作者: henimabiA1    时间: 2023-6-3 21:20
直说多少钱能下载附件，能下得起我就给你转钱



欢迎光临 无忧启动论坛 (http://bbs.wuyou.net/) Powered by Discuz! X3.3