去评论
dz插件网

飞鸟同城相亲运营版报错提示(1146) Table 'fn_member' doesn't exist解决办法

admin
2021/09/13 10:39:03
飞鸟同城相亲运营版报错提示(1146) Table 'fn_member' doesn't exist解决办法：

如图所示：



解决办法：
后台——站长——数据库——升级：
如果没有看到输入框，需要将 config/config_global.php 当中的 $_config[admincp][runquery] 设置修改为 1。

  1. CREATE TABLE `pre_fn_member` (
  2.   `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  3.   `mid` int(11) unsigned NOT NULL,
  4.   `uid` int(11) unsigned NOT NULL,
  5.   `username` varchar(100) NOT NULL,
  6.   `face` varchar(255) NOT NULL,
  7.   `name` varchar(50) NOT NULL,
  8.   `name_type` tinyint(1) unsigned NOT NULL DEFAULT '1',
  9.   `mobile` varchar(30) NOT NULL,
  10.   `sex` tinyint(1) unsigned NOT NULL,
  11.   `birth` varchar(20) NOT NULL,
  12.   `birth_province` varchar(30) NOT NULL,
  13.   `birth_city` varchar(30) NOT NULL,
  14.   `birth_dist` varchar(30) NOT NULL,
  15.   `birth_community` varchar(30) NOT NULL,
  16.   `reside_province` varchar(30) NOT NULL,
  17.   `reside_city` varchar(30) NOT NULL,
  18.   `reside_dist` varchar(30) NOT NULL,
  19.   `reside_community` varchar(30) NOT NULL,
  20.   `age` tinyint(3) unsigned NOT NULL,
  21.   `constellation` tinyint(1) unsigned NOT NULL,
  22.   `animal` tinyint(1) unsigned NOT NULL,
  23.   `height` tinyint(3) unsigned NOT NULL,
  24.   `weight` tinyint(3) unsigned NOT NULL,
  25.   `blood` tinyint(1) unsigned NOT NULL,
  26.   `ethnic` tinyint(1) unsigned NOT NULL,
  27.   `company` varchar(255) NOT NULL,
  28.   `occupation` tinyint(3) unsigned NOT NULL,
  29.   `education` tinyint(1) unsigned NOT NULL,
  30.   `marriage` tinyint(1) unsigned NOT NULL,
  31.   `home` tinyint(1) unsigned NOT NULL,
  32.   `child` tinyint(1) unsigned NOT NULL,
  33.   `month_income` tinyint(1) unsigned NOT NULL,
  34.   `house` tinyint(1) unsigned NOT NULL,
  35.   `vehicle` tinyint(1) unsigned NOT NULL,
  36.   `hobby` varchar(255) NOT NULL,
  37.   `vip_time` int(11) unsigned NOT NULL,
  38.   `expire_vip_push` tinyint(1) unsigned NOT NULL,
  39.   `param` mediumtext NOT NULL,
  40.   `lead_line` tinyint(4) unsigned NOT NULL,
  41.   `lead_line_state` tinyint(1) unsigned NOT NULL,
  42.   `see_line` tinyint(3) unsigned NOT NULL,
  43.   `click` int(11) unsigned NOT NULL,
  44.   `display` tinyint(1) unsigned NOT NULL,
  45.   `examine` tinyint(1) unsigned NOT NULL,
  46.   `mobile_display` tinyint(1) unsigned NOT NULL DEFAULT '1',
  47.   `wx_display` tinyint(1) unsigned NOT NULL,
  48.   `seal` tinyint(1) unsigned NOT NULL,
  49.   `top_dateline` int(11) unsigned NOT NULL,
  50.   `display_dateline` int(11) unsigned NOT NULL,
  51.   `dateline` int(11) unsigned NOT NULL,
  52.   `updateline` int(11) unsigned NOT NULL,
  53.   `source` tinyint(1) unsigned NOT NULL,
  54.   PRIMARY KEY (`id`)
  55. ) ENGINE=MyISAM;


进入原文参与互动