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

XF 1.2 1.1.5 Upgrade Errors 1.2.4

#1
Uh oh, your upgrade to 1.2.4 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.
phpAdmin SQL
ALTER TABLE xf_forum
ADD require_prefix TINYINT UNSIGNED NOT NULL DEFAULT '0',
ADD allowed_watch_notifications VARCHAR(10) NOT NULL DEFAULT 'all',
ADD default_sort_order VARCHAR(25) NOT NULL DEFAULT 'last_post_date',
ADD default_sort_direction VARCHAR(5) NOT NULL DEFAULT 'desc'
#1060 - Duplicate column name 'require_prefix'

All addons disabled!
 

AndyB

Well-known member
#2
My best guess is that one of the add-ons you installed added the 'require_prefix' column to the xf_forum table and now when you try to upgrade the conflict occurs.
 
#4
Anyone encountering this error:
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.

Should run these queries:
Code:
ALTER TABLE xf_forum DROP require_prefix;
Code:
ALTER TABLE xf_forum
ADD require_prefix TINYINT UNSIGNED NOT NULL DEFAULT '0',
ADD allowed_watch_notifications VARCHAR(10) NOT NULL DEFAULT 'all',
ADD default_sort_order VARCHAR(25) NOT NULL DEFAULT 'last_post_date',
ADD default_sort_direction VARCHAR(5) NOT NULL DEFAULT 'desc';
Best Fixit Problem! Thanks Jeremey