Results 1 to 4 of 4

Thread: Imported emails invisible

  1. #1
    olekaas is offline Junior Member
    Join Date
    Jul 2009
    Posts
    6
    Rep Power
    5

    Default Imported emails invisible

    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

  2. #2
    olekaas is offline Junior Member
    Join Date
    Jul 2009
    Posts
    6
    Rep Power
    5

    Default

    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

  3. #3
    uxbod's Avatar
    uxbod is offline Moderator
    Join Date
    Nov 2006
    Location
    UK
    Posts
    8,016
    Rep Power
    24

  4. #4
    olekaas is offline Junior Member
    Join Date
    Jul 2009
    Posts
    6
    Rep Power
    5

    Default

    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

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. default path for emails
    By adeelbashir in forum General Questions
    Replies: 1
    Last Post: 03-23-2009, 01:34 PM
  2. Incorrect dates on inbox emails
    By owen howlett in forum Error Reports
    Replies: 4
    Last Post: 03-11-2009, 09:42 PM
  3. Discussion: Printing Emails
    By Nox in forum /etc
    Replies: 1
    Last Post: 09-02-2008, 01:05 PM
  4. Replies: 2
    Last Post: 09-21-2007, 07:47 AM
  5. emails don't show up in inbox in browser
    By pstelzer in forum Installation
    Replies: 10
    Last Post: 12-13-2005, 10:21 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •