AirNav Systems Forum

AirNav RadarBox and RadarBox24.com => AirNav RadarBox and RadarBox24.com Discussion => Topic started by: Paulc on October 15, 2008, 08:15:41 AM

Title: Database Explorer
Post by: Paulc on October 15, 2008, 08:15:41 AM
Is there a way to open the database explorer without having to run airnav itself as it is very slow to respond with airnav running. (share data is off / networking off, no other applications running in background etc)

Also the autopopulate function does not seem to do much - I was in the USA recently and have a lot of codes to add and I was hoping that by using the 'populate' function it might add some of the missing info. It came back with approx 1800 which a) took a while to download and b) added very little to the missing info in the 'mylog' screen. Does it add this info elsewhere?

I still get a lot of aircraft whose details are in the GAS database but do not seem to download to the system.

Would clearing out the 'mylog' help ? (reluctant to do this with almost 10,000 records picked up since May)


Title: Re: Database Explorer
Post by: Allocator on October 15, 2008, 08:49:24 AM
Paul,

First, a quick recap :-)

There are 2 databases used by RadarBox:

- NavData.db3 which is the source database that comes populated with thousands of aircraft when you install RB.  This is the database that is used to display aircraft details in the aircraft list and on the map.  The RB autopopulate populates this database.

- MyLog.db3 is the list of "live" aircraft you have picked up with your antenna.  MyLog.db3 shoild be empty when you install RB. MyLog is filled in with the details from the NavData.db3 database as you receive aircraft.  If aircraft details are missing from this, then either the aircraft isn't in the GAS database, or the record has been written to MyLog.dbe before the aircraft details have been autopopulated into NavData.db3 - if for instance it was a "new" aircraft.

There are a number of SQL database manipulation programs that you can use to edit the NavData.db3 table, but don't get confused here between this and MyLog.db3.  Editing MyLog.db3 will only change the historical records and will make no difference to what is seen in the aircraft lists or on the map.

The Populate function in MyLog gathers information from the NavData.db3 table to fill in the details for empty records, and it might also look at the AirNav server for details.  It certainly downloads missing thumbnail photos.

Just be careful if you use a different program to edit the SQL databases - always make a backup in case you make a mess of it.
Title: Re: Database Explorer
Post by: Paulc on October 15, 2008, 09:31:55 AM
So which database is database explorer then ?  (assume navdata one)

Most of the aircraft that are failing to autopopulate are in the GAS database so should be in the navdata database?

It is quite frustrating getting lots of modeS codes for aircraft that should have the details in the system.

I picked up a code for G-FBEM a fairly new Emb190 for Flybe - (401D66 i think) yet despite running the autopopulate last evening it still does not return any info in the data line. (yes it is in the GAS database so should have been downloaded at the time)
Title: Re: Database Explorer
Post by: tarbat on October 15, 2008, 09:58:23 AM
There's a long-standing problem with the Airnav central database of aircraft not getting updated from GAS as quickly as some of us would like.

The technique I use to automate the population of up to 100 aircraft at a time from GAS is described at http://www.airnavsystems.com/forum/index.php?topic=1489.msg11716#msg11716
Title: Re: Database Explorer
Post by: Paulc on October 15, 2008, 10:28:07 AM
Tarbat,

thanks for that but tinkering with SQL is way beyond my IT comfort zone.

Will have to do more manual input.

Still no answer to the question of if i can open database explorer without having airnav running - this would speed up the process a lot.
Title: Re: Database Explorer
Post by: tarbat on October 15, 2008, 10:32:20 AM
Still no answer to the question of if i can open database explorer without having airnav running - this would speed up the process a lot.
The answer is no.  The only way is to use an SQLite database tool - I use SQLite Maestro for all my database updates, it's a lot easier than using the Database Explorer in ANRB.

One thing to note.  When using Database Explorer, turning OFF "Process Hardware Flights" can make the process smoother.
Title: Re: Database Explorer
Post by: AirNav Development on October 15, 2008, 10:51:18 AM
Search Google for Sqlite editing applications and you will find many, some of them free. You can easily edit any of RadarBox dbs with these programs.
Title: Re: Database Explorer
Post by: Paulc on October 15, 2008, 11:11:18 AM
thanks for the replies
Title: Re: Database Explorer
Post by: Paulc on October 16, 2008, 12:09:20 PM
How frequently is the airnav central database updated from GAS ? as I would hope this is done on a monthly basis as a minimum with more frequently being better.

