Jump to content

VACENTRAL "Airline Latest Events" update problem


Joburgtaxi

Recommended Posts

Hi

We are having a problem where the "Airline Latest Events" section of our airline is not updating on vacentral.

this can bee seen here http://www.vacentral...eo_geoairlines

Although the last updated date on the page shows that updates are happening the data in the Airline latest events section is not updating and staying static.

All PIREPS are getting filed with vacentral and can be seen on the last 100 flights page so it just seems to be a problem with this particular section.

As I am quite a noob can someone give me any advice on what to check so that I can track down why this is not working.

Thanks

Link to comment
Share on other sites

  • Administrators

I just responded to your email but I basically sent you to the same link. Can you send me or post what the title and time of the last couple of news posts were so I can try to research them? I tried looking on your site but do not seem to find a news feed anywhere, maybe you have to be logged in.

Link to comment
Share on other sites

David

Thanks for your reply.

We do not actively or manually post any new news items on the website but the Airline latest events section on VACentral has always just updated automatically until a few days ago.. I have also noticed that we do not have a news link on our webpage (not sure if we ever did ?) but the news section in admin panel is there and there are just 2 test news items in there. These same 2 test news items are reflected in the database as well in the phpvms_news table.

I need to understand how the data flow works ie. what scripts and files are involved to transfer the data from phpvms to VAcentral and specifically what are the mechanisms involved for getting the below data onto the http://www.vacentral...geo_geoairlines (Airline Latest Events) section of the page because that is what I need to investigate the connection and transport mechanisms do not seem to be relaying the data required for the update. AS I said this just mysteriously stopped working on the 24th January where you can see that that was the last successful event to be updated although you can see from the image below that VAcentral is showing that it believes an update did take place recently

va.PNG

</div> <hr/> <div class="row"> <div class="col-sm-6"> <h4>Airline Latest Events</h4> 1/24/2016 - Alan Peel completed flight BVG594 (LFBU-LFBX)<br />1/24/2016 - Alan Peel completed flight BVG514 (LFDN-LFBU)<br />1/24/2016 - Andrew Jackson completed flight BVG2988 (EGNT-EGKK)<br />1/23/2016 - Ferry Van Der Locht completed flight BVG9141 (ENTO-EYVI)<br />1/23/2016 - Alan Peel completed flight TDW14 (ZMKD-ZMBH)<br />1/23/2016 - Ferry Van Der Locht completed flight BVG12748 (EDLW-LWSK)<br />1/23/2016 - Jay Murphy completed flight BVG531 (EGSS-EHAM)<br />1/23/2016 - Alan Peel completed flight TDW13 (ZWWW-ZMKD)<br />1/23/2016 - Glenn White completed flight BVG14220 (LPPT-EGCC)<br />1/23/2016 - Ferry Van Der Locht completed flight BVG7567 (EPKK-EDLW)<br /> </div> <div class="col-sm-6"> <h4>Airline Latest Site News</h4> 9/02/2015 - Welcome to phpVMS!<br /> </div> </div>

Link to comment
Share on other sites

Hi

I am assuming that this is the file where the data is sourced from

phpvms / lib / rss / latestpireps.rss

The contents of the file as it currently stands does have the latest data as below but this is not getting passed to VACentral

