Hi Im Very New To Coppermine
& when I went To install It The first Time everything went Fine I went install it On another Site & I Get
This Error
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''
Can Someone please Help me?
Thanks for your time!
Bhester
error message is clear, coppermine tables already exists in your database.
if you want to install an other coppermine gallery on the same database that the other, you must change the table prefix during the install process
I have the same problem, but i don't have another coopermine gallery on my sistem.
don't hijack this thread, you problem seems to be the same but it's not sure.
give us more details. What did you do before the error message ?
I uploaded the files to my website (www.jkrfan.com) and then i CHMOD'd it to 777. Then I went to the install page and put in all of the information and i got this message:
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''
what's the link to your gallery ?
Look into your database an see if coppermine table exists. If yes, it means that you have already install coppermine on your site
The link to my gallery is :
http://jkrfan.com/coppermine/install.php
I looked on my ftp and the only coppermine i found was the one that i just put on there. I didn't see any tables but i'm not really too sure what to be looking for.
Coppermine gallery is already installed on your site, which is why you are getting the errors.
Go to this URL http://jkrfan.com/coppermine/ and login with details you provided on your install.
Also a good idea to then go and delete the install directory
Quote from: smilergb on August 21, 2008, 03:46:37 AM
Also a good idea to then go and delete the install directory
Forget that bit, i thinking of another script.
Thanks so much!
You get that sort of error message if you run the installer twice.