I guess the only way to avoid these problems is to input manually some of those aircraft you are likely to see in a specific location ie MCO has a lot of Jetblue / Airtran / Southwest so it may be worth spending some time adding these codes before making a trip.
Title: Re: Database Explorer
Post by: AirNav Development on October 16, 2008, 02:09:15 PM
The central database is updated daily. Whenever a mode-s is not found there we retrieve data from GAS.
Title: Re: Database Explorer
Post by: Paulc on October 16, 2008, 02:51:50 PM
Really? - that does surprise me given that I pick up aircraft which have carried the same reg for months or longer yet no details appear in the data line. I picked up the code for G-FBEM a newish Flybe E195 (which was delivered a couple of weeks ago and details are on GAS) Even after running the re-populate and being online for a couple of hours each evening this week it still does not show up with anything other than the mode s code in the info line. I am assuming that being online will connect to the airnav central database and get the latest updates?  As for network flights clicking on those with no info does nothing to fill in the details - i get 'processing 1 request or similar' but nothing else.

Does the central database have complete worldwide fleet lists of airlines / mode
s codes ?
Title: Re: Database Explorer
Post by: tarbat on October 16, 2008, 03:12:47 PM
Paulc, check to see if that aircraft is in your aircraft table at all - ModeS hex code is 405D66.  If it's in the table with a blank entry, it will never get populated.
Title: Re: Database Explorer
Post by: Allocator on October 16, 2008, 03:43:48 PM
Really? - that does surprise me given that I pick up aircraft which have carried the same reg for months or longer yet no details appear in the data line. I picked up the code for G-FBEM a newish Flybe E195 (which was delivered a couple of weeks ago and details are on GAS) Even after running the re-populate and being online for a couple of hours each evening this week it still does not show up with anything other than the mode s code in the info line. I am assuming that being online will connect to the airnav central database and get the latest updates?  As for network flights clicking on those with no info does nothing to fill in the details - i get 'processing 1 request or similar' but nothing else.

Does the central database have complete worldwide fleet lists of airlines / mode
s codes ?

Paulc,

Is your Firewall blocking RB when it tries to contact the AirNav server?  It sounds as if none of your aircraft are being autopopulated.  When you use the Database Explorer and select the "aircraft" list, how many records are there - it's shown at the bottom of the list.  Is this number increasing on a daily basis - if not, then it sounds like no records are being populated.

The autopopulate function works very well, so if you are seeing no change, then something is wrong.
Title: Re: Database Explorer
Post by: phil zech on October 16, 2008, 03:54:03 PM
Allocator,


New user, still getting used to features

This is of interest to me.

Whilst on Network Flights ,when I scroll to bottom of list ,there are always 10/15 aircraft with no details populated for them , I left click where Registration should be , it then says processing/photos etc , it then brings up aircraft details further up the list for whatever airline it might be , photo and all.

Do this mean that whenever that aircraft is detected on Network it will show as it is part of my database.

Sorry for being longwinded but dont how else to describe what I mean.

Many thanks

Regards

Phil
Title: Re: Database Explorer
Post by: Paulc on October 16, 2008, 03:56:57 PM
Hi Tarbat,

Yes it is in the table because I added it manually yesterday.

One that is not is 0A8013 = C6-BFM 727-200 of Bahamasair which has carried that reg since 2004. It is in 'mylog' though as it was picked up live not via the network.

Am showing 79500 approx records - no firewall installed either
Title: Re: Database Explorer
Post by: Paulc on October 16, 2008, 04:22:19 PM
Am just doing autopopulate at the moment with some 1700 being processed - will check the numbers when done and see what it says. However i do not think this number increased when doing previous auopopulates.

 I do have the windows firewall activated (installed by XP Sp3 by default) but it has ANRB as an exception and it looks as if it is being directed to the correct file (anrb.exe file)
Title: Re: Database Explorer
Post by: Paulc on October 16, 2008, 06:01:24 PM
Finished the autopopulate - still showing 79625 records under the 'aircraft' menu of database explorer so it does look as if there is something not quite right with that function.

Any suggestions much appreciated.
Title: Re: Database Explorer
Post by: abrad41 on October 16, 2008, 07:02:08 PM
Paulc

I have just tried doing a autopopulate within mylog, when I started it said 109, check it about 5 - 10 mins late and still stated 109.

