Print Page - Error in mysql

Title: Error in mysql
Post by: Mehidi on October 13, 2005, 08:55:27 PM

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 !

Title: Re: Error in mysql
Post by: Nibbler on October 13, 2005, 09:13:16 PM

Remove this bit

Code Select

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.

Title: Re: Error in mysql
Post by: Mehidi on October 14, 2005, 08:05:35 AM

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

Title: Re: Error in mysql
Post by: Joachim Müller on October 14, 2005, 08:15:10 AM

well, then select a database first ;)

Title: Re: Error in mysql
Post by: Mehidi on October 14, 2005, 08:28:13 AM

Thanks for your answer !
It's Ok now :)

Have a nice day

Title: Re: Error in mysql
Post by: Mehidi on October 14, 2005, 12:36:40 PM

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

Title: Re: Error in mysql
Post by: Joachim Müller on October 14, 2005, 01:52:32 PM

issue solved then?

coppermine-gallery.com/forum

Support => Older/other versions => cpg1.3.x Support => Topic started by: Mehidi on October 13, 2005, 08:55:27 PM