coppermine-gallery.com/forum

Support => cpg1.4.x Support => Older/other versions => cpg1.4 install => Topic started by: baldilocks on October 25, 2009, 12:07:30 AM

Title: Tried to re-install and got an error.
Post by: baldilocks on October 25, 2009, 12:07:30 AM
I have searched but no idea what to even look for. Here is the error I am getting:


mySQL Error: Table 'cpg14x_albums' already exists on query ' CREATE TABLE cpg14x_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', thumb int(11) NOT NULL default '0', keyword VARCHAR( 50 ), alb_password VARCHAR( 32 ), alb_password_hint TEXT, PRIMARY KEY (aid), KEY alb_category (category) ) TYPE=MyISAM COMMENT='Used to store albums''


I had installed it once and had problem with a bridge and it gave me fatal errors, so i deleted all the files, re-uploaded and tried to install again.

Any help would be appreciated.
Title: Re: Tried to re-install and got an error.
Post by: heavensportal on October 25, 2009, 01:46:38 AM
you may have deleted the fiels but by the looks of it you did not delete the tables in the database
Title: Re: Tried to re-install and got an error.
Post by: phill104 on October 25, 2009, 10:14:23 PM
As heavensportal suggests, you have not deleted the data in your MySql database. You will need to use a tool like phpmyadmin or whatever your host may provide to delete those tables before you can continue your install.

Instead of deleting when you have a problem you could have read the docs which tell you how to recover from a failed bridging. It would have save you a lot of time and effort. If you do not understand a section of the docs or having trouble then just ask but make sure you do everything required as per the board rules and the relavent section of the doce.