Error in mysql

[Mehidi]

Hello !
When i want to insert my table of coppermine on my new host i had this error :

CREATE TABLE `cpg133_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',
`pic_count` int( 11 ) NOT NULL default '0',
`thumb` int( 11 ) NOT NULL default '0',
`last_addition` datetime NOT NULL default '0000-00-00 00:00:00',
`stat_uptodate` enum( 'YES', 'NO' ) NOT NULL default 'NO',
`keyword` varchar( 50 ) default NULL ,
PRIMARY KEY ( `aid` ) ,
KEY `alb_category` ( `category` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =101

What does it mean ?
Thanks !

[Nibbler]

Remove this bit

Code Select Expand

DEFAULT CHARSET = latin1

Looks like you are moving from a higher version of mysql to a lower version, there is a compatibility option when exporting from phpmyadmin if that is what you used for the export.

[Mehidi]

I had put the file that you send to me but i have this error :
CREATE TABLE `cpg133_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',
`pic_count` int( 11 ) NOT NULL default '0',
`thumb` int( 11 ) NOT NULL default '0',
`last_addition` datetime NOT NULL default '0000-00-00 00:00:00',
`stat_uptodate` enum( 'YES', 'NO' ) NOT NULL default 'NO',
`keyword` varchar( 50 ) default NULL ,
PRIMARY KEY ( `aid` ) ,
KEY `alb_category` ( `category` )
) TYPE = MYISAM AUTO_INCREMENT =101

MySQL a répondu:

#1046 - No Database Selected

[Joachim Müller]

well, then select a database first 

[Mehidi]

Thanks for your answer !
It's Ok now

Have a nice day

[Mehidi]

No it's not Ok LOL
I had make an answer here in french
I you want i translate say it to me

http://forum.coppermine-gallery.net/index.php?topic=22701.msg104534#msg104534

[Joachim Müller]

issue solved then?