2.0? -> 2.2 upgrade problems

Bryant · May 27th, 2007, 01:18 AM

Before upgrading, I checked the version number at the bottom of the galleries, and it claimed to be 2.0.

I say 'claimed', because there was something not quite right about the old install. It was functional, but I'd get a couple of these every day;

Code:

Content visible to verified customers only.

Upon downloading 2.2, I uploaded all the files as directed (from the gallery and forum folders), and was immediately hit by this once I hit the submit button to 'UPGRADE';

Code:

Content visible to verified customers only.

Went out to check my forums, and FORUMHOME was returning this;

Code:

Content visible to verified customers only.

I've since restored the backup of the database I made just before upgrading, and the site is working again, but now my gallery is a blank white page. This is, no doubt, due to 2.2 files being up, but the databases and edits being 2.0 (or even earlier?)

Moreover, I've had to disable the vbGallery 2.0 product in Admincp as it was breaking my Control Panel Home (I assume because of 2.2-relevant code in the summary that appears there).

Not sure what to do next.

Bryant · May 29th, 2007, 05:24 AM

Poked around a bit more this weekend, but didn't get anywhere, and didn't want to risk having to restore that 1.5gb database dump file again. :P Hoping now that the holiday is over, someone can point me in the right direction, my users are looking forward to having the gallery back.

Zachariah · May 29th, 2007, 06:54 PM

Hey,

What is the status of your gallery ?

Bryant · May 29th, 2007, 08:36 PM

http://www.buckeyeplanet.com/gallery/

Dead white page.

I reverted the database back to a point before the 2.2 upgrade script made changes, and disabled the vbGallery 2.0 item in the Product Manager.

So that's where I stand at the moment. 2.2 files on the server. Upgrade script that returns the error above when run. Database either 2.0, or something below 2.0 with missing fields even though 2.0 was the last installation.

Bryant · May 30th, 2007, 07:39 PM

In what version was ppgal_setting added? Is it possible then when we upgraded to 2.0, that some of the tables weren't updated?

Either way, what's the best course of action here? If necessary, I can provide access, but happy just to run a few queries, follow whatever steps are prescribed, etc.

Zachariah · May 30th, 2007, 08:49 PM

This should work.
- if problems, shoot me some ftp / adminCP access via PM

2.0 should of changed the tables from adv_gallery_* to ppgal_*
- can not find a table name ? "xxxx_setting"

This should fix the database errors when launching the upgrade script for the gallery.

edit:
forums/admincp/vbgallery_install.php

About line 869-874

find:

Code:

Content visible to verified customers only.

Replace:

Code:

Content visible to verified customers only.

Try running the update script again.

Bryant · May 30th, 2007, 09:03 PM

Thanks a ton, I'll report back either way to let you know how it goes.

Bryant · June 1st, 2007, 01:40 AM

Thanks for the fix! It seemed to work to fix the databases issues (the upgrade ran without a hitch).

My gallery is still a blank white page (as you can see below), but I'm sure that's something simple.

http://www.buckeyeplanet.com/gallery/

I checked the settings, and the paths are still correct. I checked gallery_config.php, and that path is still correct as well. Obviously the product is enabled. The admincp functions seem to work properly.

I'm sure I'm overlooking something simple here, but I don't see it, and I don't want to assume that running "Reinstall the templates, phrases, plugins." or "This will add setting and update setting cache" in the install file is a good bet until you indicate so.

--edit--
Also, this came in at 2am (after the upgrade, before the post below);

Code:

Content visible to verified customers only.

Bryant · June 1st, 2007, 03:28 AM

Looking through some of the admincp pages, I noticed something that indicated that I was running 2.1, rather than 2.2.

Did some searches around here, found someone saying they had to run the upgrader twice when going from 2.0 to 2.2, so I ran it again.

This time it errored out with this;

Code:

Content visible to verified customers only.

Zachariah · June 1st, 2007, 09:06 AM

All that is left is to make sure your datastore was updated, change the version number and build stats cache.

Code:

Content visible to verified customers only.

AdminCP => Scheduled Tasks => Scheduled Task Manager
- PhotoPost vBGallery Total Statistics
[ Run ]

Bryant · June 13th, 2007, 06:27 AM

Fell ill and was unable to do this, hope to try it soon to see if that wraps up the process.

Bryant · August 17th, 2007, 02:52 PM

It worked, thanks a bunch.

Zachariah · August 17th, 2007, 08:43 PM

good to hear