Mode S tweaker

[AlanM]

Hi
My first post! I downloaded the mode s tweaker last night. Two objectives first to remove some of the dead wood in the SQB, and secondly to add some new aircraft. The download went well, I can access the SQB and get lists (very simple to use) however when I hit the delete button I get: Delete of Modes aircraft "0BE00A" flights failed. Followed by Modes aircraft "0BE00A" delete failed. 0BE00A being an example mode S code I want to delete. Any ideas?

Cheers

Alan

[Anmer]

Hi Alan.  Actually your 2nd post but you're forgiven 

Can you post a screen capture of ModeSTweaker with a delete error message?  Capture the entire ModeSTweaker window if you can.

[egnx]

Alan,
can you confirm that the SQB you are using is a standard Kinetic version and has not had any modifications made to it ?

Also could use another SQLite db tool (such as SQLite Expert) to run the query:-
PRAGMA integrity_check
and let us know the result ?

Cheers
egnx

[AlanM]

Thanks for looking at this for me. So its a standard kinectic with no mods. Sorry I dont have any other app to look at the SQB, and to be honest I won't know how to run your query. Here is a screen shot of the tweaker in operation.

Cheers

Alan

[attachment deleted reduce file load]

[Anmer]

Sorry I dont have any other app to look at the SQB, and to be honest I won't know how to run your query.

Do you have a cloud drive, such as Google, where you could upload a copy of your sqb file so I can take a look at it?

[AlanM]

I have a copy of it in my one drive, will that work?

[Anmer]

I have a copy of it in my one drive, will that work?

If you can't grant me access to the file so I can download it?

Send me a PM witrh the link.

[egnx]

Let Mike have a look at it first to see if he can find anything amiss with it.

Mike, perhaps you could run a manual delete of the 0BE00A records from the Flight table and see what that does ?

If Mike can spot it fine, if not pm me with the link to the file and I willl also have a look.

Cheers
egnx

[Anmer]

Update

I've now downloaded a copy of Alan's Basestation.sqb file.

I mapped ModeSTweaker to Alan's sqb and used it to find ModeS Code:

0BE00A

Please see the attachments.

I double clicked on the returned result and selected Delete.

ModeSTweaker displayed a message:

"Aircraft with ModeS "0BE00A" has 2 flights.  Confirm delete Aircraft and Flights?"

I selected Yes and ModeSTweaker displayed a new message:

"ModeS Aircraft "0BE00A" deleted OK"

When I went to view the ModeS record a second time, ModeSTweaker displayed:

"No rows were returned by this query"

This is what I expected.

Using Basestation Reporter I was able to confirm that there was no data for ModeS 0BE00A.

However, when I used Reporter to view ModeS 0BE00A on a copy of Alan's sqb file (before I made the Delete) there were no flights associated with it?

In conclusion:

1. I cannot replicate the original issue.
2. Although ModeSTweaker reported two flights associated with code 0BE00A, Reporter didn't show any?

Perhaps Alan could retry the Delete on a copy of the sqb file he made available to me for download?


[attachment deleted reduce file load]

[egnx]

Thanks for that detailed explanation Mike.

I find it odd that in the original db no records could be found in the Flights table with the AircraftID that matches the AircraftID for the Aircraft with the ModeS of 0BE00A, since ModeS tweaker finds 2.

Could you re-run the query using a sql tool rather than BaseStation Reporter ?

egnx

[Anmer]

Could you re-run the query using a sql tool rather than BaseStation Reporter ?

Good idea.

Using SQLite Personal, I found two flights associated with ModeS 0BE00A (which has an aircraft ID "222").

See attached.

Reporter shows the earliest session dated 2012 so I assume its database "view" is corrupted?

[attachment deleted reduce file load]

[Anmer]

I think the problem may be the sqb file location.

I should have spotted this earlier.

Alan's screenshot shows the location:

C:\Program Files (x86)\basestation\Basestation.sqb

My guess is the active sqb file is in the Virtual Store and ModeSTweaker needs to map to that location?

I could be wrong!

[egnx]

So it seems that the problem might have been two fold:-

If there are records in the flights table which don't relate to a record in the Sessions table the db is actually corrupt. and this may well have caused the original error.

And secondly as you say (unless Alan was intentionally working on a copy of his db rather than the actual live one) ModeS Tweaker always needs to normally point to your live BaseStation.sqb even if that is in the virtual store, a messy scenario best avoided!

egnx

[Anmer]

If there are records in the flights table which don't relate to a record in the Sessions table the db is actually corrupt. and this may well have caused the original error.

Though I couldn't reproduce the error on the sqb file that Alan provided!

[Anmer]

Just had an update from Alan and the issue was the sqb file location.

Mapping ModeSTweaker to the sqb in the Virtual Folder has resolved the Delete issue.

I should have spotted it earlier!