?xml version="1.0" encoding="utf-8"?><rss version="2.0"><channel><title>Latest Pilot Reports RSS Feed</title><link>http://geoairlines.c...description>The latest pilot reports</description><lastBuildDate>Thu, 28 Jan 2016 12:42:32 UTC</lastBuildDate><language>en-us</language><item><title>Report #9016 - KMYL to KBIL</title><link>http://geoairlines.c...id><pubDate>Thu, 28 Jan 2016 12:42:32 UTC</pubDate><description>Filed by TDW051 (Alan Peel)</description></item><item><title>Report #9015 - DTTJ to EHAM</title><link>http://geoairlines.c...id><pubDate>Thu, 28 Jan 2016 12:42:32 UTC</pubDate><description>Filed by BVG529 (Ferry Van Der Locht)</description></item><item><title>Report #9014 - NZCH to NZAA</title><link>http://geoairlines.c...id><pubDate>Thu, 28 Jan 2016 12:42:32 UTC</pubDate><description>Filed by BVG211 (Hasan Deniz)</description></item><item><title>Report #9013 - CYYT to CYYR</title><link>http://geoairlines.c...id><pubDate>Thu, 28 Jan 2016 12:42:32 UTC</pubDate><description>Filed by BVG002 (Ernie Eyre)</description></item><item><title>Report #9012 - KBFI to KMYL</title><link>http://geoairlines.c...id><pubDate>Thu, 28 Jan 2016 12:42:32 UTC</pubDate><description>Filed by TDW051 (Alan Peel)</description></item><item><title>Report #9011 - FACT to SBGL</title><link>http://geoairlines.c...id><pubDate>Thu, 28 Jan 2016 12:42:32 UTC</pubDate><description>Filed by TDH216 (Joshua Janssen)</description></item><item><title>Report #9010 - NZCH to NZAA</title><link>http://geoairlines.c...id><pubDate>Thu, 28 Jan 2016 12:42:32 UTC</pubDate><description>Filed by BVG051 (Alan Peel)</description></item><item><title>Report #9009 - BGSF to BGBW</title><link>http://geoairlines.c...id><pubDate>Thu, 28 Jan 2016 12:42:32 UTC</pubDate><description>Filed by TDW777 (Phil Jones)</description></item><item><title>Report #9008 - NZCH to NZAA</title><link>http://geoairlines.c...id><pubDate>Thu, 28 Jan 2016 12:42:32 UTC</pubDate><description>Filed by BVG737 (Darryn Fisher)</description></item><item><title>Report #9007 - NZCH to NZAA</title><link>http://geoairlines.c...id><pubDate>Thu, 28 Jan 2016 12:42:32 UTC</pubDate><description>Filed by BVG216 (Joshua Janssen)</description></item></channel></rss>

Link to comment
Share on other sites

  • Administrators

I did not understand what you were referring to, I was thinking the site news feed. I looked and it is actually right, the last true PIREP was put in the system on the 24th, the vasats have been updating. I am am guessing that your site is set to use json data which for some reason has all of a sudden given many sites an issue. When you go to your admin panel does it show flight waiting to be exported and when you try you get a message the there is no response from the API server? If so, try changing it to xml and let me know.

http://forum.phpvms.net/topic/23275-exporting-pirep/#entry122813

Link to comment
Share on other sites

David

There are only two options under VAcentral settings in the admin page they are, which one do I select ?

vaCentral Options

These are your options for vaCentral. Note that your schedules and PIREPs will automatically export, and you don't need to manually do it.

Send Schedules This sends out the latest version of your schedules to the vaCentral server. You can only do this once a day.

Send PIREPs This will resend all your PIREPS. Only do this if it has been the first time, and none of your PIREPs are showing up on vaCentral. This will wipe out all your data on vaCentral, and reset your finances and ranking.

When selecting SEND Schedules I get

Sending schedules...

There was an error, server said ""

Link to comment
Share on other sites

  • Administrators

Just noticed that the last update time has changed on VAcentral but the Airline larest events has not changed.

Is there supposed to be a VAcentral table in the database ?

The vastats update that you are seeing is separate from PIREP and ACARS data and only updates once every 24 hours. The events are driven by PIREP submissions which should be happening as soon as it is filed unless you have made changes to your system.

I am not aware of any database table in phpVMS that would be for vaCentral specifically.

Link to comment
Share on other sites

David

Nope this is still not working, any other ideas ?

The send PIREPS button is that the one that says "This will resend all your PIREPS. Only do this if it has been the first time, and none of your PIREPs are showing up on vaCentral. This will wipe out all your data on vaCentral, and reset your finances and ranking."

I am not sure I want to wipe out all the data on VAcentral as it says it will do.

Link to comment
Share on other sites

  • Administrators

I think I figured it out, there are no other airlines with this issue so I started looking at your data and the newest PIREP right now has a unique_id of 9042 yet there are PIREPS from your airline with a unique ID as high as 10874. This is the id that is assigned to it in your database of PIREPS. When the vacentral system sees a PIREP come in that has the same airline id and the same unique id as a PIREP already in the system it assumes it is an update and updates the old pirep, and also bypasses the activity feed.

My guess is that on the 24th you guys reset your PIREPs database, or at least cleaned some out or something and reset the id column back to somewhere in the 9000's.

Two solutions;

1 - I can delete all the PIREPS from the vaCentral database and you can resubmit them and it should correct the id issue or;

2 - Set your id column of your PIREPs table to something above 10874

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...