• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

XF 1.2 Major Upgrade Issue

WSWD

Well-known member
#1
Hello all. Help please! :) Getting the following error and now nothing is working at all:

Uh oh, your upgrade to 1.2.0 has failed!

The following elements of the database are incorrect:

  • Column xf_forum.allowed_watch_notifications missing.
  • Column xf_forum.default_sort_order missing.
  • Column xf_forum.default_sort_direction missing.
This is likely caused by an add-on conflict. You may need to restore a backup, remove the offending add-on data from the database, and retry the upgrade. Contact support if you are not sure how to proceed.
 

WSWD

Well-known member
#3
Had a bunch of add-ons installed, but disabled them all prior to the upgrade. Everything else is completely stock.
 

WSWD

Well-known member
#5
Auto Birthday Greeter
Nodes as Tabs
Prefix Forum Listing
Registration Form Timer
Require Thread Prefixes
Template Modification System
Online Status Ribbon
User Rank Ribbons
 

WSWD

Well-known member
#7
That's the one. I disabled all prior to upgrading though, per the instructions. In the process of restoring from backups now.
 

WSWD

Well-known member
#9
Disabling add-ons that have modified a database can still cause an upgrade to fail. Verifying compatibility before upgrading is always a good idea.

Perhaps the instructions should be changed then?

The Upgrade Instructions said:
If you have any add-ons installed, ensure they are compatible with 1.2 before upgrading.
If in doubt disable them, perform the upgrade and then re-enable them one at a time to determine whether they still work.

Yep...that's what I did. Disabled them, hoping to re-enable them one at a time.
 

Jeremy

Well-known member
#10
The instructions cover this. You should ensure compatibility with 1.2 before attempting to upgrade. Test upgrades (on a test forum) are also a good idea.
 

WSWD

Well-known member
#11
The instructions cover this. You should ensure compatibility with 1.2 before attempting to upgrade.
It then says "If in doubt disable them". That's what I did. I was in doubt and disabled them. Then the installation broke.

I have been admin'ing forums for years and years, and not once has an add-on ever prevented an upgrade/update. Not with any software. Probably something that should be worked out.
 

WSWD

Well-known member
#12
If you have to rely on 3rd parties to upgrade their add-ons before you can upgrade the core forum software, that's just silly. You might be waiting for ages...perhaps forever. What if the add-ons stopped being developed, etc.?

Makes absolutely no sense, I'm afraid.
 

Tracy Perry

Well-known member
#14
That is a risk of installing 3rd party add-ons, and exists on every software, not just XenForo.
And it's even MORE noticeable when they make database entries that may conflict. I don't know of any easy way to get around this unless it's to have a safety check in the upgrade routine to see if that name exists and if so cancel the upgrade and notify about it (which I don't think would be easy to do).
 

Jeremy

Well-known member
#15
And it's even MORE noticeable when they make database entries that may conflict. I don't know of any easy way to get around this unless it's to have a safety check in the upgrade routine to see if that name exists and if so cancel the upgrade and notify about it (which I don't think would be easy to do).
XenForo now tells you of a possible failure. Most of these 'issues' can be avoided via properly prefixed tables, names, etc. Leave unprefixed for official is the best possible route a developer can take.
 

WSWD

Well-known member
#16
That is a risk of installing 3rd party add-ons, and exists on every software, not just XenForo.
Like I said, never had it happen with any other software. The core forum software normally just overwrites anything the add-ons changed, and then the add-on simply doesn't work. It's never the other way around.

@Tracy Perry It's easy to fix. The forum software simply overwrites any database entries that were made by 3rd parties.
 

Tracy Perry

Well-known member
#18
XenForo now tells you of a possible failure. Most of these 'issues' can be avoided via properly prefixed tables, names, etc. Leave unprefixed for official is the best possible route a developer can take.
Never ran into the upgrade issue, so didn't know about it. Nobody should be using the xf_ prefix in their database routine that is not core software (read xenForo). Most of the authors that I use have their own (xengallery - Xen Media Gallery, sf - tenants spam utilities, dark - Post Ratings, etc).
 

WSWD

Well-known member
#20
SQL doesn't work that way with altering or adding tables; the queries fail. XenForo is no different.
And you're trying to tell me that XenForo can't compare tables with a base and return them to their original form if they have been altered? Tables that are added make absolutely no difference. Tables that are altered can be compared and fixed.
 
Top