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: Database error ?  (Read 2292 times)

0 Members and 1 Guest are viewing this topic.

matija

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 20
Database error ?
« on: December 04, 2005, 06:48:40 pm »

Error at the line 38: ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=29 ;

Query: 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, `alb_password` varchar(32) default '', `alb_password_hint` text, PRIMARY KEY (`aid`), KEY `alb_category` (`category`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=29 ;

MySQL: Something is wrong in your syntax obok 'DEFAULT CHARSET=latin1 AUTO_INCREMENT=29' w linii 20

Stopped on error
---------------------------------------------------------------------
I get the following message when trying to upload the file into phpMyadmin with bigdump. File can't be uploaded either directly in pma. I backed up tables with phpmyadmin on other server and this error occurs, is there any way to fix or make it work?
Logged

Nibbler

  • Guest
Re: Database error ?
« Reply #1 on: December 04, 2005, 08:26:45 pm »

Export the db using the mysql 4 compatibility option in phpmyadmin.
Logged
Pages: [1]   Go Up
 

Page created in 0.016 seconds with 19 queries.