Error search database

Good morning all.

I get this message when I search my database. How do I solve this?

Kind regards,

Robert

Hi Robert,

“Dump / Restore”.

There are long explanations in the german section; this has to be translated.

Reasons (written by Torben):

  • Power failure
  • Windows crash
  • Database is stored on a network drive (not recommended)
  • Hardware error

So so that’s something I couldn’t do. I’m not very well known in this kind of thing.

So the bottom line is that I have to duplicate my database first?

  1. Backup the database file (*.mldb).
  2. Copy sqlite3.exe to the directory of the database backup.
    The sqlite3.exe is included in the mAirList directory: C: > programs (x86) > mAirList [Version].
  3. Start sqlite3.exe.

In the new window enter the following commands, each followed by <Enter>:

.open [database name].mldb
.output dump.txt
.dump
.quit

Now you have a file called dump.txt.

  1. Please create a new database with a new name.
    The old [database name].mldb must be moved to another directory or renamed.

  2. Start sqlite3.exe again.

In the new window enter the following commands, each followed by <Enter>:

.open [new database].mldb
.read dump.txt
.quit

Your new database should work now.
If you see any error messages: Don’t panic! In the best case these are some database entrys that could not be saved.

This is my simple translation of Torbens solution linked before.

Uli nobbe

Thanks for your help. That I try this option if I succeed haha.

Kind regards,
Robert