Corrupted database - cannot restore backup

Please fill in this bug report template:

Lexicon version: 1.5.7
Operating system (remove one): Windows

Bug description:
My lexicon database has been corrupted, probably by a power loss. I cannot seem to restore my backups (Lexicon tells me the database is corrupted and does nothing). I’ve uploaded my databse with a link to this thread. The Pragma report reads:

*** in database main ***
On tree page 7 cell 77: 2nd reference to page 2773
On tree page 7 cell 75: 2nd reference to page 2768
On tree page 7 cell 72: 2nd reference to page 2760
On tree page 7 cell 71: 2nd reference to page 2758
On tree page 7 cell 70: 2nd reference to page 2756
On tree page 7 cell 57: 2nd reference to page 2776
On tree page 7 cell 56: 2nd reference to page 2825
On tree page 7 cell 53: 2nd reference to page 2875
On tree page 7 cell 50: 2nd reference to page 2905
On tree page 7 cell 45: 2nd reference to page 2841
On tree page 7 cell 30: 2nd reference to page 2750
On tree page 7 cell 28: 2nd reference to page 2751
On tree page 7 cell 24: 2nd reference to page 2752
row 611 missing from index Track_dateModified
row 804 missing from index Track_dateModified
row 1153 missing from index Track_dateModified
row 1159 missing from index Track_dateModified
row 1433 missing from index Track_dateModified
row 1493 missing from index Track_dateModified
row 2948 missing from index Track_dateModified
row 4134 missing from index Track_dateModified
row 4654 missing from index Track_dateModified
row 4772 missing from index Track_dateModified
row 5062 missing from index Track_dateModified
row 5103 missing from index Track_dateModified
row 5123 missing from index Track_dateModified
row 5177 missing from index Track_dateModified
row 6130 missing from index Track_dateModified
row 6152 missing from index Track_dateModified
row 6187 missing from index Track_dateModified
row 6269 missing from index Track_dateModified
row 6280 missing from index Track_dateModified
row 6374 missing from index Track_dateModified
row 6377 missing from index Track_dateModified
row 6384 missing from index Track_dateModified
row 6397 missing from index Track_dateModified
row 6406 missing from index Track_dateModified
row 6423 missing from index Track_dateModified
row 6429 missing from index Track_dateModified
row 6458 missing from index Track_dateModified
row 6483 missing from index Track_dateModified
row 6517 missing from index Track_dateModified
row 6520 missing from index Track_dateModified
row 6528 missing from index Track_dateModified
row 6540 missing from index Track_dateModified
row 6579 missing from index Track_dateModified
row 6617 missing from index Track_dateModified
row 6641 missing from index Track_dateModified
row 6653 missing from index Track_dateModified
row 6665 missing from index Track_dateModified
row 6668 missing from index Track_dateModified
row 6688 missing from index Track_dateModified
row 6706 missing from index Track_dateModified
row 6707 missing from index Track_dateModified
wrong # of entries in index Track_title
wrong # of entries in index Track_artist
wrong # of entries in index Track_albumTitle
wrong # of entries in index Track_key
wrong # of entries in index Track_genre
wrong # of entries in index Track_color
wrong # of entries in index Track_location
wrong # of entries in index Track_bpm
wrong # of entries in index Track_rating
wrong # of entries in index Track_year
wrong # of entries in index Track_bitrate
wrong # of entries in index Track_sizeBytes
wrong # of entries in index Track_trackNumber
wrong # of entries in index Track_locationUnique
wrong # of entries in index sqlite_autoindex_Track_2
row 7317 missing from index LinkTrackPlaylist_PlaylistIdTrackId
row 7317 missing from index sqlite_autoindex_LinkTrackPlaylist_1
row 7318 missing from index LinkTrackPlaylist_PlaylistIdTrackId
row 7318 missing from index sqlite_autoindex_LinkTrackPlaylist_1
row 7319 missing from index LinkTrackPlaylist_PlaylistIdTrackId
row 7319 missing from index sqlite_autoindex_LinkTrackPlaylist_1
row 7320 missing from index LinkTrackPlaylist_PlaylistIdTrackId
row 7320 missing from index sqlite_autoindex_LinkTrackPlaylist_1
row 7321 missing from index LinkTrackPlaylist_PlaylistIdTrackId
row 7321 missing from index sqlite_autoindex_LinkTrackPlaylist_1
row 7322 missing from index LinkTrackPlaylist_PlaylistIdTrackId
row 7322 missing from index sqlite_autoindex_LinkTrackPlaylist_1
row 7323 missing from index LinkTrackPlaylist_PlaylistIdTrackId
row 7323 missing from index sqlite_autoindex_LinkTrackPlaylist_1
row 7324 missing from index LinkTrackPlaylist_PlaylistIdTrackId
row 7324 missing from index sqlite_autoindex_LinkTrackPlaylist_1
row 7325 missing from index LinkTrackPlaylist_PlaylistIdTrackId
row 7325 missing from index sqlite_autoindex_LinkTrackPlaylist_1
row 7326 missing from index LinkTrackPlaylist_PlaylistIdTrackId
row 7326 missing from index sqlite_autoindex_LinkTrackPlaylist_1
row 7327 missing from index LinkTrackPlaylist_PlaylistIdTrackId
row 7327 missing from index sqlite_autoindex_LinkTrackPlaylist_1
row 7328 missing from index LinkTrackPlaylist_PlaylistIdTrackId
row 7328 missing from index sqlite_autoindex_LinkTrackPlaylist_1
row 7329 missing from index LinkTrackPlaylist_PlaylistIdTrackId
row 7329 missing from index sqlite_autoindex_LinkTrackPlaylist_1
row 7330 missing from index LinkTrackPlaylist_PlaylistIdTrackId
row 7330 missing from index sqlite_autoindex_LinkTrackPlaylist_1
row 7331 missing from index LinkTrackPlaylist_PlaylistIdTrackId
row 7331 missing from index sqlite_autoindex_LinkTrackPlaylist_1
row 7332 missing from index LinkTrackPlaylist_PlaylistIdTrackId

You can manually restore a database by putting the main.db file in the right spot, see Lexicon database & log locations

Make sure there is no journal or wal file next to the old db file.

Check if there is a recent backup you can use in Documents/Lexicon/Backups

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.