Errors during mail sync

Frequently Asked Questions
1

I have been using em client free version for several years. I recently started to get the following 2 errors connecting to email server:
Error 1

  • “an item with the same key has already been added”  after that on the subsequent refresh attempt this error shows up
    Error 2 on Refresh attempt
  • SQL logic error or missing database table “Remote UIDs” already exists

I have already checked the FAQs and followed the process to rename the em client folder in c:\user\name\appdata\roaming\em client suggested in FAQs and then restarted the app and completed the MENU TOOLS ACCOUNTS process to complete the setup using a POP account.

On the first attempt to sync with the server, all appears to work fine…mail downloads as expected. On the next sync cycle after the 10 minute wait, error 1 again shows up and during the next 10 minute refresh the 2nd error shows up and keeps showing up every 10 minutes after that.

Here is the log from that process:

10:08:24 AM Online state: changed to online due to NetworkAvailability 
10:08:24 AM Cox (xxxxxxxx) [POP3]  Connecting: To Cox (xxxxxxx)
10:08:26 AM Cox (xxxxxxxx) [POP3]  Connected: To Cox (xxxxxxxx)
10:08:27 AM Cox (xxxxxxx) [POP3]  Downloading messages: From Cox (xxxxxxx)
10:10:47 AM Cox (xxxxxxx) [POP3]  Disconnected: From Cox (xxxxxxx)
10:10:47 AM Cox (xxxxxxx) [POP3]  Disconnected: Done
10:18:24 AM Cox (xxxxxxx) [POP3]  Connecting: To Cox (xxxxxxx)
10:18:25 AM Cox (xxxxxxx) [POP3]  Connected: To Cox (xxxxxxx)
10:18:25 AM   System.ArgumentException: An item with the same key has already been added.
10:18:25 AM    at System.ThrowHelper.ThrowArgumentException(ExceptionResource resource)
10:18:25 AM    at System.Collections.Generic.Dictionary2.Insert(TKey key, TValue value, Boolean add) 10:18:25 AM    at MailClient.Protocols.Pop3.Pop3Account.CheckUids(IEnumerable1 uidsList)
10:18:25 AM    at MailClient.Protocols.Pop3.Pop3ReceiveCommand.Execute(WorkerStatus status)
10:18:25 AM    at MailClient.Commands.Command.Process(WorkerStatus status)
10:28:24 AM Cox (xxxxxxx) [POP3]  Connecting: To Cox (xxxxxxx)
10:28:25 AM Cox (xxxxxxx) [POP3]  Connected: To Cox (xxxxxxx)
10:28:26 AM   System.Data.SQLite.SQLiteException (0x80004005): SQL logic error or missing database
10:28:26 AM table “RemoteUids” already exists
10:28:26 AM    at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)
10:28:26 AM    at System.Data.SQLite.SQLiteCommand.BuildNextCommand()
10:28:26 AM    at System.Data.SQLite.SQLiteCommand.GetStatement(Int32 index)
10:28:26 AM    at System.Data.SQLite.SQLiteDataReader.NextResult()
10:28:26 AM    at System.Data.SQLite.SQLiteDataReader…ctor(SQLiteCommand cmd, CommandBehavior behave)
10:28:26 AM    at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
10:28:26 AM    at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery(CommandBehavior behavior)
10:28:26 AM    at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
10:28:26 AM    at MailClient.Protocols.Pop3.Pop3Account.CheckUids(IEnumerable`1 uidsList)
10:28:26 AM    at MailClient.Protocols.Pop3.Pop3ReceiveCommand.Execute(WorkerStatus status)
10:28:26 AM    at MailClient.Commands.Command.Process(WorkerStatus status)

Please advise how I can eliminate these problems
Thank you in advance

Bob Bauer

2

What changed that started the errors? Was it an upgrade of the eM Client software, some account settings change you made in eM Client, or did something change over at your provider?

Who is your email provider?

3

Nothing that I am aware of changed. My provider is Cox Cable. 2 people in the house share the email address. 1 uses Windows Live Mail set up as IMAP, on 1 PC, I use the free eM Client set up as POP3 on another PC.
We’ve been using this set up for several years without issue. 1 morning I couldn’t log in and started getting the error string above. The other continues to work as in the past. 
I’ve changed the eM Client set up to IMAP so we can get things done, however because of the way IMAP works, it is a lot harder to get the mail done. I’d go back to the previous set up if there was away to get it to work.
Any thoughts would be helpful.
Thank you.

4

Well, IMAP syncs the server data with one or many computers. That is the ideal setup if you are sharing the same email account on more than one computer. Sometimes when an email address is shared, the one user doesn’t want the read flags to be applied to their copy of the messages. In that case the best option is to have the original email forwarded to separate email accounts so each user has an individual copy. But still, IMAP is the best solution as you will both share the same Sent folder (which is not possible with POP3) and any folders you create will be synced on both computers.

It may be that this issue is because the IMAP computer has changed the server data and now the POP3 one is having difficulty as it has already downloaded the same message.

Other than that, I am not sure Robert.