安装webman-admin时数据库报错

wenjian337 更新于10天前

问题描述

安装 webman/admin时数据库报错

这里详细描述问题

报错信息

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'UNIQUE KEY `name` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8m' at line 8

截图报错信息里报错文件相关代码

操作系统及workerman/webman等框架组件具体版本

windows 10
php:8.4.6
mysql:8.0.41
"require": {
"php": ">=8.1",
"workerman/webman-framework": "^2.1",
"monolog/monolog": "^2.0",
"webman/admin": "^2.1"
},

 113  1 0

1个回答

wenjian337 10天前

CREATE TABLE IF NOT EXISTS wa_options (
id int(10) unsigned NOT NULL AUTO_INCREMENT,
name varchar(255) NOT NULL COMMENT '键',
value longtext NOT NULL COMMENT '值',
created_at datetime NOT NULL DEFAULT '2022-08-15 00:00:00' COMMENT '创建时间',
updated_at datetime NOT NULL DEFAULT '2022-08-15 00:00:00' COMMENT '更新时间',
PRIMARY KEY (id),[<-此处的逗号确实，导致的sql语句执行失败]
UNIQUE KEY name (name)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='选项表';