Text only | Text with Images

coppermine-gallery.com/forum

Support => cpg1.3.x Support => Older/other versions => cpg1.3 Installation & Setup => Topic started by: beachtaco on September 21, 2005, 07:51:21 PM

Title: MySQL error message during initial install
Post by: beachtaco on September 21, 2005, 07:51:21 PM
I'm getting the following message after I click on the Let's Go button of the installation page.

mySQL Error: Table 'cpg134_albums' already existson query ' CREATE TABLE cpg134_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'

Any ideas?  I don't know much about msSQL.
Title: Re: MySQL error message during initial install
Post by: Nibbler on September 21, 2005, 07:53:51 PM
That means you have already installed coppermine into that database. Pick a different table prefix instead of cpg134_
Title: Re: MySQL error message during initial install
Post by: kegobeer on September 22, 2005, 01:04:52 AM
QuoteAny ideas?  I don't know much about msSQL.

This is MySQL, not msSQL.
Text only | Text with Images