Is this the same thing thats happening to you.

Cheers

Andy

Ps Another 5-10 Mins gone reading 108
Title: Re: Database Explorer
Post by: abrad41 on October 16, 2008, 08:02:53 PM
I have been sitting hear well over 1 Hr - and it is still saying 108

Paulc may have a point, it does not seem to be populating when asked

Andy
Title: Re: Database Explorer
Post by: tarbat on October 16, 2008, 09:01:20 PM
I have been sitting hear well over 1 Hr - and it is still saying 108

There's a good chance that 108 aircraft in your MyLog aren't on the Airnav servers, and probably not on GAS either.  That's not a fault with ANRB.  I currently have 97 aircraft that won't populate, but I've checked some of these and none of them are on GAS.

However, to have 1700 aircraft that won't populate sounds like a problem, Paulc.  But I'm out of ideas - sorry.
Title: Re: Database Explorer
Post by: Paulc on October 17, 2008, 05:52:54 AM
Andy, not really - mine counts down ok it is just with 1700 or so it does take a while to process them all.

Tarbat - no worries - it is more likely to be a 'me' problem than one with ANRB.

Even after the repopulate the C6- 737 did not appear yet it is in mylog which is where i got the original mode S code from to go hunting for the details.

I will try another one populate tonight and see if that 79525 figure changes.


Title: Re: Database Explorer
Post by: tarbat on October 17, 2008, 10:13:52 AM
Paulc, if you're saying that an aircraft has full details (registration, type, owner, etc) displayed in your MyLog, but those details do not show in the aircraft table in Database Explorer, then I reckon that suggests a database problem.
Title: Re: Database Explorer
Post by: Paulc on October 17, 2008, 10:45:11 AM
Tarbat,

not quite - the C6 737 appears in mylog with no details other than the mode S code (used to get info from GAS / airframes website) but having done the repopulate I would expect it to have populated somewhere if my understanding of how ANRB does this is correct (it may not be though) I searched for the mode S in the aircraft field but nothing (not even the mode s code 0A8013) was returned. Does the fact it appears with no data in mylog prevent autopopulate working correctly?
Title: Re: Database Explorer
Post by: tarbat on October 17, 2008, 11:27:58 AM
It shouldn't.  As long as it does NOT appear in the aircraft table in database explorer, ANRB should attempt to populate.
Title: Re: Database Explorer
Post by: Paulc on October 17, 2008, 12:05:11 PM
It does look as if I might have a problem then with this function.

Also when trying to populate network flights - I think you are meant to click anywhere in the line to get the details but this does not work for me either.

The answer might be to just turn off the firewall, repopulate and turn it back on -I may try this tonight to see if it the firewall that is the problem.
Title: Re: Database Explorer
Post by: Hawkeye on October 17, 2008, 12:28:22 PM
I've got the same problem as Paulc and abrad41.

Taking Tarbat's example of code 405D66. Last night it showed in Mylog as 1st time 18/9/08 and last time 16/10/08 @ 20.43.31 with no corresponding registration shown. It does not appear in Database explorer at all.  During the period stated, I've run Populate in Mylog several times. This is just one example of many codes that have no registration to them in Mylog.
On running populate, the panel always says "85 aircraft updated  ........"  and Database  Explorer never changes from 80437 loaded.

I have allowed access to ANRB in Zonealarm firewall and this must be ok because routes continuously update on the map.

I suspect that there are more than 3 of us with this anomaly and that from previous postings, quite a lot of users are manually updating to overcome it. Seems strange why anyone should wish or need to do this if autopopulate does what it should do.

I've typed codes without registrations into Google several times and not once failed to get a tie up from a forum somewhere so the info must have been in GAS or some other database.

Our forum 'experts' have been very helpful as always, but as even Tarbat has "run out of ideas" it would be appreciated if Airnav Development would give their opinion of why this is happening and how it can be overcome.

regards,

Hawkeye.





Title: Re: Database Explorer
Post by: Allocator on October 17, 2008, 01:00:26 PM
Am just doing autopopulate at the moment with some 1700 being processed - will check the numbers when done and see what it says. However i do not think this number increased when doing previous auopopulates.

 I do have the windows firewall activated (installed by XP Sp3 by default) but it has ANRB as an exception and it looks as if it is being directed to the correct file (anrb.exe file)

There is a bit of confusion here.

