5
This is what I get when I import the .sql file to the remote server.
I tried with auto-increment on and off and several other options.
Who can tell me what this means?
I tried to upload a single random table, but get the same message everytime...
Here we go:
SQL-query :
CREATE TABLE `xoops_avatar` (
`avatar_id` mediumint( 8 ) unsigned NOT NULL AUTO_INCREMENT ,
`avatar_file` varchar( 30 ) NOT NULL default '',
`avatar_name` varchar( 100 ) NOT NULL default '',
`avatar_mimetype` varchar( 30 ) NOT NULL default '',
`avatar_created` int( 10 ) NOT NULL default '0',
`avatar_display` tinyint( 1 ) unsigned NOT NULL default '0',
`avatar_weight` smallint( 5 ) unsigned NOT NULL default '0',
`avatar_type` char( 1 ) NOT NULL default '',
PRIMARY KEY ( `avatar_id` ) ,
KEY `avatar_type` ( `avatar_type` , `avatar_display` )
)ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =32
MySQL returned:
#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 'ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=32' at line
Thanks and greetings
Ronaldus
