For too many reasons, I haven't upgraded since 1.2.6

It looks like making the jump directly won't work as something changed with the database tables along the way. (Yes I tried.)

There are just shy of 10,000 photos in 215 albums.

My first thought was that the way we use zenphoto it really wouldn't be too big of an issue to do a clean install of 1.4.0.4 with a clean database and just move the /albums folder to the new install. (Basically it's 10 years of family photo's, the site was created for 2 purposes: sharing, and the site itself is our offsite backup of the photo's.)

However reviewing the existing original install (1.2.6) I'm finding there is one thing in the database that it would be nice to retain... about 1500 pictures have been tagged.

Short of stepping thru the approx 9 upgrades does anyone know a way to retain the tags? (I'll do the clean install and let the kids re-tag before I'll give my time to stepping thru the upgrades 1 by 1, however if someone could say take it to 1.x.x and then to 1.4.0.4 I would give that a try.)

As you my be able to tell from the above, I'm pretty proficient with respect to the shell, *nix commands and file structure. I'm less proficient exporting and importing database tables but feel like that may be an option as well, if someone familiar enough with the database schema gave some specifics.

I'm not including a link to the site as it's private, but if anyone really needs access let me know and I can make it happen.

Thanks for any tips, suggestions or knowledge.

Just out o curiosity, what did go wrong when you tried the jump upgrade? If it is fixable we will do that. We hope that the upgrades would work, but do not have the time to test all.

Anyway, the only suggestions are:

Upgrade via going to intermediate releases. Unfortunately, for the reason stated above we do not know which ones need be installed and which can be skipped.

Make a Zenphoto backup on the 1.2.6 release and do a fresh install with 1.4.0.4 with the backup file in the backup folder. That will offer you an option to do a restore when setup has finished. Do the restore. Some fields will not restore if they no longer exist, but maybe the ones you care about will restore

I somehow closed my setup tab without documenting the exact messages (and I know better). I ended up reverting and didn't allow setup to make changes by clicking GO.

I took a quick browse thru the database tables and see there may be no easy answer since the actual tags are stored in the zp_tags table and are actually linked via zp_obj_to_tag to an object. It doesn't stand to reason that in a clean database even a restore would work since the objectid's will probably be different in the new 'clean' database.

I'll take another look in the morning, and if I still can't resolve it then I'll provide more info.

Thanks!

The problem was actually a database access error, caused by ME!

Upgrade was successful!