Author Topic: Multiple entries shown for a single flight [SOLVED]  (Read 124 times)

smokey

  • Newbie
  • *
  • Posts: 28
    • View Profile
Multiple entries shown for a single flight [SOLVED]
« on: July 28, 2018, 09:07:04 AM »
Hi All

Our VAM is just a day or two old, so still getting the hang of things

Something odd, on the main page under "latest flights" every flight appears 4 times
and under pilot roster, 2 times ... surely this is not normal

screenshot here .. http://www.mediafire.com/?b6fuc2ghmc118

Jan

EDIT: also under live flights
« Last Edit: August 03, 2018, 03:34:39 PM by smokey »

smokey

  • Newbie
  • *
  • Posts: 28
    • View Profile
Re: Multiple entries shown for a single flight
« Reply #1 on: July 30, 2018, 04:23:40 PM »
nobody else experiencing this issue ?  :-\

Timothee

  • Jr. Member
  • **
  • Posts: 77
    • View Profile
Re: Multiple entries shown for a single flight
« Reply #2 on: July 30, 2018, 04:42:13 PM »
Just a wild guess but how many rows does the table "airports" count in your installation?

smokey

  • Newbie
  • *
  • Posts: 28
    • View Profile
Re: Multiple entries shown for a single flight
« Reply #3 on: July 30, 2018, 05:49:54 PM »
I guess you want me to check that in the database ? right ?

smokey

  • Newbie
  • *
  • Posts: 28
    • View Profile
Re: Multiple entries shown for a single flight
« Reply #4 on: July 30, 2018, 05:56:43 PM »
Showing rows 0 - 24 (92339 total, Query took 0.0073 seconds.)

is that the info you require ?

I see the light bulb  ::)

because of incorrect ICAO's, I exported / downloaded the DB in .csv
did the corrections, and imported again ... so I guess I now have 2x the size - everything duplicated

my bad, as Im now really skilled in doing it - LOL

question now how to correct it ?
.. I still have the original .sql's I downloaded with the VAM package

EDIT:
I simply deleted all data and imported the original .sql
Thanks a lot !!!!
made my day

Jan

« Last Edit: July 30, 2018, 06:16:42 PM by smokey »

Timothee

  • Jr. Member
  • **
  • Posts: 77
    • View Profile
Re: Multiple entries shown for a single flight
« Reply #5 on: July 30, 2018, 06:29:12 PM »
Yes that was what I was going for, glad you found it ;)