6 queries run...

Error in upgrade 2.2.0 Public Beta 2 (22005)

9 errors found

ALTER TABLE inv2_conf_settings_titles ADD conf_title_module varchar(200) NOT NULL default '';

[beeep]licate column name 'conf_title_module'

CREATE TABLE inv2_converge_local ( converge_api_code VARCHAR(32) NOT NULL default '', converge_product_id INT(10) NOT NULL default '0', converge_added INT(10) NOT NULL default '0', converge_ip_address VARCHAR(16) NOT NULL default '', converge_url VARCHAR(255) NOT NULL default '', converge_active INT(1) NOT NULL default '0', converge_http_user VARCHAR(255) NOT NULL default '', converge_http_pass VARCHAR(255) NOT NULL default '', PRIMARY KEY (converge_api_code ), KEY converge_active (converge_active) ) TYPE=MyISAM;

Table 'ibf_converge_local' already exists

CREATE TABLE inv2_admin_login_logs ( admin_id INT(10) NOT NULL auto_increment, admin_ip_address VARCHAR(16) NOT NULL default '0.0.0.0', admin_username VARCHAR(40) NOT NULL default '', admin_time INT(10) UNSIGNED NOT NULL default '0', admin_success INT(1) UNSIGNED NOT NULL default '0', admin_post_details TEXT NULL, PRIMARY KEY (admin_id), KEY admin_ip_address (admin_ip_address), KEY admin_time (admin_time) ) TYPE=MyISAM;

Table 'ibf_admin_login_logs' already exists

CREATE TABLE inv2_profile_friends ( friends_id INT(10) NOT NULL auto_increment, friends_member_id INT(10) UNSIGNED NOT NULL default '0', friends_friend_id INT(10) UNSIGNED NOT NULL default '0', friends_approved TINYINT(1) NOT NULL default '0', friends_added INT(10) UNSIGNED NOT NULL default '0', PRIMARY KEY( friends_id ), KEY my_friends ( friends_member_id, friends_friend_id ), KEY friends_member_id ( friends_member_id ) ) TYPE=MyISAM;

Table 'ibf_profile_friends' already exists

CREATE TABLE inv2_profile_comments ( comment_id INT(10) NOT NULL auto_increment, comment_for_member_id INT(10) UNSIGNED NOT NULL default '0', comment_by_member_id INT(10) UNSIGNED NOT NULL default '0', comment_date INT(10) UNSIGNED NOT NULL default '0', comment_ip_address VARCHAR(16) NOT NULL default '0', comment_content TEXT NULL, comment_approved TINYINT(1) NOT NULL default '0', PRIMARY KEY( comment_id ), KEY my_comments( comment_for_member_id ) ) TYPE=MyISAM;

Table 'ibf_profile_comments' already exists

CREATE TABLE inv2_profile_ratings ( rating_id INT(10) NOT NULL auto_increment, rating_for_member_id INT(10) NOT NULL default '0', rating_by_member_id INT(10) NOT NULL default '0', rating_added INT(10) NOT NULL default '0', rating_ip_address VARCHAR(16) NOT NULL default '', rating_value INT(2) NOT NULL default '0', PRIMARY KEY ( rating_id ), KEY rating_for_member_id ( rating_for_member_id ) ) TYPE=MyISAM;

Table 'ibf_profile_ratings' already exists