The RadarBox autopopulate function does not require you to do anything - you can't switch it on or off - if you have an internet connection, it just works in the background.  This autopopulate function populates NavData.db3 and this is the database you are looking at in Database Explorer. (However, you can give the autopopulate function a "kick" by clicking on an aircraft line in MyFlights or Network.)

The populate function in MyLog is completely different.  This appears to only populate aircraft in the MyLog list and when you are looking at MyLog, you are looking at the completely different database MyLog.db3

NavData.db3 is the database that is used to show aircraft details in the MyFlights and Network aircraft lists.  Also, the data in NavData.db3 is copied across to MyLog.db3 when an aircraft is detected "live" using your antenna.

When you use the MyLog > Tools > Populate function, this is only going to populate those empty records in MyLog.db3 - it doesn't affect NavData.db3 in any way.  This is not an "autopopulate" function, as you have to hit the button for it to work.

So, when you get a message that there are 96 aircraft to populate in MyLog, RB is looking at the NavData.db3 database and possibly the AirNav server too.  You are almost never going to get to a zero count here, but the number should reduce.  If it says 1700 and never gets any less, then you have a problem.
Title: Re: Database Explorer
Post by: Paulc on October 17, 2008, 02:05:14 PM
Allocator,

the autopopulate 'kick' by clicking on an aircraft with only the mode S code does not work for me - have tried it several times and the missing aircraft info is not completed (unless you need to refresh the system by turning off/on the process hardware box - lower left on data box)

If as you say above the NavData.db3 is copied across to MyLog.mdb when an aircraft is detected 'live' then why are so many aircraft that are in the GAS database and therefore should be in the central database that NavData is created from, not showing up with full info when detected live. Am assuming that each individual radar box holds NavData.db3 within it rather than go searching for it via the internet each time.

If aircraft are detected live but without being on the internet (as I was doing in Orlando last week) are these details added the next time I do connect? or should they be in the NavData.db anyway regardless. My Navdata.db has 79625 lines of info so would like to think this would have the vast majority of airliners within it especially as the Mode S info for these is readily available.

The 1700 has been steadily increasing over time so I may well have a problem somewhere. I will try it tonight to see the latest figure.
Title: Re: Database Explorer
Post by: tarbat on October 17, 2008, 02:29:41 PM
Also when trying to populate network flights - I think you are meant to click anywhere in the line to get the details but this does not work for me either.

Yes, when you single click on an aircraft in the Network Flights that doesn't have a Registration, you should see the following as ANRB looks the aircraft up on the Airnav server.

You should see the same message(s) appear whenever an aircraft without Registration appears in your MyFlights.

The problems mentioned by Hawkeye and abrad41 sound like normal behaviour, and are probably aircraft that have not yet been identified on GAS (or the Airnav server).  This is a long standing "problem", with updates from GAS not happening as quickly as some of us would like.
Title: Re: Database Explorer
Post by: Paulc on October 17, 2008, 02:50:27 PM
Tarbat,

I notice that you have a box with 'X mesages/sec ' - I do not recall having this on mine - could that be a clue? I get the 'process photo / info request but the info does not appear.
Title: Re: Database Explorer
Post by: tarbat on October 17, 2008, 03:00:08 PM
I notice that you have a box with 'X mesages/sec ' - I do not recall having this on mine - could that be a clue?

It should be there if the Radarbox hardware is connected and processing local aircraft.  You are running the latest version of software (2009)?

And if you're getting the 'process photo / info request" but the info does not appear, then that might indicate a firewall problem, or that the aircraft isn't on the Airnav server.
Title: Re: Database Explorer
Post by: Paulc on October 17, 2008, 03:00:59 PM
yes - am running the latest version
Title: Re: Database Explorer
Post by: tarbat on October 17, 2008, 03:13:46 PM
An easy way of testing if autopopulate is working is to:
1. Turn ON network flights, and view the network flights
2. Sort the list of network flights by Registration, so that all the blank registrations are together at the top of the list
3. Click on the first of these aircraft
4. Press the down arrow on your keyboard until you've "down-arrowed" onto all aircraft with a blank registration

You should see the number of "Processing photo/info requests" start at the number of aircraft you've"down-arrowed", and then as each aircraft is found on the Airnav server, the number should drop by 1.  Eventually "All photo/info requests done" should appear.

You may still see some aircraft with a blank registration in the Network aircraft list - this is because they were not found on the Airnav server.

