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: mysql table error  (Read 3222 times)

0 Members and 1 Guest are viewing this topic.

Understudy

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Gender: Male
  • Posts: 51
    • Another boring website
mysql table error
« on: March 08, 2006, 02:59:58 pm »
I am trying to get install.php to finish. I currently get this error:
Welcome to Coppermine installation
• • • ERROR • • •
The following errors were encountered and need to be corrected first:

mySQL Error: Table 'cpg143_albums' already exists on query ' CREATE TABLE cpg143_albums ( aid int(11) NOT NULL auto_increment, title varchar(255) NOT NULL default '', description text NOT NULL default '', 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'


I have to admit I am at a loss of what to do. I have root access to this server so if changes need to be made to mysql I can make them.

Sincerely,
Brendhan
« Last Edit: March 10, 2006, 12:54:55 am by Nibbler »
Logged

Nibbler

  • Guest
Re: mysql table error
« Reply #1 on: March 08, 2006, 03:02:50 pm »
Pick a different prefix during installation. A Coppermine gallery already exists in the database with the prefix you have selected.
Logged

Understudy

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Gender: Male
  • Posts: 51
    • Another boring website
Re: mysql table error
« Reply #2 on: March 08, 2006, 03:14:48 pm »
Are there any requirements for the prefix or can I use "pics_" ?
Sincerely,
Brendhan
Logged

Nibbler

  • Guest
Re: mysql table error
« Reply #3 on: March 08, 2006, 03:20:02 pm »
You can use pics_, any simple name is fine.
Logged

Understudy

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Gender: Male
  • Posts: 51
    • Another boring website
Re: mysql table error
« Reply #4 on: March 10, 2006, 12:47:12 am »
Okay Idid that all looks good here. Thank You.

Sincerely,
Brendhan
Logged
Pages: [1]   Go Up
« previous next »
 

Page created in 0.019 seconds with 15 queries.