XF 1.2 1.1.5 Upgrade Errors 1.2.4

[TITAN-UZ]

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]

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.

 

[Jeremy]

http://xenforo.com/community/thread...nt-information-and-actions-to-be-taken.56027/

Disabling add-ons doesn't change what they did to the database.

 

[TITAN-UZ]

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:

ALTER TABLE xf_forum DROP require_prefix;

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