Database Writer "updates" some existing records when option is disabled

Is Virtual Radar Server not behaving itself? If so then please report it here.
agw
Posts: 2250
Joined: Fri Feb 17, 2012 3:20 am

Re: Database Writer "updates" some existing records when option is disabled

Post by agw »

The RTC thing was a long shot :) It wouldn't have explained the incorrect updates, the clock doesn't get involved in the decision as to whether an aircraft gets updated or not (unless you have updates turned on, which you don't). A big leap in the real world clock could cause some temporary weird effects though, there are things that happen if things aren't updated for 10+ seconds etc. so a leap of several days could trigger those effects. I can't imagine how they would affect the online lookup caching though.

If I could get a debugger running on the Pi, and if it's as easy to reproduce on the Pi as you say, then I should be able to see what's happening fairly easily. Unfortunately I don't think it's easy to get a debugger running on the Pi. However I do have a few Pis doing things here, including one running VRS (although I don't want to mess about with that one). I might try putting some trace statements into a test build and see if they can shed some light as to what's happening, whereabouts things are going wrong. Also see whether I can reproduce it as well. My attempts so far have been on Windows. I didn't get a chance to do anything on VRS this weekend but I'll see if I can try it during the week.
Commander
Posts: 3
Joined: Fri Feb 24, 2017 12:17 pm

Re: Database Writer "updates" some existing records when option is disabled

Post by Commander »

Hi!

After I have manually edited the database (in SQLite Expert Personal) and changed the OPERATOR CODES, it will clear the editing as soon as I start the VRS and the current aircraft is in the air.

I have database writer plug-in SETUP to "save online lookups in database".
It is NOT set to "overwrite details on existing aircraft".

The problem is the same as below....


Skibox wrote: Sat Mar 03, 2018 2:07 pm Using

"Save Onlne lookups..." enabled
"Overwrite details..." disabled

But still many of my corrected records gets overwritten with the old, faulty data which is coming from the online lookup database.

Op codes disappear, Operator names gets changed back to outdated info.


/M

But i can not understand how to solve the problem in accordance with this answer?
agw wrote: Tue Mar 12, 2019 12:04 am The problem was fixed and released last year.

If you are not using the database editor plugin to modify the aircraft records then you need to ensure that the UserString1 is not set to "Missing". The issue, or at least the one that I fixed, was that this field is used as a marker for placeholder aircraft records created from missing online lookups and the database editor plugin wasn't clearing the field when a manual edit was applied.

I have tried to change from (null) to an X in the UserString1 but i still changes back to nothing in the OP Code field.
How can I solve the problem?
agw
Posts: 2250
Joined: Fri Feb 17, 2012 3:20 am

Re: Database Writer "updates" some existing records when option is disabled

Post by agw »

Are you running on a Linux or Mac machine or are you running under Windows?
Commander
Posts: 3
Joined: Fri Feb 24, 2017 12:17 pm

Re: Database Writer "updates" some existing records when option is disabled

Post by Commander »

agw wrote: Sun May 19, 2019 9:57 pm Are you running on a Linux or Mac machine or are you running under Windows?
VRS 2.4.2 on Windows Server 2016
Skibox
Posts: 155
Joined: Mon Apr 07, 2014 7:06 pm
Location: ESGG

Re: Database Writer "updates" some existing records when option is disabled

Post by Skibox »

It still updates existing records and overwrites with faulty or missing fields.

I have deleted all "Missing" and it does not solve the issue.

I'm on 2.4.3, Windows Server.

I have lots of screenshots of the database records, but won't upload them here as it is a lot of extra work. Can email them if it helps.

/Skibox
UA4WIY
Posts: 65
Joined: Mon Aug 29, 2016 7:41 pm
Contact:

Re: Database Writer "updates" some existing records when option is disabled

Post by UA4WIY »

Yes, the opportunity is very necessary, the plugin does not touch the existing entries, but adds only new ones that are not in the database.
agw
Posts: 2250
Joined: Fri Feb 17, 2012 3:20 am

Re: Database Writer "updates" some existing records when option is disabled

Post by agw »

Skibox wrote: Wed Nov 06, 2019 8:04 pm It still updates existing records and overwrites with faulty or missing fields.

I have deleted all "Missing" and it does not solve the issue.

I'm on 2.4.3, Windows Server.

I have lots of screenshots of the database records, but won't upload them here as it is a lot of extra work. Can email them if it helps.

/Skibox
Sorry for the delay in replying - if you have before & after examples then feel free to send them over and I'll take a look, see if I can see anything.
scoobydobedooo
Posts: 61
Joined: Thu Oct 05, 2017 1:47 pm
Contact:

Re: Database Writer "updates" some existing records when option is disabled

Post by scoobydobedooo »

i have a smilure issue,

i have the save online lookups ticked and the update records unticked but every 28 days the database crashes cos the database writer still trys to flush the database and as a result it crashes the database out meaning i have to start again.

is there anyways to disable the option completly so the database plugin doesnt try to flush every 28 days even through its switched off? its done this on every version of VRS to date and havnt found a fix or a workaround,

my knowage of manually updateing the database is non exstant lol so i have no chooice but to use the plugin

many thanks
i have a home base station im willing to share data from. if intressed let me know :)
Post Reply