刚才发一份代码的时候,提示Database Query Error
通过在config.inc.php添加:

/** 开启Debug模式 */
define("__TYPECHO_DEBUG__",true); 

打开调试模式,发现是由于utf8,而不是utf8mb4,导致无法添加代码中的emoji表情。

直接数据库执行:

alter table typecho_comments convert to character set utf8mb4 collate utf8mb4_unicode_ci;
alter table typecho_contents convert to character set utf8mb4 collate utf8mb4_unicode_ci;
alter table typecho_fields convert to character set utf8mb4 collate utf8mb4_unicode_ci;
alter table typecho_metas convert to character set utf8mb4 collate utf8mb4_unicode_ci;
alter table typecho_options convert to character set utf8mb4 collate utf8mb4_unicode_ci;
alter table typecho_relationships convert to character set utf8mb4 collate utf8mb4_unicode_ci;
alter table typecho_users convert to character set utf8mb4 collate utf8mb4_unicode_ci;

然后config.inc.php里面更改连接字符集:

'charset' => 'utf8mb4',

就好了。

标签: none

添加新评论