2.0 => 2.5 Upgrade Problems

[blue6995]

I am trying to upgrade from PhotoPost vBGallery 2.0 to version 2.5 and get the error below.

I also ran this query and got the same result:
UPDATE vb3_adv_setting SET value = '2.0' WHERE varname = 'gallery_version';


Database error in vBulletin 3.8.2:

Invalid SQL:
DELETE FROM vb3_ppgal_settinggroup WHERE grouptitle = 'adv_global';

MySQL Error : Table 'rwfforum_vbulletin.vb3_ppgal_settinggroup' doesn't exist
Error Number : 1146
Request Date : Tuesday, May 26th 2009 @ 06:07:24 PM
Error Date : Tuesday, May 26th 2009 @ 06:07:24 PM
Script : Log in - Royal Welch Forum - vBulletin Admin Control Panel
Referrer : Log in - Royal Welch Forum - vBulletin Admin Control Panel
IP Address : 69.154.31.120
Username : Technical
Classname : vB_Database
MySQL Version : 5.0.67-community-log

[Chuck S]

2.5 Upgrade Error

[blue6995]

Same issue regardless what thread I answer.

[Chuck S]

Try running this query in phpmyadmin and tell me if you run upgrade again your problems are solved.

UPDATE vb3_adv_setting SET value = '2.0.0' WHERE varname = 'gallery_version';

Right but have you tried that? Because the issue is you get that error because your database version in that varname is incorrect. Setting it back a version should allow proper table creation and continuation.

[blue6995]

Thanks for the help

I ran the query and when I try to run the upgrade it says I'm running the current version.

I'm not though I have 2.0 running.

[Chuck S]

Have you ran that query uploaded all the new 2.5 files and then ran the upgrade?

[blue6995]

Yes sir.

[Chuck S]

What is the version that appears in the database under that variable gallery_version now?

[Chuck S]

One other change is that in vbgallery_install.php try adding this line in bold where noted.

Content visible to verified customers only.

[blue6995]

It shows 2.0 but I made a screen as a reference.

[blue6995]

I added the line to install and ran, same result.

[Chuck S]

It shows 2.0.0

You tried running the upgrade?

Feel free to server login details and admin login url for us to look at this if you wish. There is no reason the upgrade script would not run if its the current upgrade script.

[blue6995]

Not sure what your post says...Feel free to _______ server login?

Can't PM, did you mean to say email? If so, what email?

Thank you for the help

[Chuck S]

You can email us through the contact us link in the header.