Radarspotting
Mode-S Software => Basestation => Topic started by: Pipo on May 04, 2022, 06:03:42 PM
Today i was doing some input on blank ModeS and sometimes when i press OK i'm getting this error, it looks like the database is then lockt or some thing"Dataset not in edit or insert mode"
App: BaseStation Reporter
Version: 1.0.0.29
ERROR(S)
Occurred : 18:43:25.112 2022-05-04
Error : EDatabaseError - AircraftSQLite3Query: Dataset not in edit or insert mode
Previous : O-WriteToDebugMemo | I-WriteToDebugMemo | O-AircraftDataSourceDataChange | O-UpdateQueryTotals | I-UpdateQueryTotals | I-AircraftDataSourceDataChange | O-AircraftDataSourceDataChange | O-UpdateQueryTotals | I-UpdateQueryTotals | I-AircraftDataSourceDataChange | O-AircraftDataSourceDataChange | O-UpdateQueryTotals | I-UpdateQueryTotals | I-AircraftDataSourceDataChange | O-AircraftDataSourceDataChange | O-UpdateQueryTotals | I-UpdateQueryTotals | I-AircraftDataSourceDataChange | O-AircraftDataSourceDataChange | O-UpdateQueryTotals | I-UpdateQueryTotals | I-AircraftDataSourceDataChange | O-AircraftDataSourceDataChange | O-UpdateQueryTotals | I-UpdateQueryTotals | I-AircraftDataSourceDataChange | O-AircraftDataSourceDataChange | O-UpdateQueryTotals | I-UpdateQueryTotals | I-AircraftDataSourceDataChange
Any idea how i can solve this?
Looks like the DB is corrupted.
You could try running a DB check such as PRAGMA Integrity_Check
This should report OK. If it does then run:
Vacuum
to repack and reindex the db.
Use an SQL editor.
On a backup copy of the DB!