Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: Sql error - moving from local to remote.  (Read 3270 times)

0 Members and 1 Guest are viewing this topic.

reyn

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 26
Sql error - moving from local to remote.
« 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
« Last Edit: July 30, 2005, 05:41:52 pm by Nibbler »
Logged

Nibbler

  • Guest
Re: Sql error - moving from local to remote.
« Reply #1 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.
Logged
Pages: [1]   Go Up
 

Page created in 0.013 seconds with 18 queries.