forum.coppermine-gallery.net

Dev Board => cpg1.4 Testing/Bugs => cpg1.4 Testing/Bugs: FIXED/CLOSED => Topic started by: reyn on July 30, 2005, 04:56:29 pm

Title: Sql error - moving from local to remote.
Post by: reyn on July 30, 2005, 04:56:29 pm
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
Title: Re: Sql error - moving from local to remote.
Post by: Nibbler on July 30, 2005, 05:37:09 pm
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.