I just did this, and of 15 aircraft, 4 aircraft were not found.
Title: Re: Database Explorer
Post by: AirNav Support on October 17, 2008, 04:19:42 PM
This does sound like a firewall issue. But usually having a firewall would block any connections for RB to the net so that would include connecting to the network.

Keep us informed of what happens without the firewall, you may need to be also be patient as it might be proccessing 100s of details before it gets down to the one you clicked on network interface.
Title: Re: Database Explorer
Post by: Paulc on October 17, 2008, 05:50:17 PM
Tarbat,

tried that and i do get "processing photo / info request' but when i go and look for the mode s code it refers to there is nothing there. The number of rows in the aircraft section of database explorer does not increase either. Does it populate the network flight list immediately ?

Will try it without the firewall and see if that helps but i do get photo's etc
Title: Re: Database Explorer
Post by: Paulc on October 17, 2008, 08:49:59 PM
ok - turned off the firewall - difficult to judge how successful it has been as the number of rows in the aircraft section of database explorer remain the same at 79625. Some missing aircraft have been populated but others are not in the system at all ie Emb 190 of Jetblue N266JB still does not exist. Clicking on network flights got the 'processing photo etc' but that was all - no info appeared.
Title: Re: Database Explorer
Post by: Hawkeye on October 17, 2008, 09:34:33 PM
Hi Tarbat,
Thanks for your response below:-

>>The problems mentioned by Hawkeye and abrad41 sound like normal behaviour, and are probably aircraft that have not yet been identified on GAS (or the Airnav server).  This is a long standing "problem", with updates from GAS not happening as quickly as some of us would like.<<

You and Allocator have really put a lot of effort into trying to help on this subject and  I didn't really want to trouble you again but I feel sure that in a lot of cases it is not caused by aircraft not yet having been identified.
Taking your example again of 405D66 which shows in your attach as G-FBEM, I assume this autopopulated for you. I have left clicked on this entry (whilst on line) several times when it has appeared in Myflights without success.
I previously mentioned that I have typed this particular code into Google and the reg. tie up appeared in 'Spotter's' forums back in September so presumably it had been identified.

I have also turned on Network flights and without even highlighting any entries the "Processing photo/info requests" comment showed at the bottom, reducing one by one from 29 to 0, and the "Photo/info requests done" came up each time. Having reached 0 the figure then returns to 29 and the whole process starts again, ....and again! without any updates being made.

As I said, I am very grateful for your efforts and have only posted this because I feel that for some reason, Paulc, abrad and myself are experiencing some anomaly which has nothing to do with the codes not having been previously identified. It doesn't appear to be a general problem amongst RB users and it would seem that in spite of all your efforts,  unless Airnav or anyone else can think of a solution, we're 'stuck with it'.

Thanks once again,

Hawkeye




Title: Re: Database Explorer
Post by: AirNav Support on October 17, 2008, 09:48:35 PM
Backup your databases and then try with a new fresh database.

It may be a case of database corruption.
Title: Re: Database Explorer
Post by: Allocator on October 17, 2008, 09:57:43 PM
Hawkeye,

I can only imaging that for some reason your NavData.db3 database is not being written to for some reason - you haven't copied it to CD than back to the PC so its become read only?

Database Browser shows that the number of aircraft records has increased from 81217 to 81242 this evening alone, so the autopopulate is working.

Adding to the suggestion made by AirNav Support, you could try renaming your AirNav RadarBox 2009 directory to something like AirNav RadarBox 2009 Bak then do a new install of RadarBox 2009.  This will give you a fresh install without loosing anything you already have - don't do an uninstall.

