On Sun, Jan 04, 2004 at 05:03:54PM +0200, Igor Olemskoi wrote: > I tried to upgrade 1.x to 2.x using sql script by Christian G. Warden, but > I got an error when I tried to access my mailbox.
You're probably just missing the shared mailbox tables which were added after I wrote that migration script. DROP TABLE IF EXISTS shared_mailbox; CREATE TABLE shared_mailbox ( id bigint(21) NOT NULL auto_increment, mailbox_id bigint(21) NOT NULL default '0', maxmail_size bigint(21) NOT NULL default '0', curmail_size bigint(21) NOT NULL default '0', PRIMARY KEY (id), KEY (mailbox_id), FOREIGN KEY (`mailbox_id`) REFERENCES `mailboxes` (`mailbox_idnr`) ON DELETE CASCADE ) TYPE=InnoDB; DROP TABLE IF EXISTS shared_mailbox_access; CREATE TABLE shared_mailbox_access ( id bigint(21) NOT NULL auto_increment, shared_mailbox_id bigint(21) NOT NULL default '0', user_id bigint(21) NOT NULL default '0', lookup_flag tinyint(1) NOT NULL default '0', read_flag tinyint(1) NOT NULL default '0', insert_flag tinyint(1) NOT NULL default '0', write_flag tinyint(1) NOT NULL default '0', is_subscribed tinyint(1) unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY (shared_mailbox_id), KEY (user_id), FOREIGN KEY (`shared_mailbox_id`) REFERENCES `shared_mailbox` (`id`) ON DELETE CASCADE, FOREIGN KEY (`user_id`) REFERENCES `users` (`user_idnr`) ON DELETE CASCADE ) TYPE=InnoDB; If that's not it, post the error you're getting at debug level 5. xn
