联系官方销售客服
1835022288
028-61286886
安装问题,环境为nginx1.18 php8.2 mysql5.6
安装过程中遇到报错,如下所示,请求处理方法
正在执行安装程序
SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes (SQL: CREATE TABLE IF NOT EXISTS `dr_admin_menu` ( `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `pid` smallint(5) unsigned NOT NULL COMMENT '上级菜单id', `name` text NOT NULL COMMENT '菜单语言名称', `site` text NOT NULL COMMENT '站点归属', `uri` varchar(255) DEFAULT NULL COMMENT 'uri字符串', `url` varchar(255) DEFAULT NULL COMMENT '外链地址', `mark` varchar(255) DEFAULT NULL COMMENT '菜单标识', `hidden` tinyint(1) unsigned DEFAULT NULL COMMENT '是否隐藏', `icon` varchar(255) DEFAULT NULL COMMENT '图标标示', `displayorder` int(5) DEFAULT NULL COMMENT '排序值', PRIMARY KEY (`id`), KEY `list` (`pid`), KEY `displayorder` (`displayorder`), KEY `mark` (`mark`), KEY `hidden` (`hidden`), KEY `uri` (`uri`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT='后台菜单表')
出现故障:SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes (SQL: CREATE TABLE IF NOT EXISTS `dr_admin_menu` ( `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `pid` smallint(5) unsigned NOT NULL COMMENT '上级菜单id', `name` text NOT NULL COMMENT '菜单语言名称', `site` text NOT NULL COMMENT '站点归属', `uri` varchar(255) DEFAULT NULL COMMENT 'uri字符串', `url` varchar(255) DEFAULT NULL COMMENT '外链地址', `mark` varchar(255) DEFAULT NULL COMMENT '菜单标识', `hidden` tinyint(1) unsigned DEFAULT NULL COMMENT '是否隐藏', `icon` varchar(255) DEFAULT NULL COMMENT '图标标示', `displayorder` int(5) DEFAULT NULL COMMENT '排序值', PRIMARY KEY (`id`), KEY `list` (`pid`), KEY `displayorder` (`displayorder`), KEY `mark` (`mark`), KEY `hidden` (`hidden`), KEY `uri` (`uri`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT='后台菜单表')