(http://farm4.static.flickr.com/3220/2950472166_764e5a4456.jpg)

The fresh install will default to AirNav RadarBox 2009 and if you don't like the results, you just delete this whole directory and rename AirNav RadarBox 2009 Bak to AirNav RadarBox 2009.
Title: Re: Database Explorer
Post by: abrad41 on October 18, 2008, 08:45:39 AM
Hi

I think I need some help here - as I see it the database explorer (NavData.db3) is already populated from install (am I thinking right here).

What I want In my Database explorer is just the flights that I have seen - so is it possible to start off with a fresh empty NavData.db3 - so then it will only have flights I have seen in there, and as it get populated it will only have what i have seen in there - please tell me is this possible.

Thank you

Andy
Title: Re: Database Explorer
Post by: Allocator on October 18, 2008, 09:09:21 AM
Andy,

You really don't want an empty NavData.db3 file as this is the source file rather that what you have seen.

MyLog.db3 contains only what you have seen live with your antenna and you view this using the MyLog button on the toolbar.  You can delete all the records in MyLog from the MyLog > Tools > Empty MyLog Tables option.

Just read back through this thread for a full explanation of the NavData.bd3 and MyLog.db3 databases.
Title: Re: Database Explorer
Post by: abrad41 on October 18, 2008, 09:21:57 AM
Allocator

As you now mate I had a sbs and what I did there was - every month I would delete my sessions (Mylog) for the complete month ( As I new they were all in my master database (NavData.bd3). Is there no way of working this in Radarbox.

Just the way I use to work mate - my main database had everything in it I had seen and just used the sessions for daily or monthly records

Cheers

Andy
Title: Re: Database Explorer
Post by: Allocator on October 18, 2008, 01:27:37 PM
Andy,

Just use MyLog > Tools > Empty MyLog Tables or Delete Old Data and you will have a fresh empty MyLog :-)

It doesn't matter a jot what you've got in the NavData.db3 database, as all this does is "fill in the blanks" when you pick and aircraft up.  However, MyLog.db3 only contains the aircraft you have picked up "live" since you last emptied it.

If you wanted to get cleaver, you could make a copy of MyLog.db3 before you empty it and rename it to Sep.db3 or something like that.  You could then use a 3rd party sql program to manipulate the data as you wish.

Either that, or you could export MyLog to a csv file from the MyLog> Tools menu and use Excel.



Title: Re: Database Explorer
Post by: abrad41 on October 18, 2008, 02:41:23 PM
Thanks Mate.

A bit clearer now

Thanks

Andy
Title: Re: Database Explorer
Post by: Paulc on October 18, 2008, 08:01:18 PM
Allocator,

my database browser still only shows 79625 records so to me that looks like autopopulate is not working.(I will leave laptop on overnight to see if it increases but i am not hopeful) When the new 2009 software came out I only did the upgrade as I already had the system up and running - could this be a possible cause as to why I seem to have a problem.


Title: Re: Database Explorer
Post by: Hawkeye on October 18, 2008, 08:35:48 PM
Allocator,

Thanks for your suggestion in reply 36.
When I looked in my Airnav folder I thought , yep, that's the answer because when v2.0 came out in August I installed the upgrade from 1.5 and not a full version and only Airnav Radarbox 2007 and Airnav Radarbox 2008 were showing.

So, ...did a full install of 2009  full of optimism. Unfortunately, it hasn't solved the problem!!
In fact, instead of 80437 database entries before, there are now 80136 and this hasn't changed since install this morning.
Just running "Get Flights from Network" again and there are at least 35 Code only entries in the list,  and the 'Network ........... to update' panel at the bottom is still counting down from 29 to zero repeatedly as it did before without any new reg entries being made.

Completely at a loss now because if you, Tarbat, and Airnav Dev. for all your efforts and suggestions can't solve it, it looks like the only way will be to periodically re-install 2009 and hope the database has been updated at source.

Many thanks,

Hawkeye
Title: Re: Database Explorer
Post by: Allocator on October 18, 2008, 08:38:29 PM
Allocator,

my database browser still only shows 79625 records so to me that looks like autopopulate is not working.(I will leave laptop on overnight to see if it increases but i am not hopeful) When the new 2009 software came out I only did the upgrade as I already had the system up and running - could this be a possible cause as to why I seem to have a problem.




The upgrade is almost certainly the problem.  Uninstall and install the full upgrade.  If you want to keep your MyLog, then backup MyLog.db3 and then you can copy that across later if you want.
Title: Re: Database Explorer
Post by: Allocator on October 18, 2008, 08:41:01 PM
Completely at a loss now because if you, Tarbat, and Airnav Dev. for all your efforts and suggestions can't solve it, it looks like the only way will be to periodically re-install 2009 and hope the database has been updated at source.

Many thanks,

Hawkeye

Hawkeye,

Make sure that you are actually running the new version - does it say AirNav RadarBox 2009 in the blue Windows title bar?

If you are running Vista, then tarbat is the man to answer questions about where it's best to install RadarBox.
Title: Re: Database Explorer
Post by: Hawkeye on October 18, 2008, 08:50:57 PM
Hi again Allocator,

Blimey, that was quick, was just about to shut down and go for a bevvy or two :-)

