mant43 Posted April 18, 2011 Share Posted April 18, 2011 ok let me start off with im an absolute noob at creating websites etc. i have a problem i created a joomla website on localhost and now i want to export it onto my service providers "myphpadmin" to import the database from the localhost. once i do that as soon as i click import and GO it gives me this error below. there version of mysql is 5.051 AND my version is 5.5.9 so im not sure if i did something wrong or is it there side? Error SQL query: -- -------------------------------------------------------- -- -- Table structure for table `jos_usergroups` -- CREATE TABLE IF NOT EXISTS `jos_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 = InnoDB DEFAULT CHARSET = utf8 AUTO_INCREMENT =13; 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=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=13' at line 11 Link to comment https://forums.phpfreaks.com/topic/234048-confusion/ Share on other sites More sharing options...
kickstart Posted April 18, 2011 Share Posted April 18, 2011 Hi Issue is the "USING BTREE" when using that on a mysql 5.0 database. Remove that (think it is the default for innodb anyway) and it will likely be fine. All the best Keith Link to comment https://forums.phpfreaks.com/topic/234048-confusion/#findComment-1202930 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.