mySQL Error: Table 'cpg133_albums'

[flightless]

**I have already done a search for this in the forum, but found no related posts.**

I was having a few problems with the Coppermine database and decided to rerun the install.php. I then had to removed the "lock" file to get access to changing the database username and password.

Now I am getting the following error and I am not at all sure what to do next:

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'


Any help will be appreciated.

Regards
Grounded.

[Tranz]

Exactly what type of problems do you have? You wouldn't be able to run install if your database already exists because you would get that error that says those tables already exist. If all you wanted to do was change the db details, you didn't need to delete the lock file. Just edit include/config.inc.php

The reinstall concept doesn't really apply to this application.

[flightless]

The database password was reset by my host. Had to change the details to get Coppermine to work.

What do I do now? (Seeing as I am now experiencing the problem as mentioned above.)

[Tranz]

Did you do as suggested? What exactly are you trying to do now?

[Joachim Müller]

if the db data has been changed by your webhost, all you have to do is edit include/config.inc.php and enter the new mysql access data there. Undo any other changes you made (e.g. deleting install.lock). If you have questions, you should always say what you did when you got issues, so in your case the question should have read like this "my webhost has changed mysql data, so I tried to run install.php. As I got an error message that said I couldn't install, I deleted install.lock. Re-running install.php resulted in the error message XXX". Correct me if I'm wrong. Failing to post a full report what you did will result in additional support efforts needed to solve the issue, and as a result your gallery will remain inaccessible for a longer time.

[flightless]

Thank you GauGau, that is exactly how it happened.

[Joachim Müller]

did our suggestions solve your issue then? You're suppossed to restore include/install.lock and edit include/config.inc.php with a plain-text editor.

[flightless]

Too late -

I deleted the lock file and do not have a copy of it to replace it.

[Tranz]

That's why you should be careful about deleting stuff without knowing what you're doing. Next time, you should save a backup.

You can recreate the file by making a new file in include and call it install.lock. In the file, put this:

Code Select Expand

locked

[flightless]

Thank you.

Yes ... we alll need to start learning somewhere ... 

I followed your advice, created the file and uploaded it.

I am now getting the following error when I go to the site:

Fatal error :
There was an error while processing a database query

I think I am missing a step somewhere, but not sure where.

[Joachim Müller]

enable debug_mode then to get a better error message and post the error message here (not the debug_output). To enable the debug mode, access your database directly using phpMyAdmin or similar, browse coppermine's config table and set the corresponding entry (debug_mode) to "1".

[flightless]

Thanks.

I followed your instructions and this is what I am getting now:

While executing query "SELECT * FROM cpg133_users WHERE user_id='0'AND user_active = 'YES' AND user_password_md5 != '' AND BINARY user_password_md5 = '*'" on 0

mySQL error: Unknown column 'user_password_md5' in 'where clause'

[Nibbler]

Are you running a modified version of Coppermine ?

[flightless]

No.

[Tranz]

md5 passwords were not available in v. 1.3x