Welcome back from vacation, hope you got to enjoy it, how was the weather in SanFran?
I would like to help with "patching", but ATM am busy with normal work. I will try and make an effort though...
I did this in mySQL....see anything wrong with it, other than maybe inefficiency, i.e. to delete all of a users email related data...
DELETE FROM messagedata WHERE folder_id = lngUserInBoxID; /* Now clean orphaned emails in other tables */ DELETE FROM paged_mail_store WHERE id not in (select m.bodyid from messagedata m); DELETE FROM paged_mail_store_pages WHERE blobid not in (select b.id from paged_mail_store b); DELETE FROM storeitemmetadata WHERE pid not in (select b.id from paged_mail_store b);