ok, I did a fair bit of digging around in sqlitebrowser looking at folders.db in the mail/local directory. I could see the mails arriving, the deleted field changing from 0 to 1 following deleting the mail in evolution, and then the record in the table being removed following an expunge.
I also noticed a deletes table that had ~11,000 records but never cleared down. On browsing through my mailbox mail by mail I noticed one mail that had a duplicated subject/received time, and a message body saying that message 3870 in local/inbox could not be displayed as the folder was irrecoverably corrupted. I couldn't track this message down in sqlitebrowser. I've had a few more instances of this "bug", so having researched more I added a step to #3 above. 1. Set Evolution to Offline mode, exit evolution 2. Open terminal and run evolution --force-shutdown 3. cd ~/.evolution/mail 4. cp -r local local.ORIG 5. find ~/.evolution/mail/local/ -name \*.ibex.index -delete 6. find ~/.evolution/mail/local/ -name \*.ibex.index.data -delete 6a. delete ~/.evolution/mail/local/folders.db 7. restart evolution and let index files rebuild. 8. set evolution to online mode. I was wary of doing this as the database shows mails marked read etc, However, having let the index files rebuild my mailbox looked as it was before :) More interestingly the new folders.db file was only 4.5mb instead of the previous 10.1mb. Also the deletes table has vanished when I browse the database! I wonder if the error was an upgrade through the various versions? I'll update this bug report next time I get a file/folder mismatch error. -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/594351 Title: summary and folder mismatch, even after a sync -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
