โดย chartzaa » 29/07/2012 5:49 pm
พี่ๆ ช่วยหน่อยครับ พึ่งทำครั้งเเรกเลย ไม่รู้จะเเก้ยังไงครับ
Error
SQL query:
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `wpn_usergroups`
--
CREATE TABLE IF NOT EXISTS `wpn_usergroups` (
`id` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'Primary Key',
`parent_id` INT( 10 ) UNSIGNED 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 = MYISAM DEFAULT CHARSET = utf8 AUTO_INCREMENT =9;
MySQL said:
#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 'USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=9' at line 17
พี่ๆ ช่วยหน่อยครับ พึ่งทำครั้งเเรกเลย ไม่รู้จะเเก้ยังไงครับ
[color=#BF0000]Error
SQL query:
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `wpn_usergroups`
--
CREATE TABLE IF NOT EXISTS `wpn_usergroups` (
`id` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'Primary Key',
`parent_id` INT( 10 ) UNSIGNED 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 = MYISAM DEFAULT CHARSET = utf8 AUTO_INCREMENT =9;
MySQL said:
#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 'USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=9' at line 17[/color]