Print

[reyn]

I get this error message from phpMyAdmin on my remote host when trying to import the locally exported phpMyAdmin file.
Anyone have any idea what to do now? please.

Code: [Select]

Error

SQL-query :

CREATE TABLE `cpg140_albums` (
`aid` int( 11 ) NOT NULL AUTO_INCREMENT ,
`title` varchar( 255 ) NOT NULL default '',
`description` text NOT NULL ,
`visibility` int( 11 ) NOT NULL default '0',
`uploads` enum( 'YES', 'NO' ) NOT NULL default 'NO',
`comments` enum( 'YES', 'NO' ) NOT NULL default 'YES',
`votes` enum( 'YES', 'NO' ) NOT NULL default 'YES',
`pos` int( 11 ) NOT NULL default '0',
`category` int( 11 ) NOT NULL default '0',
`thumb` int( 11 ) NOT NULL default '0',
`keyword` varchar( 50 ) default NULL ,
`alb_password` varchar( 32 ) default NULL ,
`alb_password_hint` text,
PRIMARY KEY ( `aid` ) ,
KEY `alb_category` ( `category` )
)ENGINE = MYISAM DEFAULT CHARSET = latin1

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 'DEFAULT CHARSET=latin1' at line 17
Frank

[Nibbler]

You made the export using a higher version of mysql than you are attempting to import into. Remove the bit it complains about and you'll be fine.

This is in no way a bug with Coppermine, so marking as invalid.