I’ve been trying to upgrade from 2.1.3 to 2.2.2 and now 2.3.0 for a week and cannot get it to work. I’ve finally narrowed down some of my issues and hopefully can get some help instead of being pointed to the update expression engine wiki or trouble shooting updates wiki.
When I try to upgrade I get numerous errors about duplicate columns or tables that don’t exist in my database. I’ve outlined them here and the error received. I would add these missing tables but I can find no documentation on the appropriate settings, and they are not added to a default install in 2.2.2 or 2.3.0
You’ll find this information in /installer/updates/ud_009.php
// Define the table changes
$Q[] = "ALTER TABLE exp_member_groups ADD COLUMN can_search char(1) NOT NULL default 'n'"; // Duplicate Column
$Q[] = "ALTER TABLE exp_member_groups ADD COLUMN search_flood_control mediumint(5) unsigned NOT NULL"; // Duplicate Column
$Q[] = "ALTER TABLE exp_member_groups ADD COLUMN can_moderate_comments char(1) NOT NULL default 'n'"; // Duplicate Column
$Q[] = "ALTER TABLE exp_weblogs ADD COLUMN search_excerpt int(4) unsigned NOT NULL"; // Table Doesn't Exist
$Q[] = "ALTER TABLE exp_weblogs ADD COLUMN comment_moderate char(1) NOT NULL default 'n'"; // Table Doesn't Exist
$Q[] = "ALTER TABLE exp_comments ADD COLUMN status char(1) NOT NULL default 'o'"; // Duplicate Column
$Q[] = "ALTER TABLE exp_referrers ADD COLUMN ref_ip varchar(16) default '0' NOT NULL"; // Table Doesn't Exist
$Q[] = "ALTER TABLE exp_referrers ADD COLUMN ref_date int(10) unsigned default '0' NOT NULL"; // Table Doesn't Exist
$Q[] = "ALTER TABLE exp_referrers ADD COLUMN ref_agent varchar(100) NOT NULL"; // Table Doesn't Exist
$Q[] = "ALTER TABLE exp_templates ADD COLUMN php_parse_location char(1) NOT NULL default 'o'"; // Duplicate Column
// Fix DB typos
$Q[] = "ALTER TABLE exp_member_homepage CHANGE COLUMN memeber_search_form member_search_form char(1) NOT NULL default 'n'"; // Unknown Column
$Q[] = "ALTER TABLE exp_member_homepage CHANGE COLUMN memeber_search_form_order member_search_form_order int(3) unsigned NOT NULL default '0'"; // Unknown Column
$Q[] = "UPDATE exp_actions SET method = 'retrieve_password' WHERE class = 'Member' AND method = 'retreive_password'"; // Haven't experienced problems from this line.
// Add keys to some tables
$Q[] = "ALTER TABLE exp_weblog_titles ADD INDEX(weblog_id)"; // Table Doesn't Exist
$Q[] = "ALTER TABLE exp_weblog_titles ADD INDEX(author_id)"; // Table Doesn't Exist
$Q[] = "ALTER TABLE exp_category_posts ADD INDEX(entry_id)"; // Haven't experienced problems from this line.
$Q[] = "ALTER TABLE exp_category_posts ADD INDEX(cat_id)"; // Haven't experienced problems from this line.
$Q[] = "ALTER TABLE exp_weblogs ADD INDEX(cat_group)"; // Table Doesn't Exist
$Q[] = "ALTER TABLE exp_weblogs ADD INDEX(status_group)"; // Table Doesn't Exist
$Q[] = "ALTER TABLE exp_weblogs ADD INDEX(field_group)"; // Table Doesn't ExistI’d really appreciate some help on this as I am at a loss at this point.
-Ben