错误
表'joomla_db.#__usergroups'不存在SQL = INSERT INTO #__usergroups
( id
, parent_id
, lft
, rgt
, title
)VALUES(1,0,1,18,'Public'),(2,1,8,15,'Registered'),(3, 2,9,14,'Author'),(4,3,10,13,'Editor'),(5,4,11,12,'Publisher'),(6,1,4,7,'Manager'),(7,6, 5,6,'Administrator'),(8,1,16,17,'Super Users'),(9,1,2,3,'Guest')
您的SQL语法有错误;检查对应于你的MySQL服务器版本在第11 SQL附近'USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 DEFAULT COLLATE=utf8_unicode_ci'使用正确的语法手册= CREATE TABLE IF NOT EXISTS #__usergroups
( id
INT(10)无符号NOT NULL AUTO_INCREMENT COMMENT 'Primary Key', parent_id
INT(10)无符号NOT NULL DEFAULT 0 COMMENT 'Adjacency List Reference Id', lft
INT(11)NOT NULL DEFAULT 0 COMMENT 'Nested set lft.', rgt
INT(11)NOT NULL DEFAULT 0 COMMENT 'Nested set rgt.', title
VARCHAR(100)NOT NULL DEFAULT '',PRIMARY KEY( id
),UNIQUE KEY idx_usergroup_parent_title_lookup
( parent_id
, title
),KEY idx_usergroup_title_lookup
( title
),KEY idx_usergroup_adjacency_lookup
( parent_id
),KEY idx_usergroup_nested_set_lookup
( lft
, rgt
)USING BTREE)ENGINE = InnoDB的默认字符集= UTF8 DEFAULT COLLATE = utf8_unicode_ci
1 回答
这个错误主要是因为旧版本的MySQL只是升级MySQL版本而问题解决了
作为解决方法替换(
lft
,rgt
)使用BTREE和USING BTREE(lft
,rgt
) .但你应该升级MySQL!