I have a really critical problem and would appreciate any assistance regarding corrupt Sqlite3 database file. Recently, power went off abruptly on a PC running GnuCash accounting software (Version 2.3 for Windows). The database back-end configuration is for Sqlite3. I managed to recover the sqlite3 database file and I can see all the records on the table named entries, which stores accounting entries, when I open the file in a binary text editor like notepad. However, when opened with GnuCash or an SQLite database editor, the table entries is only created but not populated. I have not used SQLite before and would like to know whether such a file can be fixed. I have run the "PRAGMA integrity_check" command, which reveals no errors, but I am unable to access this data in a meaningful format. This really should be an issue for GnuCash forum but I also read sqlite3 databases could have issues in sudden power losses so I decided to pose it to the db community