CREATE TABLE inv2_profile_portal ( pp_member_id INT(10) NOT NULL default '0', pp_profile_update INT(10) UNSIGNED NOT NULL default '0', pp_bio_content TEXT NULL, pp_last_visitors TEXT NULL, pp_comment_count INT(10) UNSIGNED NOT NULL default '0', pp_rating_hits INT(10) UNSIGNED NOT NULL default '0', pp_rating_value INT(10) UNSIGNED NOT NULL default '0', pp_rating_real INT(10) UNSIGNED NOT NULL default '0', pp_friend_count INT(5) UNSIGNED NOT NULL default '0', pp_main_photo VARCHAR(255) NOT NULL default '', pp_main_width INT(5) UNSIGNED NOT NULL default '0', pp_main_height INT(5) UNSIGNED NOT NULL default '0', pp_thumb_photo VARCHAR(255) NOT NULL default '', pp_thumb_width INT(5) UNSIGNED NOT NULL default '0', pp_thumb_height INT(5) UNSIGNED NOT NULL default '0', pp_gender VARCHAR(10) NOT NULL default '', pp_setting_notify_comments VARCHAR(10) NOT NULL default 'email', pp_setting_notify_friend VARCHAR(10) NOT NULL default 'email', pp_setting_moderate_comments TINYINT(1) NOT NULL default '0', pp_setting_moderate_friends TINYINT(1) NOT NULL default '0', pp_setting_count_friends INT(2) NOT NULL default '0', pp_setting_count_comments INT(2) NOT NULL default '0', pp_setting_count_visitors INT(2) NOT NULL default '0', pp_profile_views INT(10) NOT NULL default '0', PRIMARY KEY ( pp_member_id ) ) TYPE=MyISAM;

Table 'ibf_profile_portal' already exists

CREATE TABLE inv2_profile_portal_views ( views_member_id int(10) NOT NULL default '0' ) TYPE=MyISAM;

Table 'ibf_profile_portal_views' already exists

DROP TABLE inv2_calendar_events;

Unknown table 'ibf_calendar_events'

3 queries run....

Error in upgrade 2.2.0 Public Beta 2 (22005)

13 errors found

ALTER TABLE inv2_members ADD members_profile_views INT(10) UNSIGNED NOT NULL default '0';

[beeep]licate column name 'members_profile_views'

ALTER TABLE inv2_members ADD member_login_key_expire INT(10) NOT NULL default '0' AFTER member_login_key;

[beeep]licate column name 'member_login_key_expire'

alter table inv2_members ADD members_l_display_name VARCHAR(255) NOT NULL default '0';

[beeep]licate column name 'members_l_display_name'

alter table inv2_members ADD members_l_username VARCHAR(255) NOT NULL default '0';

[beeep]licate column name 'members_l_username'

alter table inv2_members DROP INDEX name;

Can't DROP 'name'; check that column/key exists

alter table inv2_members DROP INDEX members_display_name;

Can't DROP 'members_display_name'; check that column/key exists

ALTER TABLE inv2_members ADD INDEX members_l_display_name (members_l_display_name), ADD INDEX members_l_username (members_l_username);

[beeep]licate key name 'members_l_display_name'

ALTER TABLE inv2_members ADD failed_logins TEXT NULL;

[beeep]licate column name 'failed_logins'

ALTER TABLE inv2_members ADD failed_login_count SMALLINT( 3 ) DEFAULT '0' NOT NULL;

[beeep]licate column name 'failed_login_count'

ALTER TABLE inv2_members_partial ADD partial_email_ok INT(1) NOT NULL default '0';

[beeep]licate column name 'partial_email_ok'

ALTER TABLE inv2_attachments ADD attach_rel_id INT(10) NOT NULL default '0', ADD attach_rel_module VARCHAR(100) NOT NULL default '0';

[beeep]licate column name 'attach_rel_id'

ALTER TABLE inv2_attachments add attach_img_width INT(5) NOT NULL default '0', add attach_img_height INT(5) NOT NULL default '0';

[beeep]licate column name 'attach_img_width'

ALTER TABLE inv2_attachments DROP INDEX attach_mid_size, DROP INDEX attach_pid, DROP INDEX attach_msg, ADD INDEX attach_pid (attach_rel_id), ADD INDEX attach_mid_size (attach_member_id,attach_rel_module, attach_filesize), ADD INDEX attach_where (attach_rel_module, attach_rel_id);

Can't DROP 'attach_msg'; check that column/key exists