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

XF 1.1 Column xf_user.is_staff missing - upgrading 1.1 to 1.2

Discussion in 'Installation, Upgrade, and Import Support' started by Mouth, Oct 11, 2013.

  1. Mouth

    Mouth Well-Known Member

    I get the below when running CLI upgrade from 1.1.4 to 1.2.2 (dev environment test upgrade) ...

    Code:
    [...]
    Running upgrade to 1.2.0 Beta 4, step 3... done.
                                                                                   
    Running upgrade to 1.2.0, step 1... done.
    Rebuilding / importing data...
                                                                                   
    Upgrade completed but errors were found:
        * Column xf_user.is_staff 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.
    
    I followed pre-upgrade steps in http://xenforo.com/community/resources/how-to-upgrade-to-1-2.2397/ and all add-ons are disabled/inactive.

    My add-ons list is (many are disabled/inactive normally, just never uninstalled them) ...

    Code:
    8thos - No Redirect As Default When Moving Threads 1
    Delete...
    Controls
    
    8thos Google Authorship 1.5
    Delete...
    Controls
    
    Ad Manager 1.0 Beta 3.0.1
    Delete...
    Controls
    
    Add Username Style to Last Post 1.0.1
    Delete...
    Controls
    
    Add-on Install & Upgrade 1.0.0
    Delete...
    Controls
    
    AdminCP Firewall 1.0
    Delete...
    Controls
    
    Alexa Enhancer by xenCODE 1.0.0 Beta
    Delete...
    Controls
    
    Avatar Gallery 0.1b
    Delete...
    Controls
    
    AzuCloud 0.1.2
    Delete...
    Controls
    
    Bookmarks 1.1.5
    Delete...
    Controls
    
    Browser Detection (Mobile/MSIE) 1.2
    Delete...
    Controls
    
    Browser Update Notification 1.0
    Delete...
    Controls
    
    Cliptheapex.com's Countdown Timer 1.5.1.02_EQnoble
    Delete...
    Controls
    
    Control "nofollow" URLs 2.1
    Delete...
    Controls
    
    Conversation Essentials 1.1.8
    Delete...
    Controls
    
    Conversation on Moderator Action by Waindigo 1.0.3
    Delete...
    Controls
    
    Copy Paste Read More 1.1.1
    Delete...
    Controls
    
    Create Post on Report 1.0.0
    Delete...
    Controls
    
    DC - Staff Room Unread 1.0.0 Beta 1
    Delete...
    Controls
    
    Description for RSS 1.2
    Delete...
    Controls
    
    Digital Point Ad Positioning 1.1.0
    Delete...
    Controls
    
    Digital Point User Map 1.0.3
    Delete...
    Controls
    
    Donation Manager 1.0.2
    Delete...
    Controls
    
    Double Post 1.0.5
    Delete...
    Controls
    
    Easy Table BBCode 1.0.1
    Delete...
    Controls
    
    Edit User Join Date by Waindigo 1.0.4
    Delete...
    Controls
    
    Email Change Log 1.0.0
    Delete...
    Controls
    
    Find Unanswered Threads 1.0.4
    Delete...
    Controls
    
    Find users sharing the same IP 0.0.2
    Delete...
    Controls
    
    Fix for RSS Content - Line Breaks 1.0
    Delete...
    Controls
    
    Forum List Tabs by Waindigo 1.0.0
    Delete...
    Controls
    
    Friend Inviter 2.0.5
    Delete...
    Controls
    
    Go To Top ! 1.1.2
    Delete...
    Controls
    
    GoodForNothing XenSocialize 2.0.0
    Delete...
    Controls
    
    Help Pages 1.0.0
    Delete...
    Controls
    
    Hide Memberlist for Guests 1.2.1
    Delete...
    Controls
    
    Join User Group by Waindigo 1.1.0
    Delete...
    Controls
    
    Last Post Avatar by Waindigo 1.1.6
    Delete...
    Controls
    
    Lightbox Attachments on Forumhome 1.0.0
    Delete...
    Controls
    
    Like Reply Share Everywhere 1.3 BETA
    Delete...
    Controls
    
    LoginUserLocks - Prevent attempts to brute force the login area 1.0.1
    Delete...
    Controls
    
    Minimum Characters&Words Message Length 1
    Delete...
    Controls
    
    Mobile Agent Tracer 1.5.1
    Delete...
    Controls
    
    Mobile Style Selector 1.2
    Delete...
    Controls
    
    Monthly Email 1.0.4
    Delete...
    Controls
    
    Most Online User 1.2
    Delete...
    Controls
    
    Multiple Account Detection 1.0.1
    Delete...
    Controls
    
    New User Notification System 2.1
    Delete...
    Controls
    
    New Users Welcome 1.0
    Delete...
    Controls
    
    No Downtime by Waindigo 1.0.0
    Delete...
    Controls
    
    Nodes As Tabs 1.1.3
    Delete...
    Controls
    
    Notifications - powered by Gritter 1.5.1
    Delete...
    Controls
    
    Old Thread Warning 1.0.0 BETA2
    Delete...
    Controls
    
    Paid Sticky 1.2.1
    Delete...
    Controls
    
    Post Message Regex Replacer 1.0.0
    Delete...
    Controls
    
    Post Ratings 1.5.1
    Delete...
    Controls
    
    Prefix Forum Listing 1.2.1
    Delete...
    Controls
    
    Profile Completion Steps 1.0 Beta 1.1.1
    Delete...
    Controls
    
    Profile View Count 1.3
    Delete...
    Controls
    
    QuoteME ! 1.6
    Delete...
    Controls
    
    Recent Attachments Block 1.1d
    Delete...
    Controls
    
    Simple Staff Ranks 1.0
    Delete...
    Controls
    
    Sitemap for XenForo 1.2.7
    Delete...
    Controls
    
    Smilie Importer by Waindigo 1.0.0
    Delete...
    Controls
    
    Social 1.0
    Delete...
    Controls
    
    Social Connect (Bundle) 2.2a
    Delete...
    Controls
    
    Social Groups by Waindigo 1.0.2
    Delete...
    Controls
    
    Sort AddonList by Active Status 1.0.2
    Delete...
    Controls
    
    Staff Application 1.0
    Delete...
    Controls
    
    Sticky First Post 1.0
    Delete...
    Controls
    
    TAC AnyApi 1.0.3
    Delete...
    Controls
    
    TAC FaceBookRegCaptcha 1.0.0
    Delete...
    Controls
    
    TAC FoolBotHoneyPot - Stop bots from registering with honey pots 2.2.10
    Delete...
    Controls
    
    TAC StopCountrySpam - black/white list country IPs from registering 2.2.02
    Delete...
    Controls
    
    TAC StopHumanSpam - signature/link/homepage conditions & banned word posts 1.2.2
    Delete...
    Controls
    
    Tapatalk 1.8.1
    Delete...
    Controls
    
    Template Modification System 1.2.2
    Delete...
    Controls
    
    Thread Ban 1.0.2
    Delete...
    Controls
    
    Thread Watchers 1.2
    Delete...
    Controls
    
    TinyMCE Fix 0.7.1
    Delete...
    Controls
    
    Toggle ME 2.02
    Delete...
    Controls
    
    Trash Can Forum 1.0.1
    Delete...
    Controls
    
    User Essentials 1.1.2
    Delete...
    Controls
    
    User Self Delete 1.0.2
    Delete...
    Controls
    
    User Statistics 0.9.1
    Delete...
    Controls
    
    WDB Extra Stats 1.0
    Delete...
    Controls
    
    WDB Popular Content 1.0.3
    Delete...
    Controls
    
    WF - XenAtendo Upcoming Events 1.0.1
    Delete...
    Controls
    
    Who Replied 1.1.0
    Delete...
    Controls
    
    Widget Framework Widget Pack 1.0.1
    Delete...
    Controls
    
    XenFacil Birthday Greetings 3.0.0
    Delete...
    Controls
    
    XenFans.com - Popular Content 1.0.4
    Delete...
    Controls
    
    XenForo Enhanced Search 1.0.1
    Delete...
    Controls
    
    XenMoods 1.1.3
    Delete...
    Controls
    
    XF Arcade 0.0.9
    Delete...
    Controls
    
    XF QapTcha 1.1
    Delete...
    Controls
    
    XFA - Better Blogs 1.0.12
    Delete...
    Controls
    
    [3.studIo] Usergroup Ranks 1.5.6
    Delete...
    Controls
    
    [8wayRun.Com] XenAtendo (Events) 1.5.0
    Delete...
    Controls
    
    [8wayRun.Com] XenCarta (Wiki) 1.3.9
    Delete...
    Controls
    
    [8wayRun.Com] XenPorta (Portal) 1.5.7
    Delete...
    Controls
    
    [8wayRun.Com] XenUtiles (Tools) 1.2.2
    Delete...
    Controls
    
    [bd] Forum Watch 1.1
    Delete...
    Controls
    
    [bd] Medal 1.4
    Delete...
    Controls
    
    [bd] Medal - Trophy Extension 0.9.1
    Delete...
    Controls
    
    [bd] Tag Me 1.7.5b
    Delete...
    Controls
    
    [bd] Widget Framework 2.2.3
    Delete...
    Controls
    
    [CrazyIM] Profile Links 1.2.1
    Delete...
    Controls
    
    [dc] Smiley Manager 1.1.0
    Delete...
    Controls
    
    [FreddysHouse] Logger 1.0.4
    Delete...
    Controls
    
    [FreddysHouse] Two-Factor Authentication 1.1.2
    Delete...
    Controls
    
    [Iversia] FAQ Manager 1.0.1
    Delete...
    Controls
    
    [NFLJ] Showcase 1.2.0
    Delete...
    Controls
    
    [NFLJ] Sportsbook 1.1.1
    Delete...
    Controls
    
    [RT] Online Status Ribbon 1.3.3
    Delete...
    Controls
    
    [RT] User Rank Ribbons (15, w/TMS) 2.3
    Delete...
    Controls
    
    [SurreyForum] XenKingDir - Business / Links Directory 1.2.0.5
    Delete...
    Controls
    
    [Tinhte] Attach Image Optimization 2.2.10
    Delete...
    Controls
    
    [Tinhte] XenTag 1.6.3c
    Delete...
    Controls
    
    [tLk] Random Avatars 0.0.1
    Delete...
    Controls
    
    [ValveTime.net] Google+ Share Button 1.0
    Delete...
    Controls
    
    [ValveTime.net] LinkedIn Share Button - TMS 1.1
    Delete...
    Controls
    
    [ValveTime.net] QuoteCollapse 1.2
    Delete...
    Controls
    
    [xfr] User Albums 1.0.0 b7
    Delete...
    Controls
    
    [xfr] User Albums More 1.0.0
    Delete...
    Controls
    
    'Simple Staff Ranks' or 'Staff Application' seemed to be the most likely, so I un-installed both and re-ran the upgrade CLI, but still get the same error ...

    Code:
    root@ubuntu-server:/var/www/dev# php library/XenForo/Install/run-upgrade.php
    Current version: 1020270
    Upgrade target: 1020270 (1.2.2)
    
    Are you sure you want to upgrade? [y/n] y
    Rebuilding / importing data...
                                                                                   
    Upgrade completed but errors were found:
        * Column xf_user.is_staff 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. Chris D

    Chris D XenForo Developer Staff Member

  3. Mouth

    Mouth Well-Known Member

  4. Chris D

    Chris D XenForo Developer Staff Member

    I wonder which add-on causes that... Did you notice any common factors between your add-ons and Sheldon's?

    EDIT: I see your post on the other thread now...
     

Share This Page