Jon W
Well-known member
Try the query:
Code:
ALTER TABLE xf_resource_category
ADD field_cache MEDIUMBLOB NOT NULL,
DROP allow_submit_user_group_ids,
ADD prefix_cache MEDIUMBLOB NOT NULL COMMENT 'Serialized data from xf_resource_category_prefix, [group_id][prefix_id] => prefix_id',
ADD require_prefix TINYINT UNSIGNED NOT NULL DEFAULT '0',
ADD featured_count SMALLINT UNSIGNED NOT NULL DEFAULT '0'