#1064 - You have an error in your SQL syntax; check the manual that corresponds to yo

Databases
1

Hi

Can someone please help Im a Joomla developer have not much experience with databases. I have imported my database into the “new server” phpmyAdmin but it missed 5 tables…See the following error. <snip /> Im trying to upload it. Can someone please please tell me how I can fix this. Its mainly the users? This is Joomla 1.7. I will gladly give any more details :sick:

Error

SQL query:

CREATE TABLE IF NOT EXISTS ckv7y_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 =11;

MySQL said: Documentation
#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=11’ at line 11

2

Hi thanks

A bit over my head - have asked a developer to look at it

Thanks x

3

the syntax for specifying a particular index type is not the way you have tried it

remove “USING BTREE” unless you’re sure you need it (but then you’ll have to find the correct way to specify that syntax… hint: it’s in the mysql manual) and try the CREATE TABLE statement again without it