Radarspotting

Mode-S Software => Basestation => Topic started by: Pipo on May 04, 2022, 06:03:42 PM

Title: Reporter Error when editing blank ModeS
Post 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?
Title: Re: Reporter Error when editing blank ModeS
Post by: Anmer on May 04, 2022, 07:16:48 PM
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!