Imported emails invisible

[olekaas]

Hello,

After migrating and porting mails to zimbra one of the accounts is missing a lot of mails from the old server. An error when using imapsync must have gone unobserved. The license for the old server is expired, so I retrieved the mails from the backup (.eml files). In the preference tab I'd noticed that you could import an account as a tgz file. I prepared a tgz file with the directory structure intact and uploaded the file with only "mail" checked. After hitting the "Import" button I went home for dinner - thinking that maybe I should have tried with a little less than a 1.2 GB archive.... Anyway, zimbra has processed the archive and the directory structure is present in the folder I selected for import. The directory displays all the mails as unread - but when i select a folder, the index come up empty. Tried to reindex with no success. Snooping around in the message store, the messages seems to be there.

Any ideas? what to look for?

/Ole

[olekaas]

Connecting to the account with Outlook (using imap), I can see all the messages. But they are all marked for deletion and flagged. Removing the deletion makes them visible in the web client. There are close to 20.000 mails arranged in more than 200 folders/subfolders. Is there a way to recursively remove the 'mark for deletion', 'mark as read', and 'unflag' all mails in a subfolder?

/Ole

[uxbod]

[SOLVED] Message count incorrect after multiple runs of IMAPSync using --delete2 &amp

[olekaas]

Ok - getting my hands dirty with sql queries...

With a little help from this page:

http://wiki.zimbra.com/index.php?tit...base_structure

..and a lot of help from pure guessing - I ran this query:

UPDATE mail_item SET flags = '0', unread = '0' WHERE folder_id > '7437' AND type = '5';

Assumptions (the mother of all f***ups): type '5' seems to be a email message. folder_id is the folder the item is placed in. So selecting anything that is placed in a folder created after the folder created for import and type 5, will select all the inmported emails. The 'unread' seems obvious - so clearing that one. 'flags'...hmm... not sure what the numbers mean - and I can't find any docs about it. A lot of the mails was created wit values 484 and 486. After altering the status of the mails in outlook, the value was changed to 68 (from 484). I decided to clear the flags and put '0' in there. Now the mails can be read.

Still some of the folders is displayed as if there are unread messages in them in the webclient. Outlook seems fine.

/Ole