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