forum.coppermine-gallery.net

Support => cpg1.4.x Support => Older/other versions => cpg1.4 install => Topic started by: renede on January 24, 2007, 10:37:21 pm

Title: re-install albums problems
Post by: renede on January 24, 2007, 10:37:21 pm

i tried re-installing on a new server and copied a completely new set of files. Triedthe installer but am getting the same message:
mySQL Error: Table 'albums' already exists on query ' CREATE TABLE 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', 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''

What do i do wrong?

Title: Re: re-install albums problems
Post by: Joachim Müller on January 24, 2007, 10:40:18 pm

Well, the error message should be quite clear: a table with that name already exists. Either delete the unneeded tables (if you really don't need them anymore) using a third-party application like phpMyAdmin or choose another table prefix during install.

Title: Re: re-install albums problems
Post by: renede on January 24, 2007, 11:17:42 pm

thanks Gaugau but i copied a completely NEW set of coppermine files. NO tables made or whatever. This errormessage comes up in the install screen,  i havent done ANYTHING yet...

Title: Re: re-install albums problems
Post by: Nibbler on January 24, 2007, 11:48:58 pm

You are connecting to the same database though. The database exists independently of the Coppermine files. Do as GauGau suggests.

Title: Re: re-install albums problems
Post by: renede on January 25, 2007, 12:00:09 am

thanks nibbler but no im not on the same database, im on a new server with a new host. i made only one database and tried to set the new coppermine to it as to begin from scratch. i made no settings

Title: Re: re-install albums problems
Post by: Nibbler on January 25, 2007, 12:08:49 am

Just pick a different prefix.

Title: Re: re-install albums problems
Post by: renede on January 25, 2007, 11:24:36 pm

where do i pick a different prefix?

Title: Re: re-install albums problems
Post by: Nibbler on January 25, 2007, 11:29:36 pm

Where it says MySQL table prefix

Title: Re: re-install albums problems
Post by: renede on January 30, 2007, 05:34:56 pm

im sorry, but on the server or in one of the Copperminefiles?

Title: Re: re-install albums problems
Post by: Nibbler on January 30, 2007, 05:52:06 pm

On the installer.

http://coppermine-gallery.net/demo/cpg14x/docs/index.htm#install_screen_start

Title: Re: re-install albums problems
Post by: renede on January 30, 2007, 06:31:54 pm

ok thanks but the default doesnt work and i tried leaving it blank (so it wouldthink for itself) but can i enter anything? Or albumnew or album2

Title: Re: re-install albums problems
Post by: Nibbler on January 30, 2007, 06:46:03 pm

Quote from: renede on January 30, 2007, 06:31:54 pm

Or albumnew or album2

Both fine.

Title: Re: re-install albums problems
Post by: renede on January 30, 2007, 10:01:22 pm

doesnt work...
Could not create a mySQL connection, please check the SQL values entered

MySQL error was : Access denied for user 'theaterinbeeld'@'localhost' (using password: YES)

i filled out host, username, password, databasename, MySQL table prefix (cpg1410_)

result: i can login but: Fatal error...

Title: Re: re-install albums problems
Post by: Nibbler on January 30, 2007, 10:23:38 pm

The details are not valid, check them as suggested.