coppermine-gallery.com/forum

Support => cpg1.3.x Support => Older/other versions => cpg1.3 Installation & Setup => Topic started by: germanbjc on November 01, 2005, 11:44:36 PM

Title: Get a mysql error! ??? help!
Post by: germanbjc on November 01, 2005, 11:44:36 PM
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
Title: Re: Get a mysql error! ??? help!
Post by: Nibbler on November 01, 2005, 11:48:25 PM
It means you already installed coppermine. Either fix the version you already have or pick a different prefix.
Title: Re: Get a mysql error! ??? help!
Post by: speedymx on November 05, 2005, 09:00:09 AM
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
Title: Re: Get a mysql error! ??? help!
Post by: Joachim Müller on November 05, 2005, 09:22:56 AM
see attached screenshot.
Title: Re: Get a mysql error! ??? help!
Post by: speedymx on November 06, 2005, 03:57:33 AM
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
Title: Re: Get a mysql error! ??? help!
Post by: speedymx on November 06, 2005, 04:36:48 AM
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'

Title: Re: Get a mysql error! ??? help!
Post by: speedymx on November 06, 2005, 05:38:21 AM
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
Title: Re: Get a mysql error! ??? help!
Post by: Tranz on November 06, 2005, 12:00:34 PM
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?