ANGIE – Akeeba Next Generation Installer Engine v.4.0.5 还原
恢复数据库时发生了错误。下面显示了出错提示。点击本窗口右上角的 × 按钮来关闭它,返回数据库恢复页面。处理第 7 行时发生了数据库错误
数据库服务器错误回复:ErrNo #0
SQL=CREATE TABLE `zfree_assets` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key', `parent_id` int(11) NOT NULL DEFAULT '0' COMMENT 'Nested set parent.', `lft` int(11) NOT NULL DEFAULT '0' COMMENT 'Nested set lft.', `rgt` int(11) NOT NULL DEFAULT '0' COMMENT 'Nested set rgt.', `level` int(10) unsigned NOT NULL COMMENT 'The cached level in the nested tree.', `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'The unique name for the asset.\n', `title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'The descriptive title for the asset.', `rules` varchar(5120) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'JSON encoded access control.', PRIMARY KEY (`id`), UNIQUE KEY `idx_asset_name` (`name`), KEY `idx_lft_rgt` (`lft`,`rgt`), KEY `idx_parent_id` (`parent_id`) ) ENGINE=InnoDB AUTO_INCREMENT=415 DEFAULT CHARSET=utf8原始查询文本:CREATE TABLE `#__assets` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key', `parent_id` int(11) NOT NULL DEFAULT '0' COMMENT 'Nested set parent.', `lft` int(11) NOT NULL DEFAULT '0' COMMENT 'Nested set lft.', `rgt` int(11) NOT NULL DEFAULT '0' COMMENT 'Nested set rgt.', `level` int(10) unsigned NOT NULL COMMENT 'The cached level in the nested tree.', `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'The unique name for the asset.\n', `title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'The descriptive title for the asset.', `rules` varchar(5120) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'JSON encoded access control.', PRIMARY KEY (`id`), UNIQUE KEY `idx_asset_name` (`name`), KEY `idx_lft_rgt` (`lft`,`rgt`), KEY `idx_parent_id` (`parent_id`) ) ENGINE=InnoDB AUTO_INCREMENT=415 DEFAULT CHARSET=utf8
没有找到相关结果
已邀请:
6 个回复
admin - Joomla发烧友,灌篮高手粉丝
赞同来自: jsgd
解决的方案找到安装使用的sql文件。在B计划的安装包中是 install/sql.下面有site.s01,site.s02,site.sql这3个文件
执行下面的替换操作
查找:utf8mb4_unicode_ci,全部替换为:utf8_general_ci
查找:utf8mb4 全部替换为 utf8
按照顺序完成上面的操作。保存。
然后重新安装即可。
Martin鱼儿 - 学习奋斗
赞同来自: jsgd
admin - Joomla发烧友,灌篮高手粉丝
赞同来自: jsgd
jsgd
赞同来自:
jsgd
赞同来自:
jsgd
赞同来自: