SQL logic error

RemoteUids already exists? 7:42:18 PM [email protected] [POP3]  Connecting: To [email protected]
7:42:21 PM [email protected] [POP3]  Connected: To [email protected]
7:42:23 PM   System.Data.SQLite.SQLiteException (0x80004005): SQL logic error or missing database
7:42:23 PM table "RemoteUids" already exists
7:42:23 PM    at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)
7:42:23 PM    at System.Data.SQLite.SQLiteCommand.BuildNextCommand()
7:42:23 PM    at System.Data.SQLite.SQLiteCommand.GetStatement(Int32 index)
7:42:23 PM    at System.Data.SQLite.SQLiteDataReader.NextResult()
7:42:23 PM    at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
7:42:23 PM    at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
7:42:23 PM    at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery(CommandBehavior behavior)
7:42:23 PM    at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
7:42:23 PM    at MailClient.Protocols.Pop3.Pop3Account.CheckUids(IEnumerable`1 uidsList)
7:42:23 PM    at MailClient.Protocols.Pop3.Pop3ReceiveCommand.Execute(WorkerStatus status)
7:42:23 PM    at MailClient.Commands.Command.Process(WorkerStatus status)

Hi Dave.

I have an idea, but was hoping someone might have a better option. It might be a problem with the database, and the easiest way to check that is to delete the database and start again. Of course that is not so easy with POP3 because the messages are only saved locally, so deleting the database will delete the messages.

There are two things you can do; export the messages and start with a new database, or move the messages to Local Folders and remove the account from eM Client then add it again.

Whatever you do, make a backup before you do anything.