Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: Get a mysql error! ??? help!  (Read 5328 times)

0 Members and 1 Guest are viewing this topic.

germanbjc

  • Coppermine newbie
  • Offline Offline
  • Gender: Female
  • Posts: 3
    • From Behind.de
Get a mysql error! ??? help!
« 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
Logged

Nibbler

  • Guest
Re: Get a mysql error! ??? help!
« Reply #1 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.
Logged

speedymx

  • Coppermine newbie
  • Offline Offline
  • Posts: 6
Re: Get a mysql error! ??? help!
« Reply #2 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
« Last Edit: November 05, 2005, 09:07:01 am by speedymx »
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Get a mysql error! ??? help!
« Reply #3 on: November 05, 2005, 09:22:56 am »

see attached screenshot.
Logged

speedymx

  • Coppermine newbie
  • Offline Offline
  • Posts: 6
Re: Get a mysql error! ??? help!
« Reply #4 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
Logged

speedymx

  • Coppermine newbie
  • Offline Offline
  • Posts: 6
Re: Get a mysql error! ??? help!
« Reply #5 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'

Logged

speedymx

  • Coppermine newbie
  • Offline Offline
  • Posts: 6
Re: Get a mysql error! ??? help!
« Reply #6 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
Logged

Tranz

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Female
  • Posts: 6149
Re: Get a mysql error! ??? help!
« Reply #7 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?
Logged
Pages: [1]   Go Up
 

Page created in 0.022 seconds with 15 queries.