mySQL Error: Table 'xxx_albums' already exists during installation mySQL Error: Table 'xxx_albums' already exists during installation
 

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

mySQL Error: Table 'xxx_albums' already exists during installation

Started by psychophat, January 14, 2006, 09:02:01 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

psychophat

Hi,

I've been reading the installation guide and following it but during installation it gives this error:

The following errors were encountered and need to be corrected first:

mySQL Error: Table 'com_albums' already exists on query ' CREATE TABLE com_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've been searching other topics but their mySQL problem is different, did I do something wrong during the installation? The details on the installation is the same as my forum also contacted my host for proper location of ImageMagick.

How do I overcome this issue?

Thank you in advance,


-Patrick Grey




Tranz

There might be a conflict in table prefix. Try using another one during installation.

psychophat

But would be different from my forum, how can I use thesame database as my forum it can be done with CPG right or do I do this later after it gets installed?

If I try to change the table prefix during installation and if it didn't have any problems would it still work with the forums current members database without any problems?

Sorry I'm very, very new to CPG first time and would like to use it badly.

Tranz

Different applications need to use different table prefixes if they are to be in the same database. If you want them to share user info, read the docs on integration/bridging.

psychophat

Followed your advice in changing ONLY the prefix and it was successful. Tested the login and it worked without any problems, will now proceed to skinning my CPG.

Thank you so much.