sudden problem with gallery loading

[kb1100]

Okay, thank you very much for your help, I would of been lost. I will try to upgrade as long as I will not loose anything. I won't loose all of my categories, albums, or files in the albums will I?

[Nibbler]

You won't lose anything if you do it properly.

[kb1100]

Ok, I went to the upgrade docs and the first thing it says to do is to "First, make a backup (dump) of your database." Can I do this seeing I can't get to my gallery?

[Nibbler]

You can make the dump using any database admin tool, such as phpmyadmin.

[kb1100]

OK thank you very much. I save my datebase just by exporting it then? I did this and its just a bunch of text.

[Nibbler]

Yes, that's what a dump looks like.

[Joachim Müller]

I'll have to go find a beta release to figure out what the "core" theme is

Here are the download links (hidden on the official downloads page) for older versions:

• cpg1.4.0 (alpha)
• cpg1.4.1 (beta)
• cpg1.4.1 (beta2)

Dev-only thread that explains the naming scheme: http://forum.coppermine-gallery.net/index.php?topic=12899.msg78327#msg78327

[kb1100]

I followed the upgrade instructions and upgraded to version 1.4.3 but now when I try to go to my gallery I get the following:
Coppermine Photo Gallery seems not to be installed correctly, or you are running coppermine for the first time. You'll be redirected to the installer. If your browser doesn't support redirect, click here.

When I click the "click here" link  I get the following:
• • • ERROR • • • 
The installer has already been run successfuly once and is now locked.

If you want to run the installer again, you first need to delete the 'include/install.lock' file that was created in the directory where you put Coppermine. You can do this with any FTP program. 

Would deleting the lock file and reinstalling fix this? And would I still be able to have all of the content as I did before this mess? I saved the datebase as instructed in the upgrade.

[Nibbler]

What did you do with your include/config.inc.php file ?

[kb1100]

I copied that file to my hard drive as well as the anyconntent.php file.

[Nibbler]

Make sure you copied it and did not move it. You are getting that message because that file is not there.

[kb1100]

Ok, I just checked and the config.inc.php file was not there so I uploaded the copy that I saved. Now when I go to my gallery I get this:
Fatal error :

[Paver]

Is this when you go to the main page or when you go to the installer?

[kb1100]

This is when I go to the main page.

[Paver]

What happens when you run "update.php"?

[kb1100]

When I run the update it shows the following at the bottom:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /mounted-storage/home8/sub001/sc14959-TCLB/LN/members/gallery/update.php on line 47

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /mounted-storage/home8/sub001/sc14959-TCLB/LN/members/gallery/update.php on line 50

Upgrade completed

And I tried to go to my gallery after I did this and it is still the same.

[Nibbler]

Make sure include/config.inc.php contains correct information about your database.

[Paver]

It sounds like your config.inc.php is not set up properly.  update.php cannot find your existing Coppermine database tables.  You need to have the correct name of your database and the table prefix (and the connection information).  Are you using the one from your previous installation?  You can edit config.inc.php with a text editor and check the information.

Yeah, what Nibbler said.

[kb1100]

It has all the correct info as far as datebase name, user name, and password. The other info in the file is:
$CONFIG['TABLE_PREFIX'] =                'cpg140_';

and I checked my phpmy admin and the table names are as follows so I dont see what is wrong with that. 
  cpg140_albums
  cpg140_banned
  cpg140_bridge
  cpg140_dict
  cpg140_ecards
  cpg140_exif
  cpg140_favpics
  cpg140_filetypes
  cpg140_hit_stats
  cpg140_plugins
  cpg140_sessions
  cpg140_temp_data
  cpg140_vote_stats

[Nibbler]

While you are in phpmyadmin, use the SQL tab to run the query

UPDATE cpg140_config set value = 1 where name = 'debug_mode'

Then go back to your gallery.