连接数据库报错

kevinxu07

报错类型

连接数据库安装报错

报错内容：

Something went wrong: SQLSTATE[42S01]: Base table or view already exists: 1050 Table ‘flags’ already exists (SQL: create table flags (id int unsigned not null auto_increment primary key, post_id int unsigned not null, type varchar(255) not null, user_id int unsigned null, reason varchar(255) null, reason_detail varchar(255) null, time datetime not null) default character set utf8mb4 collate ‘utf8mb4_unicode_ci’)

是不是要空的数据库才能安装？我换了vps，不想丢数据，把原来的数据导入了新的数据库，编码也是utf8mb4

zhetengtiao

是的，如果你想导入旧数据，那么请执行：

清空数据库，进行全新安装（设置务必与旧站点保持一致
再次清空数据库，然后把你的旧数据导入到数据库
清空flarum缓存，访问站点查看是否有效
或者，直接复制旧站点的config.php到新站点的目录，然后导入数据

kevinxu07

Something went wrong: SQLSTATE[HY000]: General error: 1030 Got error 168 from storage engine (SQL: CREATE TABLE access_tokens ( id int(10) unsigned NOT NULL AUTO_INCREMENT, token varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL, user_id int(10) unsigned NOT NULL, last_activity_at datetime NOT NULL, created_at datetime NOT NULL, type varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, title varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL, last_ip_address varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL, last_user_agent varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (id), UNIQUE KEY access_tokens_token_unique (token), KEY access_tokens_user_id_foreign (user_id), KEY access_tokens_type_index (type), CONSTRAINT access_tokens_user_id_foreign FOREIGN KEY (user_id) REFERENCES users (id) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci)
又出新错误了🙁这次清空了