Discuz提示Table ‘common_session‘ doesn‘t exist错误的解决方法

ゞ浴缸里的玫瑰 2021-09-03 07:55 237阅读 0赞

参考解决方案：[https://freexyz.cn/cms/a09e6eac9ae2ea54dd6426d79d1b2c91.html][https_freexyz.cn_cms_a09e6eac9ae2ea54dd6426d79d1b2c91.html]

如果你的是mysql5.7，请新创建表即可【注意：后面是ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW\_FORMAT=DYNAMIC;】

-- ----------------------------
    -- Table structure for pre_common_session
    -- ----------------------------
    DROP TABLE IF EXISTS pre_common_session;
    CREATE TABLE pre_common_session (
      sid char(6) NOT NULL DEFAULT '',
      ip1 tinyint(3) unsigned NOT NULL DEFAULT '0',
      ip2 tinyint(3) unsigned NOT NULL DEFAULT '0',
      ip3 tinyint(3) unsigned NOT NULL DEFAULT '0',
      ip4 tinyint(3) unsigned NOT NULL DEFAULT '0',
      uid mediumint(8) unsigned NOT NULL DEFAULT '0',
      username char(15) NOT NULL DEFAULT '',
      groupid smallint(6) unsigned NOT NULL DEFAULT '0',
      invisible tinyint(1) NOT NULL DEFAULT '0',
      `action` tinyint(1) unsigned NOT NULL DEFAULT '0',
      lastactivity int(10) unsigned NOT NULL DEFAULT '0',
      lastolupdate int(10) unsigned NOT NULL DEFAULT '0',
      fid mediumint(8) unsigned NOT NULL DEFAULT '0',
      tid mediumint(8) unsigned NOT NULL DEFAULT '0',
      UNIQUE KEY sid (sid),
      KEY uid (uid)
    ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

[https_freexyz.cn_cms_a09e6eac9ae2ea54dd6426d79d1b2c91.html]: https://freexyz.cn/cms/a09e6eac9ae2ea54dd6426d79d1b2c91.html