Print Page - mysql table error

Title: mysql table error
Post by: Understudy on March 08, 2006, 02:59:58 PM

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

Title: Re: mysql table error
Post by: Nibbler on March 08, 2006, 03:02:50 PM

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

Title: Re: mysql table error
Post by: Understudy on March 08, 2006, 03:14:48 PM

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

Title: Re: mysql table error
Post by: Nibbler on March 08, 2006, 03:20:02 PM

You can use pics_, any simple name is fine.

Title: Re: mysql table error
Post by: Understudy on March 10, 2006, 12:47:12 AM

Okay Idid that all looks good here. Thank You.

Sincerely,
Brendhan

coppermine-gallery.com/forum

Support => cpg1.4.x Support => Older/other versions => cpg1.4 install => Topic started by: Understudy on March 08, 2006, 02:59:58 PM