Duplicate flights

[PlumbBum]

Hi,

Can anyone suggest any reasons for this occurring? There are duplicates for lots of users, for no apparent reason. This occurs when tracking with both KaCARS and smartCARS.

Thanks,

PlumbBum

[simpilot]

Are the flights in the database multiple times when this happens or just one row?

If they are only in the data table one time there must be something in the code that is loading the flights multiple times but I would think if that was the case it would display the same amount for each flight. If they are in the table multiple times I would look at timeout errors for ACARS users and/or the site. You can also empty the ACARS table from the admin panel and see if that helps. Have you enabled error logging to see if there is anything showing up there? How to get debug info -> http://forum.phpvms....ging-issues-r31

[PlumbBum]

Hello simpilot, thank you for your reply!

This is the acars data table at the moment, in the phpMyAdmin:

and this is the main website:

I have tried clearing the ACARS table through the admin table, and the table empties, and when they all eventually load, the above happens.

I just turned on debug info and the logs weren't updated, bar the log.txt file, which is nothing to do with this error in particular. Any suggestions?

Thanks

PlumbBum

[magicflyer]

Hello,

I know someone attempted to ask this question before on the forum, so I can see this issue has been going on for a little while. Honestly, I have no idea as to why it's happening. Best guess is that this is a cache issue, but I am not too sure as to the technicalities. However, my solution to this would be to attempt replacing the individual flight rows that are being generated from the JS to straight up PHP as seen below:

https://github.com/m...bbc5440bccd5b61

The red signifies what needs to be removed, the green signifies what needs to be added. As Usual, BACKUP.

Kind Regards,

Ryan

[PlumbBum]

Hello, thank you for your response.

I implemented your code to the web page, however the flights appear for a mere second and then they all disappear. It may be worth saying that the ones that do appear are also duplicated.

Thanks,

PlumbBum

[magicflyer]

Huh, interesting.

Couldn't happen to notice that the ones that are repeating are only virtual airlines without the Flight num ICAO "VIR" which may lead me to think that there's a little issue in the SQL somewhere. Try instead of the code I gave you on line 67 of the github thing, as seen here:

$flights = ACARSData::GetAllFlights();

Replace it with maybe the following

$flights = DB::get_results("SELECT * FROM `phpvms_acarsdata`");

Be sure to replace your DB prefix with that phpvms_

[PlumbBum]

Right, one step closer - they're all single now - thank you very much.

However, the flights do disappear after like a second, haha. The link is here: http://virginvirtualgroup.co.uk/en/index.php/acars

Any suggestions?

PlumbBum

[magicflyer]

Hi, Try changing the tbody id to anything else.

Kind Regards

[PlumbBum]

Done.

Will get back to you.

[magicflyer]

I edited my post, right when you saw it. I meant tbody id in the acarsmap.tpl. Keep the table class the same

[PlumbBum]

Okay, that's changed and they're staying there, thanks. But the live map doesn't display?

[magicflyer]

Can you please post your new acarsmap.tpl over in pastebin?

[PlumbBum]

magicflyer,

Here you go: http://pastebin.com/9HyJ27nx

PlumbBum

[magicflyer]

Oh there we go, Line #47, it looks like we forgot to revert the acarsmap ID back to "acarsmap" instead of "acarsmap1" when we had that instantaneous posting event.

[PlumbBum]

Hi,

The map loads, but then I have the problem of the live flight information disappearing again.

[magicflyer]

You didn't modify the ID for the <tbody> around line #65.

[PlumbBum]

Done - thanks a lot.

Now there are no flights on the actual flight map, haha.

[magicflyer]

Is it placed on the index.php/acars extension or did you move it to another function to test. I tried visiting the site but it's displaying as the Live flight information page is not available. You need to put it back to where it was(The index function of the acars module) to have it work properly

[PlumbBum]

Hi,

No, the module is still as it was. All I've done is added an IP check so I can view it whilst I edit it, and others can't.