Upgrade path from 2.x to 3.x

Hi there,

as stated in my previous post I couldn't get any 2.x version to display any tweets; I decided to give 3.x a try and updated. Fortunately, I backed up my DB, as I got loads of errors:

* user warning: Table 'twitter' already exists query: CREATE TABLE twitter ( `twitter_id` VARCHAR(255) NOT NULL DEFAULT '', `screen_name` VARCHAR(255) NOT NULL DEFAULT '', `created_at` VARCHAR(64) NOT NULL DEFAULT '', `created_time` INT NOT NULL, `text` VARCHAR(255) DEFAULT NULL, `source` VARCHAR(255) DEFAULT NULL, PRIMARY KEY (twitter_id), INDEX screen_name (screen_name) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /includes/database.inc on line 529.
* user warning: Table 'twitter_account' already exists query: CREATE TABLE twitter_account ( `twitter_uid` INT NOT NULL, `uid` BIGINT unsigned NOT NULL, `host` VARCHAR(255) DEFAULT NULL, `screen_name` VARCHAR(255) DEFAULT NULL, `password` VARCHAR(64) DEFAULT NULL, `oauth_token` VARCHAR(64) DEFAULT NULL, `oauth_token_secret` VARCHAR(64) DEFAULT NULL, `name` VARCHAR(64) NOT NULL DEFAULT '', `description` VARCHAR(255) DEFAULT NULL, `location` VARCHAR(255) DEFAULT NULL, `followers_count` INT NOT NULL DEFAULT 0, `friends_count` INT NOT NULL DEFAULT 0, `statuses_count` INT NOT NULL DEFAULT 0, `favourites_count` INT NOT NULL DEFAULT 0, `url` VARCHAR(255) DEFAULT NULL, `profile_image_url` VARCHAR(255) DEFAULT NULL, `protected` INT unsigned NOT NULL DEFAULT 0, `profile_background_color` VARCHAR(6) NOT NULL DEFAULT '', `profile_text_color` VARCHAR(6) NOT NULL DEFAULT '', `profile_link_color` VARCHAR(6) NOT NULL DEFAULT '', `profile_sidebar_fill_color` VARCHAR(6) NOT NULL DEFAULT '', `profile_sidebar_border_color` VARCHAR(6) NOT NULL DEFAULT '', `profile_background_image_url` VARCHAR(255) DEFAULT NULL, `profile_background_tile` INT unsigned NOT NULL DEFAULT 1, `verified` INT unsigned NOT NULL DEFAULT 1, `created_at` VARCHAR(64) NOT NULL DEFAULT '', `created_time` INT NOT NULL, `utc_offset` INT NOT NULL, `import` INT unsigned NOT NULL DEFAULT 1, `last_refresh` INT NOT NULL, PRIMARY KEY (twitter_uid), INDEX screen_name (screen_name) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /includes/database.inc on line 529.
* warning: array_merge() [function.array-merge]: Argument #2 is not an array in /update.php on line 174.
* user warning: Duplicate column name 'import' query: ALTER TABLE twitter_user ADD import int in /update.php on line 69.
* user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOT NULL' at line 1 query: ALTER TABLE twitter_user ALTER import SET NOT NULL in /update.php on line 77.
* user warning: Duplicate column name 'location' query: ALTER TABLE twitter_account ADD location varchar(255) in /update.php on line 69.
* user warning: Duplicate column name 'followers_count' query: ALTER TABLE twitter_account ADD followers_count int in /update.php on line 69.
* user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOT NULL' at line 1 query: ALTER TABLE twitter_account ALTER followers_count SET NOT NULL in /update.php on line 77.
* warning: Invalid argument supplied for foreach() in /update.php on line 338.

Updates were attempted. If you see no failures below, you may proceed happily to the administration pages. Otherwise, you may need to update your database manually. All errors have been logged.

* Main page
* Administration pages

The following queries were executed
twitter module
Update #6000

* No queries

Update #6001

* Failed: ALTER TABLE {twitter_user} ADD import int
* ALTER TABLE {twitter_user} ALTER import SET default 1
* UPDATE {twitter_user} SET import = 1
* Failed: ALTER TABLE {twitter_user} ALTER import SET NOT NULL
* Failed: ALTER TABLE {twitter_account} ADD location varchar(255)
* Failed: ALTER TABLE {twitter_account} ADD followers_count int
* ALTER TABLE {twitter_account} ALTER followers_count SET default 0
* UPDATE {twitter_account} SET followers_count = 0
* Failed: ALTER TABLE {twitter_account} ALTER followers_count SET NOT NULL

Update #6002

* UPDATE {system} SET weight = 3 WHERE name = 'twitter'

Update #6003

* ALTER TABLE {twitter} DROP PRIMARY KEY
* ALTER TABLE {twitter} CHANGE `twitter_id` `twitter_id` BIGINT unsigned NOT NULL, ADD PRIMARY KEY (twitter_id)

Update #6004

* ALTER TABLE {twitter} DROP INDEX screen_name
* ALTER TABLE {twitter} CHANGE `screen_name` `screen_name` VARCHAR(255) NOT NULL DEFAULT '', ADD INDEX screen_name (screen_name)
* ALTER TABLE {twitter_user} DROP INDEX screen_name
* ALTER TABLE {twitter_user} DROP PRIMARY KEY
* ALTER TABLE {twitter_user} CHANGE `screen_name` `screen_name` VARCHAR(255) NOT NULL DEFAULT '', ADD PRIMARY KEY (uid, screen_name), ADD INDEX screen_name (screen_name)

After that, my main page was showing the following error box:

user warning: Unknown column 'twitter_account.uid' in 'on clause' query: SELECT COUNT(*) FROM (SELECT twitter.twitter_id AS twitter_id FROM twitter twitter LEFT JOIN twitter_account twitter_account ON twitter.screen_name = twitter_account.screen_name LEFT JOIN users users ON twitter_account.uid = users.uid WHERE (twitter_account.protected = 0) AND (users.uid = 1) ) count_alias in /sites/all/modules/views/includes/view.inc on line 729.
user warning: Unknown column 'twitter_account.uid' in 'on clause' query: SELECT twitter.twitter_id AS twitter_id, twitter.text AS twitter_text, twitter.created_time AS twitter_created_time FROM twitter twitter LEFT JOIN twitter_account twitter_account ON twitter.screen_name = twitter_account.screen_name LEFT JOIN users users ON twitter_account.uid = users.uid WHERE (twitter_account.protected = 0) AND (users.uid = 1) ORDER BY twitter_created_time DESC LIMIT 0, 5 in /sites/all/modules/views/includes/view.inc on line 755.

You should either check this or mention in the release notes that there currently seems to be no update path.

Thanks!