discuz! X5.0 的数据库导入问题

iwuyou

查看Discuz! X5.0原升级代码

1. ALTER TABLE pre_common_member_profile_archive
   
2. ADD COLUMN fields json NOT NULL AFTER `field8`;

复制代码

应该改为

1. ALTER TABLE pre_common_member_profile_archive
   
2. ADD COLUMN fields json NOT NULL DEFAULT '{}' AFTER `field8`;

复制代码

以下表原升级代码都应做上述修改
pre_common_member_profile_archive
pre_common_member_profile_history
pre_common_usergroup_field
pre_forum_forumfield
pre_home_docomment
pre_home_doing