User warning: Unknown column 'modified' in 'field list'

Some more information:

The following queries were executed
chatroom module
Update #6201

* ALTER TABLE {chatroom} RENAME TO {chatroom_old_version}
* ALTER TABLE {chatroom_ban_list} RENAME TO {chatroom_ban_list_old_version}
* ALTER TABLE {chatroom_chat} RENAME TO {chatroom_chat_old_version}
* ALTER TABLE {chatroom_msg} RENAME TO {chatroom_msg_old_version}
* ALTER TABLE {chatroom_online_list} RENAME TO {chatroom_online_list_old_version}
* CREATE TABLE {chatroom} ( `nid` INT NOT NULL, `poll_freq` INT NOT NULL DEFAULT 1000, `idle_freq` INT NOT NULL DEFAULT 60000, `kicked_out_message` LONGTEXT DEFAULT NULL, `banned_message` LONGTEXT DEFAULT NULL, `module` VARCHAR(255) DEFAULT 'chatroom', `previous_messages_display_count` INT DEFAULT 20, `profile_picture` INT DEFAULT 0, `imagecache_preset` VARCHAR(255) DEFAULT NULL, `max_users` INT DEFAULT 0, PRIMARY KEY (nid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */
* CREATE TABLE {chatroom_ban_list} ( `crbid` INT unsigned NOT NULL auto_increment, `nid` INT NOT NULL, `uid` INT NOT NULL DEFAULT 0, `admin_uid` INT NOT NULL, `modified` INT NOT NULL DEFAULT 0, PRIMARY KEY (crbid), INDEX admin_uid (admin_uid), INDEX nid (nid), INDEX uid (uid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */
* CREATE TABLE {chatroom_chat_ban_list} ( `ccbid` INT unsigned NOT NULL auto_increment, `nid` INT NOT NULL, `uid` INT NOT NULL, `admin_uid` INT NOT NULL, `modified` INT NOT NULL DEFAULT 0, PRIMARY KEY (ccbid), INDEX admin_uid (admin_uid), INDEX nid (nid), INDEX uid (uid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */
* CREATE TABLE {chatroom_chat_kicked_list} ( `cckid` INT unsigned NOT NULL auto_increment, `nid` INT NOT NULL, `uid` INT NOT NULL, `sid` VARCHAR(255) NOT NULL DEFAULT '', `admin_uid` INT NOT NULL, `modified` INT NOT NULL DEFAULT 0, PRIMARY KEY (cckid), INDEX admin_uid (admin_uid), INDEX nid (nid), INDEX uid (uid), INDEX sid (sid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */
* CREATE TABLE {chatroom_chat} ( `nid` INT NOT NULL, `crid` INT NOT NULL DEFAULT 0, `poll_freq` INT NOT NULL DEFAULT 1000, `idle_freq` INT NOT NULL DEFAULT 60000, `kicked_out_message` LONGTEXT DEFAULT NULL, `banned_message` LONGTEXT DEFAULT NULL, `module` VARCHAR(255) DEFAULT 'chatroom', `previous_messages_display_count` INT DEFAULT 20, `when_archived` INT DEFAULT NULL, `profile_picture` INT DEFAULT 0, `private` INT DEFAULT 0, `imagecache_preset` VARCHAR(255) DEFAULT NULL, `max_users` INT DEFAULT 0, PRIMARY KEY (nid), INDEX crid (crid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */
* CREATE TABLE {chatroom_chat_user} ( `nid` INT NOT NULL, `uid` INT NOT NULL, INDEX nid (nid), INDEX uid (uid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */
* CREATE TABLE {chatroom_msg} ( `cmid` INT unsigned NOT NULL auto_increment, `ccid` INT NOT NULL DEFAULT 0, `uid` INT NOT NULL DEFAULT 0, `msg_type` VARCHAR(64) NOT NULL, `msg` LONGTEXT DEFAULT NULL, `sid` VARCHAR(64) NOT NULL, `recipient_uid` INT NOT NULL DEFAULT 0, `modified` INT NOT NULL DEFAULT 0, PRIMARY KEY (cmid), INDEX ccid (ccid), INDEX modified (modified), INDEX recipient_uid (recipient_uid), INDEX sid (sid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */
* CREATE TABLE {chatroom_chat_online_list} ( `ccid` INT NOT NULL, `uid` INT NOT NULL DEFAULT 0, `guest_id` INT NOT NULL DEFAULT 0, `sid` VARCHAR(64) NOT NULL, `away` INT DEFAULT 0, `last_seen_time` INT NOT NULL DEFAULT 0, PRIMARY KEY (ccid, sid), INDEX uid (uid), INDEX guest_id (guest_id) ) /*!40100 DEFAULT CHARACTER SET UTF8 */
* CREATE TABLE {chatroom_chat_invite} ( `cciid` INT unsigned NOT NULL auto_increment, `nid` INT NOT NULL, `inviter_uid` INT NOT NULL DEFAULT 0, `invitee_uid` INT NOT NULL DEFAULT 0, `notified` INT NOT NULL DEFAULT 0, `accepted` INT NOT NULL DEFAULT 0, PRIMARY KEY (cciid), INDEX inviter_uid (inviter_uid), INDEX invitee_uid (invitee_uid), INDEX nid (nid), INDEX notified (notified), INDEX accepted (accepted) ) /*!40100 DEFAULT CHARACTER SET UTF8 */

Hmm. It should not do 1.x -> 2.x update since I was already using 2.5. Maybe something went wrong with my previous update 1.x -> 2.5...

I tried to clean up my chatroom installation by disabling and removing the chatroom module and re-installing. However after disabling and removing the module, these tables still exist in the database:

• drupal_chatroom_ban_list_old_version
• drupal_chatroom_chat_old_version
• drupal_chatroom_msg_old_version
• drupal_chatroom_old_version
• drupal_chatroom_online_list_old_version