need to install 1.4 and then use 1.3 backup to create the new/old gallery

[renatab]

i messed up quite a few things on my way to upgrade...
so i need instructions for the following
1) new install of 1.42 (i am having problems here already - the install procedure results in a

mySQL Error: Table 'cpg142_albums' already exists on query ' CREATE TABLE cpg142_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'

- i am using a newly created databes, but there seems to be a conflict somewhere...

2) migrate my back-up data properly, so the album will work again.

3) i am majorly stressed  :'( , but from my other gallery i know it is worth going through the trouble, because 1.42 is awesome!!
ciao from italy
r

[Joachim Müller]

chose another table-prefix during install if you must do a fresh install. however I recommend doing as suggested and performing and upgrade instead of a fresh install.

[renatab]

ok... i decided to go that way... but with a mixed result 
these are the messages i received.
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/mhd-01/www.renatavonline.com/htdocs/gallery/update.php on line 47
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/mhd-01/www.renatavonline.com/htdocs/gallery/update.php on line 50
Upgrade completed
The Versioncheck gave me this (for me cryptic) message
Notice: Undefined index: debug_mode in /home/mhd-01/www.renatavonline.com/htdocs/gallery/include/functions.inc.php on line 96
Fatal error :
There was an error while processing a database query

http://www.renatavonline.com/gallery/ is my site, by the way. the picture show fine in my weblog where they are mirrored, so something is there. tricks to get in through admin fail as the passwords do not work.
sigh!!!
hope to get the rescuing straw...

[Nibbler]

It's because the information in include/config.inc.php is incorrect, probably the table prefix. You get the error in update.php because the script is trying to update your gallery but cannot access the db in order to do so.

[renatab]

checked the config/incl.php, but no better luck here. <+++ with 10 refreshers it worked!!
any other suggestions from your magic toolbox?
still hopeful
renata
ps the include /config file i replace with one that i found in an older back-up it worked !!!
just now there is this message on s http://www.renatavonline.com/gallery/versioncheck.php which says - You don't have permission to access this page. ,and the gallery index is not exactly kind either with Fatal error: Call to undefined function: get_meta_album_set() in /home/mhd-01/www.renatavonline.com/htdocs/gallery/index.php on line 748
what do i have to improve here?
renata (grateful!!!)

[Nibbler]

Make sure all your files are the 1.4 versions. Some of them ceratinly aren't such as init.inc.php

[renatab]

yep. some files really are not the new ones- and i coudl swear that i did the right thing.
all is looking more civilised now - just i cannot log in. to be on the safe side i ran the script that reveals the login and password (what a great thing!!!!), but with no results (other than being locked out for now).
which file would need my fine touch (like the rock in the phantastic 4, it seems right now)?
hopeful and humble
r

[Tranz]

I ran the update.php script so see if that helps with the login issue. It seems your gallery root has an index.html from the album folder. You should remove that because it is making the gallery folder redirect to your home page. You should have an index.php remaining. When I access it, I don't get redirected.

Did you extract the compressed file that contained the coppermine files, or did you just double-clicked to open, and saw a bunch of files with no folders?

[renatab]

i deleted the index.html file.
i extracted the downloaded files properly.
still cannot log in- the file which "recognizes" the login / pw must be somehow unaccessible- as i cannot get anything done with asking for pw through the e-mail address i put in- that one alos does not get recognized...
any access data that would help you see more of my dilemma?
renata

[Nibbler]

Check the config table manually in phpmyadmin and make sure that password encryption is set correctly.

[renatab]

ok- i am have been in my php admin, but unfortunately i am not sure what i am looking for there. i found the config table.. and there inspiration left me, as this is an area where i am not very literate.
all advice welcome- as it seems i am getting closer to the target...thx!!
to be more precise...
this is what i found so far as a my phptable / file that has to do with pw...
enable_encrypted_passwords 1 with value smtp_password .. is that it??

i hope this is not  too cheeky, but could someone have a look at the table? i have been swimming through code for most of the last 2 days, and still no result... for sure the user / passord are there in the users...

[renatab]

should this be moved to another forum as it really deals with a different issue now? i am, however, tempted to do a fresh install as not being able to log in and all the hours of ftp, cpanel etc really are getting me  :'( .

[Nibbler]

Change the value of enable_encrypted_passwords to 0

[renatab]

 
i finally did it.
i guess the good thing is that i now have 1.4.3 (i hoped this would do the trick), i had a pretty good look ad phpadmin (the abyss), and now i only got to find where the old visit-counter went and work on the theme. THANK YOU!!!!!!!!!!
renata