coppermine-gallery.com/forum

Support => cpg1.3.x Support => Older/other versions => cpg1.3 Installation & Setup => Topic started by: trackman on February 11, 2006, 11:17:44 PM

Title: Error
Post by: trackman on February 11, 2006, 11:17:44 PM
I'm getting the folloing error when setting up coppermine on my new server

mySQL Error: Table 'cpg135_albums' already existson query ' CREATE TABLE cpg135_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 ), PRIMARY KEY (aid), KEY alb_category (category) ) TYPE=MyISAM'

Please help  ???
Title: Re: Error
Post by: Nibbler on February 11, 2006, 11:18:55 PM
You already installed Coppermine into that database with that prefix. Change either one or the other.
Title: Re: Error
Post by: trackman on February 11, 2006, 11:20:16 PM
how do i change this  ???
Title: Re: Error
Post by: Nibbler on February 11, 2006, 11:21:59 PM
Type different information into the little boxes on the install page.
Title: Re: Error
Post by: trackman on February 11, 2006, 11:22:26 PM
sorted, changed the prefix to 143 instead of 135 thanks  ;D