mysql table error mysql table error
 

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

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