MySQL error message during initial install MySQL error message during initial install
 

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 error message during initial install

Started by beachtaco, September 21, 2005, 07:51:21 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

beachtaco

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.

Nibbler

That means you have already installed coppermine into that database. Pick a different table prefix instead of cpg134_

kegobeer

QuoteAny ideas?  I don't know much about msSQL.

This is MySQL, not msSQL.
Do not send me a private message unless I ask for one.  Make your post public so everyone can benefit.

There are no stupid questions
But there are a LOT of inquisitive idiots