Problems in MySQL Problems in MySQL
 

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]

Main Menu

Problems in MySQL

Started by Caucasian, October 28, 2006, 02:40:55 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Caucasian

Hello.
I installed the gallery, and everything worked fine, only the integration didnt go through. I thought that the reason might be that I deleted some images via ftp program and not via cpg as it was recommended and that resulted in some problems in sql database.

So I decided to delete everything and start all over again. After I deleted every single file of cpg gallery and then uploaded everything back via ftp program to the folder gallery which I created earlier. Tried to start the installation process. Wrote in sql database name, password etc... after entering all the data pushed on "Lets go button" and the message I get is this:

mySQL Error: Table 'cpg149_albums' already exists on query ' CREATE TABLE cpg149_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 COMMENT='Used to store albums''

I understand now what happened but I have no Idea how I can fix that. I did not backup forum and my website before installing gallery, and I cant install your gallery to my website.

Could anyone help me solving the problem?

Nibbler

Type in a different prefix on the installation page.

Caucasian