Database crashes upon startup everytime

1

I keep getting this error. I have tried reinstallig em client. However, everytime I start, it goes through the database checks with no problem but then crashes.

System.Data.SQLite.SQLiteException: The database file is locked
database is locked
at System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt)
at System.Data.SQLite.SQLiteDataReader.NextResult()
at System.Data.SQLite.SQLiteDataReader…ctor(SQLiteCommand cmd, CommandBehavior behave)
at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
at System.Data.SQLite.SQLiteConnection.Open()
at DbRepair.DbTools.OpenConnection(String fileName)
at DbRepair.Form1.CheckCorruption()
at DbRepair.Form1.Check(Object state)

2

Download this and try: http://www.emclient.com/tools/DbRepai…
If the problem persist, you may need to delete the database and start fresh. Database location:
C:\Users%Current User%\AppData\Roaming\eM Client (Vista/Win7)
C:\Documents and Settings%Current User%\Application Data\eM Client (XP)

3

It did not work. I had tried that before. Are you saying that I should just delete years worth of emails and start over?

4

If you have the pro license, I suppose you can ask them to analyse the database and see if they can recovered it. But if you didn’t have any back-ups, there’s not much you can do.

5

I figured out one solution to recovering my emails. I was wondering if the problem occurred through receiving emails. So, after getting the application error message, I would leave the error message open but I am able to still access the menu. I went into the settings and changed the setting so that it would not check my email upon startup. After the program restarted, I did not get the error message as long as I did not do a receive. I was then able to export all my emails and contacts.

6

Nice! Do you have web access to see what kind of mail get the database corrupt? It would be useful to send it to E&S to analyse and fix the issue.

7

Well, I tried the repair and got a si,ilar essage:

System.Data.SQLite.SQLiteException: File opened that is not a database file
file is encrypted or is not a database
at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)
at System.Data.SQLite.SQLiteCommand.BuildNextCommand()
at System.Data.SQLite.SQLiteCommand.GetStatement(Int32 index)
at System.Data.SQLite.SQLiteDataReader.NextResult()
at System.Data.SQLite.SQLiteDataReader…ctor(SQLiteCommand cmd, CommandBehavior behave)
at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
at System.Data.SQLite.SQLiteConnection.Open()
at DbRepair.DbTools.OpenConnection(String fileName)
at DbRepair.Form1.CheckCorruption()
at DbRepair.Form1.Check(Object state)

I cannot find the database, given the location in your answer.

I un-installed eM Client and re-installed it. No improvement. The same messages.

I like this program for e-mail. I sure don’t want to use that other one.

Michael

8

It the database, not the program that got corrupt. Re-installing won’t help. These path are the default database location, unless you changed them. And the %Current User% means it your username under Windows, it does not mean a directory named %Current User%.

9

As the ‘repair’ did not work I tried the next reasonable thing, hoping to be able to start fresh.

I understand %Current User% means what ever User I am. I have done a Print Screen and hope you can sort it out. Please have a look at it.

Thanks again for the assistance.

Michael

10

Application data is hidden by default in Windows. Enable view hidden files in the folder setting, or type in manually in the address bar would also work.

11

Hello,
you have to show hidden files and folders.
http://www.bleepingcomputer.com/tutor…
I hope this will help.

Best regards,

George Wilson
eM Client

̈

12

OK! After chasing around in manuals to find out how to view ‘Hidden’ files and folders, I found eM Client. Before I deleted anything I copied the Contacts Index and file to another drive. Deleted eM Client and reinstalled everything, copied the indexes back and now I have a running system. Lost all my old e-mail but, can’t have everything. I did manage to save my contacts.

Thanks for the help. I appreciate the fact that you have to deal with old farts like me - we are rather slow. Things have changed in the last fifteen years since I retired from all this stuff.

Michael