Can't upgrade

[neen]

I get an error when I try to upgrade from 2.1.7 to 2.2.0B2.

I'm not using a live board - using a second copy of one.

Error:

8 queries run...

Error in upgrade 2.2.0 Public Beta 2 (22005)

7 errors found

CREATE TABLE ibf_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) );

Table 'ibf_converge_local' already exists

CREATE TABLE ibf_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 NOT NULL default '', PRIMARY KEY (admin_id), KEY admin_ip_address (admin_ip_address), KEY admin_time (admin_time) );

Table 'ibf_admin_login_logs' already exists

CREATE TABLE ibf_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 ) );

Table 'ibf_profile_friends' already exists

CREATE TABLE ibf_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 NOT NULL default '', comment_approved TINYINT(1) NOT NULL default '0', PRIMARY KEY( comment_id ), KEY my_comments( comment_for_member_id ) );

Table 'ibf_profile_comments' already exists

CREATE TABLE ibf_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 ) );

Table 'ibf_profile_ratings' already exists

CREATE TABLE ibf_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 NOT NULL default '', pp_last_visitors TEXT NOT NULL default '', 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 ) );

Table 'ibf_profile_portal' already exists

CREATE TABLE ibf_profile_portal_views ( views_member_id int(10) NOT NULL default '0' );

Table 'ibf_profile_portal_views' already exists

Any ideas? :unsure:

[Keven Fox]

I have an idea.


Don't UPGRADE!

Don't be stupid to upgrade to a non-stable release. How MANY times were you told this? You deserve every error. Learn to read.

[ScottyToledo]

I have an idea.

Don't UPGRADE!

Don't be stupid to upgrade to a non-stable release. How MANY times were you told this? You deserve every error. Learn to read.

Uh, if you would read what was said in that post:

I'm not using a live board - using a second copy of one.

Beta 2 came with an upgrade script. To test it out. This poster was TESTING.

[neen]

I have an idea.

Don't UPGRADE!

Don't be stupid to upgrade to a non-stable release. How MANY times were you told this? You deserve every error. Learn to read.

I have an idea.

ACTUALLY READ THE POST YOU ARE REPLYING TO!

[Keven Fox]

Oops, yep I admit I didn't see that part. Oh well, we all will live.

[SnakEyez]

Looks like a problem where the script doesn't check if tables already exist.

[neen]

Oops, yep I admit I didn't see that part. Oh well, we all will live.

We all make mistakes, too. :whistle:

No offense was intended. >_<

[Josh DeVeau]

You people are seriously unprofessional sometimes.