1. 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

Discussion in 'Installation, Upgrade, and Import Support' started by WSWD, Jul 31, 2013.

  1. WSWD

    WSWD Well-Known Member

    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.
     
  2. Brogan

    Brogan XenForo Moderator Staff Member

  3. WSWD

    WSWD Well-Known Member

    Had a bunch of add-ons installed, but disabled them all prior to the upgrade. Everything else is completely stock.
     
  4. Brogan

    Brogan XenForo Moderator Staff Member

    That doesn't really help.

    We need to know which add-on is causing the problem.
     
    Amaury likes this.
  5. WSWD

    WSWD Well-Known Member

    Auto Birthday Greeter
    Nodes as Tabs
    Prefix Forum Listing
    Registration Form Timer
    Require Thread Prefixes
    Template Modification System
    Online Status Ribbon
    User Rank Ribbons
     
  6. Tracy Perry

    Tracy Perry Well-Known Member

  7. WSWD

    WSWD Well-Known Member

    That's the one. I disabled all prior to upgrading though, per the instructions. In the process of restoring from backups now.
     
  8. Jeremy

    Jeremy XenForo Moderator Staff Member

    Disabling add-ons that have modified a database can still cause an upgrade to fail. Verifying compatibility before upgrading is always a good idea.
     
    Amaury and Tracy Perry like this.
  9. WSWD

    WSWD Well-Known Member


    Perhaps the instructions should be changed then?


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

    Jeremy XenForo Moderator Staff Member

    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.
     
  11. WSWD

    WSWD Well-Known Member

    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.
     
  12. WSWD

    WSWD Well-Known Member

    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.
     
  13. Jeremy

    Jeremy XenForo Moderator Staff Member

    That is a risk of installing 3rd party add-ons, and exists on every software, not just XenForo.
     
    Amaury and The Forum Heroes like this.
  14. Tracy Perry

    Tracy Perry Well-Known Member

    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).
     
    Amaury likes this.
  15. Jeremy

    Jeremy XenForo Moderator Staff Member

    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.
     
    Tracy Perry likes this.
  16. WSWD

    WSWD Well-Known Member

    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.
     
  17. Jeremy

    Jeremy XenForo Moderator Staff Member

    SQL doesn't work that way with altering or adding tables; the queries fail. XenForo is no different.
     
  18. Tracy Perry

    Tracy Perry Well-Known Member

    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).
     
  19. Tracy Perry

    Tracy Perry Well-Known Member

    And then you run into the problem of it not working. The CORRECT solution is that the developer should NEVER be using the xf_ prefix for ANY of his/her database table creations.
     
  20. WSWD

    WSWD Well-Known Member

    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.
     

Share This Page