mysql table error mysql table error
 

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]

Main Menu

mysql table error

Started by Understudy, March 08, 2006, 02:59:58 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Understudy

I am trying to get install.php to finish. I currently get this error:
Welcome to Coppermine installation
• • • ERROR • • •
The following errors were encountered and need to be corrected first:

mySQL Error: Table 'cpg143_albums' already exists on query ' CREATE TABLE cpg143_albums ( aid int(11) NOT NULL auto_increment, title varchar(255) NOT NULL default '', description text NOT NULL default '', 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 ), alb_password VARCHAR( 32 ), alb_password_hint TEXT, PRIMARY KEY (aid), KEY alb_category (category) ) TYPE=MyISAM'


I have to admit I am at a loss of what to do. I have root access to this server so if changes need to be made to mysql I can make them.

Sincerely,
Brendhan

Nibbler

Pick a different prefix during installation. A Coppermine gallery already exists in the database with the prefix you have selected.

Understudy

Are there any requirements for the prefix or can I use "pics_" ?
Sincerely,
Brendhan

Nibbler

You can use pics_, any simple name is fine.

Understudy

Okay Idid that all looks good here. Thank You.

Sincerely,
Brendhan