Yes, version 2009 is running as showing in the title bar and I'm running XP pro.

Hawkeye

Title: Re: Database Explorer
Post by: Allocator on October 18, 2008, 08:53:07 PM
Hmmmm...... I'm running out of ideas - I should go for a beer if I was you :-)
Title: Re: Database Explorer
Post by: Paulc on October 18, 2008, 09:40:09 PM
Allocator,

will try that - have sent the my email address to the download section and will see what happens. I will not uninstall just yet though.

Many thanks for yours + Tarbats help on this - will report once I have reinstalled.
Title: Re: Database Explorer
Post by: AirNav Support on October 18, 2008, 10:34:07 PM
Paul,

Not sure why you have sent an email to the download section. RadarBox 2009 can be downloaded from:

http://www.airnavsystems.com/RadarBox/support.html
Title: Re: Database Explorer
Post by: Paulc on October 19, 2008, 07:55:11 AM
opps senior moment there

Have reinstalled etc and now have 80136 aircraft in database explorer but it has not increased in the last 45 mins or so despite me clicking on those without info. I get the X processing info requests but no rows have been added.
Title: Re: Database Explorer
Post by: Allocator on October 19, 2008, 08:30:01 AM
Surely this must be some sort of Firewall issue.  My database count is up to 81266 now and I've just populated a Network flight by clicking on its line.

Are you sure the photos are being downloaded OK? Take a look at the /Data/Photo directory and see how many thumbnail files you have as these should increase too - I've got 20,024 right now.

If you click on a thumbnail below the aircraft list, does this open the airliners.net website with the full size picture?
Title: Re: Database Explorer
Post by: Hawkeye on October 19, 2008, 03:33:04 PM
I feel embarrassed to keep coming back on this subject, it seems to be getting into a bit of a saga, but it's so frustrating. There must be an answer and I agree with Allocator  it would appear to be some sort of Firewall problem.
But:-
Iv'e now run ANRB with every protection I can think of turned off:-
Adaware, Spybot, AVG, Zonealarm Firewall and Windows Firewall and still no populating of Aircraft or Photos.
The strange thing is though it's populating routes!!. Gone  up from 124047 to 124081 between 14.59 and 15.20 today, so I'm through to the server and a Firewall problem couldn't be choosy.

As to Allocator's suggestion to Paulc, ( who it would appear has exactly the same problem), re photos. I've checked the Dat/photo files in Version2007 which I installed in March and that populated them until end of June. Upgraded to 2008 on August 10th and have checked photo files in that, and now surprisingly realised that there have been no updates at all since installation.  There are only 86 in version 2009 installed yesterday.

A couple of questions for Airnav Development.

Is the full installation of version 2009 I did yesterday a completely separate and new programme from the 2007 and 2008s ones still in the Airnav Systems folder or does it take some parts from them? The reason for asking is that my home location did not need to be reset on the map and I was not asked for my password etc. If it is taking these from previous versions, could any corruption there might have been in them be 'transferred' to 2009 as well?
If this is possible, would it be advisable to remove them to another location and reinstall 2009 again?
Any further ideas from you?

Sorry to prolong this thread but there MUST be a solution somewhere.

Thanks,

Hawkeye
Title: Re: Database Explorer
Post by: AirNav Support on October 19, 2008, 03:41:07 PM
Hawkeye & PaulC,

Please do the following now:

1.) Copy the Data folder in your 2009 and 2008 folder (if you have 2008 only and not 2009 showing in AirNav Systems Program Files). Copy them and save them somewhere as a backup.

2.) Now uninstall every version of RadarBox you have on your pc.

3.) Download the Full version of RadarBox and install it.

Confirm to us that aircraft are being populated and try the network trick of selecting a few aircraft and see whether they populate.

We would be suprised if the populate function does not work then, this does seem like the case of an upgrade to 2009 going wrong and hence the database not updating (well documented in the 2009 thread)
Title: Re: Database Explorer
Post by: Paulc on October 19, 2008, 04:20:56 PM
Airnav Support,

did the uninstall of all airnav programmes (kept mylog.db3 as a backup and reimported this ok) Downloaded 2009 version which is working ok (apart from this problem)

Database explorer has 80136 records but this does not increase when clicking on those network flights with no data.

Have turned off the firewall and will keep system on for a few hours to see if this figure increases but am not sure it is autopopulating even though i get the "photo requests / info" counting up / down


