Manual (partial) upgrade from broken Gallery 2?

pfreed

Joined: 2010-09-05
Posts: 10
Posted: Fri, 2011-04-22 20:36

I want to move some data from an old (broken) G2 installation into Gallery 3.01.

But first, I have to offer many thanks and much kudos to the Gallery team for a fantastic product, freely offered and supported.

For some time, I was using Gallery 2 on an old Centos 10 server. It wasn't my server, though, and getting the right versions of PHP (et al) onto the system was a chore. At some point something happened that caused Gallery to break. (I think it was during a module update, but I no longer recall.) All efforts on my part to make it work again failed.

I now have my own system, and I have installed Gallery 3.0.1. I can easily move the photos over from the old system using the "Server Install." But I would also like to move over the Title, Summary, and Description fields for each image from the Gallery 2 database.

My options:
1) Copy over the Gallery2 data and DB and try to make it work on my new system. Then I can run the importer.

2) "Server Install" the images from the old system. Then write a short Perl program to convert the data from the old Gallery 2 DB into the new one.

Personally I like option 2 since it doesn't depend as much upon a mysteriously broken system. It seems simple, though I'm not sure about the equivalence of slug and summary:

Quote:
In G2 db:
- find physical file in g2_FileSystemEntity
- use g_id to find fields g_title, g_summary, g_description in g2_Item

In G3 db:
- find physical file in Item.
- If there is ambiguity, check the parent to ensure we have the right file
- assign: title = G2.g_title
- assign: slug = G2.g_summary
- assign: description = G2.g_description

My questions:
- Is there a better way to do this that I have overlooked?
- Is my conversion logic reasonable?
- Is "slug" the right field to use for this purpose?
- Is there a theme that allows me to edit the slug, and to display it (and perhaps the description, too) with the thumbnail?

Thanks again.