Get a mysql error! ??? help!

[germanbjc]

Hey!
When i wanna install it an click "let's go" the following error is showing...

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'

WTH is that? :-\\
btw i did that thing with 777 everywhere...
thx for helping!
germanbjc

[Nibbler]

It means you already installed coppermine. Either fix the version you already have or pick a different prefix.

[speedymx]

Im getting the same error and I dont know how to fix it or what does it mean to install under a different prefix?  I am using yahoo small business hosting if that helps.  Thanks for any help

[Joachim Müller]

see attached screenshot.

[speedymx]

I tried this prefix and it gave the same error.  Do I have to create this table in mysql manually?  Should I try another prefix?  I really dont know what im doing since this is my first time messing with databases.  I looked in mysql and I dont see any previous install of coppermine.  I really want the gallery please help!  lol

[speedymx]

actually it is a slightly different error...here it is:  The following errors were encountered and need to be corrected first:

mySQL Error: Access denied for user 'speedymx'@'localhost' to database 'mysql'on query ' CREATE TABLE cpg130_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'

[speedymx]

I got past this now...I had to create a new database because in Yahoo web hosting you cannot use the default 'mysql' database since it contains php admin files.  Now my next hang up...see install hang post

[Tranz]

I think that applies anywhere (not just Yahoo)... where you cannot use the 'mysql' database.

Oh, scratch that. I guess if they don't use phpmyadmin, that db isn't needed?