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: 2241
Joined: Fri Feb 17, 2012 3:20 am

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

Post by agw » Sun Apr 07, 2019 11:28 pm

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 » Mon May 06, 2019 4:21 pm

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: 2241
Joined: Fri Feb 17, 2012 3:20 am

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

Post by agw » Sun May 19, 2019 9:57 pm

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 » Sat Jun 08, 2019 12:23 pm

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: 150
Joined: Mon Apr 07, 2014 7:06 pm
Location: ESGG

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

Post by Skibox » 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

UA4WIY
Posts: 57
Joined: Mon Aug 29, 2016 7:41 pm

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

Post by UA4WIY » Thu Nov 14, 2019 8:35 am

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.

Post Reply