PhotoPost Community

PhotoPost Community (http://www.photopost.com/forum/)
-   Installs and Upgrade - vBulletin 3.6x (http://www.photopost.com/forum/installs-upgrade-vbulletin-3-6x/)
-   -   Upgrade Path (http://www.photopost.com/forum/installs-upgrade-vbulletin-3-6x/139364-upgrade-path.html)

tox February 26th, 2009 07:37 AM

Upgrade Path
 
Hi

I've been running vBulletin 3.5.2 with vBGallery 1.0.1 but it's now time to upgrade.

Without thinking, I've already brought vBulletin up to version 3.8.1, and now the gallery doesn't work (lots of db errors).

What's the best path to take now? Obviously I want to keep my images etc, so should I upgrade to vBGallery 2.4.3, or can PhotoPost 6.2 import everything?

Thanks
Martin

Chuck S February 26th, 2009 09:43 AM

You can upgrade to 2.43 as that would be the version of vbgallery that works with that version of vbulletin. As far as switching you can make that decision once you get things back up and running correctly.

tox February 26th, 2009 11:40 AM

I tried upgrading, and it all went horribly wrong: lots of db errors and I could no longer even access vBulletin admin - so I've rolled back.

This is what I did, starting from a working vBulletin 3.5.2 and vBaGallery 1.0.1:

1. Upgrade vBulletin to 3.8.1
2. Upload vBGallery 2.4.3
3. Run the install script, and clicked UPGRADE
4. Cried.

Am I doing something wrong?

Chuck S February 26th, 2009 11:48 AM

Well 1.1 is for vbulletin 3.5 so you might try reverting and then upgrading but you would need to let me know your upgrade problems errors so we may assist.

I have upgraded a few older sites from vbgallery 1.x series to 2.43 and not seen any issues so more information is needed.

Chuck S February 26th, 2009 11:50 AM

What version does your database vbgallery settings table say your running?

tox February 26th, 2009 12:05 PM

1.0.1 (vB3.5)

Unfortunately I can't revert the vBulletin back to a previous version.

What do you suggest I do first?

Chuck S February 26th, 2009 12:38 PM

Try upgrading to 2.43 and tell me the errors you get trying to upgrade.

tox February 26th, 2009 12:41 PM

i'm going to duplicate the site onto another server so I can test this without having to close the vBulletin any longer.

Chuck S February 26th, 2009 12:55 PM

Not a problem just let us know the issues so we can assist.

tox March 4th, 2009 06:07 AM

ok, I'm trying the upgrade again today. This is what I currently have:

vBulletin 3.8.1
vBGallery 1.0.1 (vB3.5)
vBadvanced CMPS v3.1.0

The gallery hasn't worked since I upgraded to the latest version of vBulletin. (I was using v3.5.2 before the upgrade and the gallery was fine).

I've downloaded photopost_vbgallery_2_5 and I'm following the standard install docs. Steps 1 & 2 are done.

Step 3 - Run the Install Script

I click on UPGRADE, and immediately get this:

Quote:

Database error in vBulletin 3.8.1:

Invalid SQL:
SELECT catid, styleid, title, title_clean, allowusercats, catuserid, membercat, parent, parentlist, hasimages, password, active, options, useroptions, styleoverride FROM ppgal_categories ORDER BY displayorder ASC, hasimages;

MySQL Error : Unknown column 'title_clean' in 'field list'
Error Number : 1054
Request Date : Wednesday, March 4th 2009 @ 06:00:26 AM
Error Date : Wednesday, March 4th 2009 @ 06:00:27 AM
Script : Log in - British Spanking Community - vBulletin Admin Control Panel
Referrer : Log in - British Spanking Community - vBulletin Admin Control Panel
IP Address : 86.17.250.247
Username : Headmaster
Classname : vB_Database
MySQL Version : 5.0.67-log
What should I do?

Thanks!

Luciano March 4th, 2009 06:23 AM

You will have to wait until chuck gets up.. (other timezone)...
I understand your error.. but to not know how to fix it easily...
The mistake was.. to upgrade vbulletin first...
you should have upgraded gallery... (old version for under 3.7) and then upgrade vbulletin... and then only upgrade gallery to the last version.. that would have worked fine...

anyway try to use 2.42 instead of 2.43 or 2.5..
i dont think 2.42 has the extra tables allready...

Hard way: do a clean install with 2.5 (fresh - no images)
open up in phpmyadmin..
compare the tables /fields (only for vbgallery) with your existing installation.. then create the columns or tables you are missing on your installation.. make sure you have the same type/length.. and other properties...
then the install should work..


Luc

tox March 4th, 2009 06:25 AM

Yes, I just dived in and upgraded vBulletin without thinking about anything else..!

Unfortunately the forum has been re-opened for a week so there's no way I can roll-back to the old version now.

Chuck S March 4th, 2009 09:29 AM

Well My suggestion is have you verified what version your gallery setting table has for the version? It should say your last version 1.01 then you should be able to upgrade.

Your system is looking for variables that are suppose to exist in a newer vbgallery.

tox March 4th, 2009 09:38 AM

Where do I find the version? Which table?

I'm restoring the database to how it was this morning, so I we can try the upgrade again now.

Chuck S March 4th, 2009 09:42 AM

The version is in the setting table of vbgallery ppgal_setting

tox March 4th, 2009 10:24 AM

The version number was in a table called adv_settings. 1.0.1 (vB 3.5)

Is that ok? What's next?

Chuck S March 4th, 2009 12:11 PM

Yes what version did it say?

tox March 4th, 2009 01:20 PM

gallery_version 1.0.1 (vB 3.5)

Chuck S March 4th, 2009 02:18 PM

If you run the vbgallery install script and select upgrade what error do you get ?

tox March 4th, 2009 02:21 PM

Immediately after clicking the UPGRADE button, I get a database error and can no longer access vBulletin or any admin.

This is the error:

Quote:

Database error in vBulletin 3.8.1:

Invalid SQL:
SELECT catid, styleid, title, title_clean, allowusercats, catuserid, membercat, parent, parentlist, hasimages, password, active, options, useroptions, styleoverride FROM ppgal_categories ORDER BY displayorder ASC, hasimages;

MySQL Error : Unknown column 'title_clean' in 'field list'
Error Number : 1054
Request Date : Wednesday, March 4th 2009 @ 06:00:26 AM
Error Date : Wednesday, March 4th 2009 @ 06:00:27 AM
Script : Log in - British Spanking Community - vBulletin Admin Control Panel
Referrer : Log in - British Spanking Community - vBulletin Admin Control Panel
IP Address : 86.17.250.247
Username : Headmaster
Classname : vB_Database
MySQL Version : 5.0.67-log


All times are GMT -5. The time now is 10:00 AM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97