mysql table error mysql table error
 

News:

CPG Release 1.6.27
change DB IP storage fields to accommodate IPv6 addresses
remove use of E_STRICT (PHP 8.4 deprecated)
update README to reflect new website
align code with new .com CPG website
correct deprecation in captcha

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