• 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

Mouth

Well-known member
#1
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.
 

Chris D

XenForo developer
Staff member
#4
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...