cannot load db file

2 posts / 0 new

Thu, 05/17/2018 - 12:54

g_m_m

cannot load db file

Hi,

I'm running into a new issue. I'm trying to open a database file to continue work on a project, and after it "loads" the GUI immediately crashes and the following message appears in the terminal:

SQL Error: no such table: REFINEMENT_DETAILS_38
Trying to execute the following command :-

SELECT AVERAGE_OCCUPANCY, ESTIMATED_RESOLUTION, RECONSTRUCTED_VOLUME_ASSET_ID FROM REFINEMENT_DETAILS_38
From core/database.cpp:48
int Database::Prepare(wxString, sqlite3_stmt **)
Aborted (core dumped)

During the last manual refine run I lost internet connection so the GUI crashed, so this may have something to do with it. Usually hitting "override" gets around this but not in this case.

Any suggestions on how to fix this?

Many thanks in advance,

-Greg

Thu, 05/17/2018 - 21:00

timgrant

Hi Greg,

That is weird - this shouldn't really be able to happen - I will look into it.

You should be able to fix it by running the following commands on your database (back it up first in case something goes wrong) :-

sqlite3 name_of_databse.db "delete from refinement_list where refinement_id=38;"

The following lines need to be run once for each class, if you only had 1 class then just copy the lines below. If this was being run with multiple classes, you will need to drop each result, so run the lines once for each class, but replace the 1 with 2,3,4 etc up to the number of classes :-

sqlite3 name_of_database.db "drop table refinement_result_38_1;"

sqlite3 name_of_database.db "drop table refinement_angular_distribution_38_1;"

sqlite3 name_of_database.db "drop table refinement_resolution_statistics_38_1;"

Thanks,

Tim