When using ActiveDirectory home folders redirection (to network share) in Group Policy, EMClient SQLite Database becomes totally corrupted and unrecoverable.
USAGE: User sets up EMClient on PC#1. User may or may not log off of PC#1 and goes to PC#2 – logs in – loads EMClient. BOOM!
As a developer of over 30 years, all I can say is… WHY?
I recommend EMClient review and correct file locking/sharing operations in EMClient.
Personally, I don’t know what I’m going to do about this. Probably uninstall, permanently.
No excuse for this. Even the original Outlook Express from 1998 handled this situation with ease. I have a high-performance, multiuser email and calendar server with a single user, single workstation client.
(I even have multiple Postgres, MySQL, Oracle, and MS SQLServer database servers that could be used instead of SQLite.)
SQLite Documentation…
Backwards Compatibility
The database file format is unchanged for WAL mode. However, the WAL file and the wal-index are new concepts and so older versions of SQLite will not know how to recover a crashed SQLite database that was operating in WAL mode when the crash occurred. To prevent older versions of SQLite from trying to recover a WAL-mode database (and making matters worse) the database file format version numbers (bytes 18 and 19 in the database header) are increased from 1 to 2 in WAL mode. Thus, if an older version of SQLite attempts to connect to an SQLite database that is operating in WAL mode, it will report an error along the lines of “file is encrypted or is not a database”.
08/21/2014 14:25:53 1 no such table: mail_fti.SubjectIndex_stat
08/21/2014 14:25:53 1 no such table: mail_fti.AddressIndex_stat
08/21/2014 14:25:53 1 no such table: mail_fti.LocalMailsIndex3_stat
08/22/2014 19:00:06 1 no such table: mail_fti.SubjectIndex_stat
08/22/2014 19:00:06 1 no such table: mail_fti.AddressIndex_stat
08/22/2014 19:00:11 1 no such table: mail_fti.LocalMailsIndex3_stat
08/22/2014 19:18:54 1 no such table: mail_fti.SubjectIndex_stat
08/22/2014 19:18:54 1 no such table: mail_fti.AddressIndex_stat
08/22/2014 19:19:13 1 no such table: mail_fti.LocalMailsIndex3_stat
08/22/2014 19:21:19 1 no such table: mail_fti.SubjectIndex_stat
08/22/2014 19:21:19 1 no such table: mail_fti.AddressIndex_stat
08/22/2014 19:21:19 1 no such table: mail_fti.LocalMailsIndex3_stat
08/22/2014 20:05:43 1 no such table: mail_fti.SubjectIndex_stat
08/22/2014 20:05:43 1 no such table: mail_fti.AddressIndex_stat
08/22/2014 21:05:49 1 no such table: mail_fti.SubjectIndex_stat
08/22/2014 21:05:49 1 no such table: mail_fti.AddressIndex_stat
08/22/2014 21:05:56 1 no such table: mail_fti.LocalMailsIndex3_stat
08/25/2014 14:02:19 1 no such table: mail_fti.SubjectIndex_stat
08/25/2014 14:02:19 1 no such table: mail_fti.AddressIndex_stat
08/25/2014 14:42:34 1 no such table: mail_fti.LocalMailsIndex3_stat
08/25/2014 15:32:38 1 no such table: mail_fti.SubjectIndex_stat
08/25/2014 15:32:38 1 no such table: mail_fti.AddressIndex_stat
08/25/2014 15:32:38 1 no such table: mail_fti.LocalMailsIndex3_stat
08/26/2014 12:59:52 1 no such table: mail_fti.SubjectIndex_stat
08/26/2014 12:59:52 1 no such table: mail_fti.AddressIndex_stat
08/26/2014 12:59:57 1 no such table: mail_fti.LocalMailsIndex3_stat
08/26/2014 15:29:53 1 no such table: mail_fti.SubjectIndex_stat
08/26/2014 15:29:53 1 no such table: mail_fti.AddressIndex_stat
08/26/2014 15:29:59 1 no such table: mail_fti.LocalMailsIndex3_stat
08/26/2014 20:39:39 1 no such table: mail_fti.LocalMailsIndex3_stat
08/26/2014 20:39:47 1 no such table: mail_fti.SubjectIndex_stat
08/26/2014 20:39:47 1 no such table: mail_fti.AddressIndex_stat
08/27/2014 14:29:12 1 no such table: mail_fti.SubjectIndex_stat
08/27/2014 14:29:12 1 no such table: mail_fti.AddressIndex_stat
08/27/2014 14:29:17 1 no such table: mail_fti.LocalMailsIndex3_stat
08/27/2014 16:21:31 1 no such table: mail_fti.SubjectIndex_stat
08/27/2014 16:21:31 1 no such table: mail_fti.AddressIndex_stat
08/27/2014 16:21:35 1 no such table: mail_fti.LocalMailsIndex3_stat
08/27/2014 17:37:13 1 no such table: mail_fti.SubjectIndex_stat
08/27/2014 17:37:13 1 no such table: mail_fti.AddressIndex_stat
08/27/2014 17:37:52 1 no such table: mail_fti.LocalMailsIndex3_stat
08/27/2014 20:37:10 1 no such table: mail_fti.SubjectIndex_stat
08/27/2014 20:37:10 1 no such table: mail_fti.AddressIndex_stat
08/27/2014 20:37:19 1 no such table: mail_fti.LocalMailsIndex3_stat
08/27/2014 21:16:15 1 no such table: mail_fti.SubjectIndex_stat
08/27/2014 21:16:16 1 no such table: mail_fti.AddressIndex_stat
08/27/2014 21:16:16 1 no such table: mail_fti.LocalMailsIndex3_stat
08/28/2014 14:05:54 1 no such table: mail_fti.SubjectIndex_stat
08/28/2014 14:05:54 1 no such table: mail_fti.AddressIndex_stat
08/28/2014 14:06:34 1 no such table: mail_fti.LocalMailsIndex3_stat
08/28/2014 15:37:02 1 no such table: mail_fti.SubjectIndex_stat
08/28/2014 15:37:02 1 no such table: mail_fti.AddressIndex_stat
08/28/2014 15:37:02 1 no such table: mail_fti.LocalMailsIndex3_stat
08/28/2014 21:15:10 26 file is encrypted or is not a database
08/28/2014 21:15:37 26 file is encrypted or is not a database
08/28/2014 21:15:48 26 file is encrypted or is not a database
08/28/2014 21:15:57 26 file is encrypted or is not a database
08/28/2014 21:16:04 26 file is encrypted or is not a database
08/28/2014 21:16:46 26 file is encrypted or is not a database
08/28/2014 21:17:32 26 file is encrypted or is not a database
08/28/2014 21:17:53 26 file is encrypted or is not a database
08/28/2014 21:18:04 26 file is encrypted or is not a database
08/28/2014 21:18:09 26 file is encrypted or is not a database
08/28/2014 21:19:18 26 file is encrypted or is not a database
08/28/2014 21:21:33 26 file is encrypted or is not a database
08/28/2014 21:23:12 26 file is encrypted or is not a database
08/28/2014 21:38:17 26 file is encrypted or is not a database
08/28/2014 21:50:32 26 file is encrypted or is not a database
08/28/2014 21:50:56 26 file is encrypted or is not a database
08/28/2014 21:55:24 26 file is encrypted or is not a database