Originally Posted by Shinto

As far as I can tell, and from my experience, the trigger will always work, just not right away. If your new-mail notification goes off and you immediately open the e-mail application, you probably won't see the blue circles. If you wait a while, perhaps another e-mail update cycle or two, they'll probably be there.

I'm guessing this is due to the write-ahead-log DB checkpoints, and my attempts to force quicker updates (through PRAGMA wal_autocheckpoint) don't seem to stick. So without a true code fix, I'm afraid this may be as good as it gets.



Yes, by running an UPDATE command in sqlite3. This is what such an operation would look like:

Code:

~ $ /usr/bin/sqlite3 /home/user/.qmf/database/qmailstore.db
SQLite version 3.7.7 2011-06-23 19:49:22               
Enter ".help" for instructions                         
Enter SQL statements terminated with a ";"             
sqlite> UPDATE mailmessages SET status=19137 WHERE status IN (18496,18497);
sqlite> .quit
~ $