Results 1 to 2 of 2

Thread: Mass update of "Received Date"

  1. #1
    Join Date
    Oct 2005
    Rep Power

    Default Mass update of "Received Date"

    After importing thousands of messages from a pop server, they display in Zimbra mail with a "Received Date" set to the date they were imported, rather than the original received date.

    I'm sure there was a better way to import the messages that would have preserved the info (IMAP wasn't an option), but there it is.

    So I have a need to alter the "Received Date" displayed in Zimbra Mail to match the sent date on the messages (which will be close enough). I assume this means a sql update script. But I'm having trouble guessing what columns in which tables need to be tweaked.

    Any help appreciated!

  2. #2
    Join Date
    Aug 2005
    Rep Power


    You need to update the DATE column of the the appropriate MBOXGROUPnnn.MAIL_ITEM table. Value is UNIX time (seconds since the epoch).

    Note that the message files themselves are stored on the filesystem, not in the database.
    Bugzilla - Wiki - Downloads - Before posting... Search!

Similar Threads

  1. Update Received Date in Folder-Listing
    By Oswald-Kolle in forum Installation
    Replies: 25
    Last Post: 08-21-2007, 04:21 PM
  2. i am so tired for zimbra update too quickly!!
    By nxzwt in forum Administrators
    Replies: 7
    Last Post: 05-08-2007, 09:47 AM
  3. Install on FC3 (or 4)
    By scottpledger in forum Installation
    Replies: 2
    Last Post: 10-07-2005, 11:49 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