coppermine-gallery.com/forum

Support => cpg1.3.x Support => Older/other versions => cpg1.3 Installation & Setup => Topic started by: D-C on July 18, 2005, 11:42:21 PM

Title: huge mysql error- help with figuring it out?
Post by: D-C on July 18, 2005, 11:42:21 PM
ok, after running the install.php, here's the error I get:

• • • ERROR • • •
The following errors were encountered and need to be corrected first:

mySQL Error: Table 'cpg133_albums' already existson query ' CREATE TABLE cpg133_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?
Title: Re: huge mysql error- help with figuring it out?
Post by: Nibbler on July 18, 2005, 11:49:09 PM
You already installed coppermine before using the prefix cpg133_, so you should either recover that one or install a new version by specifying a different prefix.
Title: Re: huge mysql error- help with figuring it out?
Post by: D-C on July 19, 2005, 12:19:13 AM
I already completely deleted the prior install.  The reason I included that info is to explain that it worked once- as opposed to never.
Title: Re: huge mysql error- help with figuring it out?
Post by: kegobeer on July 19, 2005, 12:22:37 AM
Quote from: D-C on July 19, 2005, 12:19:13 AM
I already completely deleted the prior install.  The reason I included that info is to explain that it worked once- as opposed to never.

You lost me there, D-C.  If you try to install Coppermine and you receive those error messages, that means you have a MySQL database with Coppermine tables in it.  The installer can't create a table called cpg133_albums if one already exists.  You have to delete your Coppermine tables before running the installer.
Title: Re: huge mysql error- help with figuring it out?
Post by: D-C on July 19, 2005, 12:24:36 AM
changing the prefix worked, sorry about any confusion. thanks!  Now for the bridgibg problems :)
Title: Re: huge mysql error- help with figuring it out?
Post by: D-C on July 19, 2005, 12:25:48 AM
Quote from: D-C on July 19, 2005, 12:24:36 AM
changing the prefix worked, sorry about any confusion. thanks!  Now for the bridging problems :)