Moving existing albumbs from 1.4 to 1.5 new install Moving existing albumbs from 1.4 to 1.5 new install
 

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Main Menu

Moving existing albumbs from 1.4 to 1.5 new install

Started by photok-12, March 14, 2012, 04:46:42 PM

Previous topic - Next topic

0 Members and 2 Guests are viewing this topic.

photok-12

I have a new install of Coppermine and wish to import all of my old albums and photo data from the existing SQL.   This was a fresh install and not an upgrade. 
 
I have exported and imported the tables albums and pictures from cpg14x_ to the new tables in cpg15x_. 

On the index page, I am seeing all of the album names listed but there are no photos in them.    How do I get the photos to appear in the install?   They are still in the same albums directory as before.

Thanks

Αndré

Instead of importing just a few tables, import the whole database and then run update.php to perform the needed database changes. This procedure equals a regular upgrade.

photok-12

I actually kept the same database, only different table names  (cpg14x_ and 15x_).

Do I need to export and import each of the tables in the old cpg14x_ into the new 15x_ within the same database?

Αndré

You need all "old" tables. As you don't want to follow our recommended upgrade procedure (for whatever reason), we don't support what you do. Copy / rename / import & export your tables as you like, it's your decision.

photok-12

Im trying to recover from a fatal error on the 1.4 by starting fresh with 1.5.   That is why I did not choose the upgrade feature.

Αndré

Just use your whole cpg1.4.x database, copy all cpg1.5.x files to your server, use the include/config.inc.php file from your cpg1.4.x gallery and then run update.php. As already said
Quote from: Αndré on March 14, 2012, 05:06:42 PM
This procedure equals a regular upgrade.

photok-12

Cant do that.   Somewhere in 1.4 is the fatal error, hints why copying the config.inc.php will not work.  And is why I'm trying to get 1.5 to work.

Let me start fresh:

I have old and new tables in SQL and all new 1.5 php/config files uploaded.   I have some photos on the server, in their original location, and the original albums list.   I want to be able to keep my photos and albums.    I dont know how to troubleshoot the fatal error as there are no codes displayed.

What is the best way for me to do this?

photok-12

Ok,  It appears as if the photos are there when I go into each albums properties when I log in.
They are not approved, is why they are not showing.

Is there any easy way to approve all of these photos?   There's hundreds of galleries.

Αndré

Quote from: photok-12 on March 14, 2012, 06:21:02 PM
Is there any easy way to approve all of these photos?

Run this SQL query with a tool like PHPMyAdmin:
QuoteUPDATE cpg15x_pictures SET approved = 'YES'

photok-12

Andre, you are so much help...

One last issue I'm having.

Once a guest who has not logged in clicks on a photo in the album thumbnails, it is bringing up a log in page.   I want them to be able to view, enlarge, slideshow, etc. without logging in.    Is there another query I can run to resolve this issue? 

photok-12

Nevermind, it was a setting from the new 1.5.

Works great now Andre.  Thanks.

Αndré

Please
Quote from: Joachim Müller on September 28, 2008, 12:46:26 PM
tag your answer as "solved" by clicking on the "Topic Solved" button on the bar at the left hand side at the bottom of your thread.