Title: Re: Database Explorer
Post by: AirNav Support on October 19, 2008, 04:25:57 PM
Please remember when details are written to the database they are not always shown in the Database explorer untill RadaBox is closed as it sometimes uses a cache to speed up lookups.
Title: Re: Database Explorer
Post by: Paulc on October 19, 2008, 05:33:37 PM
Just turned system off / on - still have 80136 aircraft but routes has increased from 123995 to 124002 in the last 10 mins. Something is getting through but not the whole set of data.

Firewall is off at the moment as well.
Title: Re: Database Explorer
Post by: Hawkeye on October 19, 2008, 06:20:20 PM
Done uninstall of all versions and reinstalled 2009 at 17.30. Opened  'Get Flights from Network' and left  RB running. Still no populating of aircraft or photos!!.

Aircraft database on install showed 80136 and still does. Photos in Data/Photos file showed 85 and still does, (I suppose I should have backed up the photo file as well 'cos I had nearly 4000 before), but as with Paulc, the routes are increasing,.....123964 to 123975 in about 1 hour.

The bottom of the screen shows:-
'Hardware: Connected'
Alternating 'Connecting to Network' and 'Network Flight data successfully updated'.
'Network: 29 to update' still counting down to zero and then starting again and again.
Regular alternating 'Processing photo/info request photo/info request'  and 'All photo'info requests done'.           But they're not.

So,.... unfortunately, problem not solved.

Haven't reimported Navdata and Mylog files yet by the way, so they can't be affecting the process.

Is there only abrad, paulc and myself reported this problem, seems strange if that is so.

More frustrated

Hawkeye


Title: Re: Database Explorer
Post by: AirNav Support on October 19, 2008, 06:52:15 PM
Hawkeye,

Can you personal message with us your RadarBox serial number, this is so we can check your sharing data to our servers (this will confirm you firewall is not interfering)

Paulc,

Can you uninstall and install again and do not import anything. We need you to have a fresh install. Its intresting to notice in earlier posts you have 79625 in your NavData database when the 2009 comes with 80136 as standard.
--------------

We have done quick a test with freshly installing on a few machines and they worked fine. Also checking our stations across the world they have been getting photos data and new aircraft picked up.
Title: Re: Database Explorer
Post by: Paulc on October 19, 2008, 07:51:51 PM
I had deleted quite a few records from the database - hence the reduced numbers.

I only imported mylog data tonight so I had a hour or so earlier today with a totally fresh install and no difference.  I would not like to loose the 10K aircraft contained in the mylog either.

thanks for your continued efforts

Would my nav box s/n be of use as well ?
Title: Re: Database Explorer
Post by: Paulc on October 19, 2008, 09:21:28 PM
Reinstalled with the firewall off and still the same - been on for 45 mins with nothing being populated - not even routes. Aircraft number is still 80136 and routes at 123947.
Title: Re: Database Explorer
Post by: Paulc on October 21, 2008, 05:17:47 PM
Any update on a possible cause / solution. Mine has been on for the last hour or so with nothing being populated.
Title: Re: Database Explorer
Post by: Paulc on October 22, 2008, 09:00:42 PM
Box has been on since 4.30pm today - routes increased by 25 or so during that period. No increase in the number of aircraft though.
Title: Re: Database Explorer
Post by: AirNav Support on October 22, 2008, 09:02:41 PM
Hi Paulc,

Can you get in contact with support and provide us much details as possible about your setup such specs etc..

We can't see anything wrong with the software so far with our checks so we assume its something on your machine which is conflicting.
Title: Re: Database Explorer
Post by: Paulc on October 31, 2008, 06:21:41 AM
Have sent details but you assumed I was running Vista which I am not - XP with SP3.

Replied to tech email 5 days ago but nothing more received so am I stuck with a system that does not update properly.
Title: Re: Database Explorer
Post by: AirNav Support on October 31, 2008, 08:29:12 AM
We did get and we are trying to create your issue but have had no luck so far. Can you confirm your not on a work network?
Title: Re: Database Explorer
Post by: Paulc on October 31, 2008, 09:35:43 AM
no it's not on a work network - laptop runs at home with BT wireless broadband internet connection. It does seem odd that the routes seem to populate but not the number of aircraft which has been stuck at the same number since doing the clean installation as suggested a couple of weeks ago. I assume the number in the system should increase from 80136 as new aircraft are added to GAS and subsequently the airnav central database.