huge mysql error- help with figuring it out? huge mysql error- help with figuring it out?
 

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

huge mysql error- help with figuring it out?

Started by D-C, July 18, 2005, 11:42:21 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

D-C

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?

Nibbler

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.

D-C

I already completely deleted the prior install.  The reason I included that info is to explain that it worked once- as opposed to never.

kegobeer

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.
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

D-C

changing the prefix worked, sorry about any confusion. thanks!  Now for the bridgibg problems :)

D-C

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 :)