Double bookings - is it a problem of VATBOOK or VACC-SAG?

Support forum for VATBOOK, the flight booking system. For general vroute queries please use vroute.premium forums above.

Moderator: Michal Rok

Post Reply
Andreas Fuchs
Posts: 34
Joined: Sat Jun 10, 2006 3:59 pm

Double bookings - is it a problem of VATBOOK or VACC-SAG?

Post by Andreas Fuchs » Wed Jul 12, 2006 9:27 pm

Hi Michal,

I am just chatting with some people in VACC-SAG regarding a possible bug. For verification I have tried to reproduce it and yes, now I have multiple entries of LSMU_TWR for 13 JULY 2006.

What have I done? I have used VACC-SAG's ATC Booking Interface to ADD the bookings and then to DELETE it. Now there are three entries in VATBOOK's data file. Any trace, any idea if it is a problem of VACC-SAG or of VATBOOK?
Cheers, Andreas

User avatar
Michal Rok
Five Star Club
Posts: 2440
Joined: Wed Aug 31, 2005 4:23 pm

Post by Michal Rok » Thu Jul 13, 2006 2:49 am

I suppose its SAG not sending a delete command properly:

When the booking was inserted, it had a local ID of 12276:

GET /atc/insert.asp?Local_ID=12276&Local_URL=http://www.vacc-sag.org/eurobook/add.ph ... =0&voice=1

A vatbook ID (EU_ID) of 83674139 was assigned. However, in subsequent calls to update/delete this record, only EU_ID was provided - but Local_ID was now zero:

GET /atc/update.asp?Local_ID=0&Local_URL=http://www.vacc-sag.org/eurobook/redir. ... 0&E=0&voic e=1&EU_ID=83674139

GET /atc/delete.asp?Local_ID=0&Local_URL=http://www.vacc-sag.org/eurobook/redir. ... D=83674139[/b]

VATBOOK could not satisfy the update/delete command, because there was no match for this combination of Local_ID and EU_ID.

It should be quite simple to fix.


Michal

Andreas Fuchs
Posts: 34
Joined: Sat Jun 10, 2006 3:59 pm

Post by Andreas Fuchs » Thu Jul 13, 2006 7:38 am

Good morning Michal,

thanks for your quick answer, will forward it to our webmaster right away, thanks!!
Cheers, Andreas

Markus Zürcher
Posts: 6
Joined: Mon Feb 11, 2008 6:48 pm

Re: Double bookings - is it a problem of VATBOOK or VACC-SAG?

Post by Markus Zürcher » Tue Apr 08, 2008 10:37 am

And again double bookings this time for Users with a umlaut in theyr name (curent examples "ü")...

Is it a VACC SAG or VATBook Problem?
<atc>
<callsign>LSAS_CTR</callsign>
<name>Markus Zuercher</name>
<time_start>2008-04-15 18:00:00</time_start>
<time_end>2008-04-15 20:00:00</time_end>
<cid>875941</cid>
<src_ip>81.62.156.116</src_ip>
<added>2008-04-07 21:45:16</added>
</atc>
<atc>
<callsign>LSAS_CTR</callsign>
<name>Markus Z</name>
<time_start>2008-04-15 18:00:00</time_start>
<time_end>2008-04-15 20:00:00</time_end>
<cid>0</cid>
<src_ip>91.54.71.30</src_ip>
<added>2008-04-07 21:45:15</added>
</atc>
und
<atc>
<callsign>LSGG_A_GND</callsign>
<name>Michael Stegmueller</name>
<time_start>2008-04-11 18:00:00</time_start>
<time_end>2008-04-11 20:00:00</time_end>
<cid>883648</cid>
<src_ip>127.255.255.255</src_ip>
<added>2008-04-04 22:18:04</added>
</atc>
<atc>
<callsign>LSGG_A_GND</callsign>
<name>Michael Stegm</name>
<time_start>2008-04-11 18:00:00</time_start>
<time_end>2008-04-11 20:00:00</time_end>
<cid>0</cid>
<src_ip>62.203.169.133</src_ip>
<added>2008-04-04 22:18:05</added>
</atc>

EDIT: note the different <src_ip>'s for the "same" entry..

User avatar
Michal Rok
Five Star Club
Posts: 2440
Joined: Wed Aug 31, 2005 4:23 pm

Re: Double bookings - is it a problem of VATBOOK or VACC-SAG?

Post by Michal Rok » Tue Apr 08, 2008 2:31 pm

Definitely SAG.

I got two separate calls:

62.167.243.76 - - [08/Apr/2008:15:17:34 +0200] "GET /atc/insert.asp?Local_ID=27560&Local_URL=http://www.vacc-sag.org/eurobook/add.ph ... =0&voice=1 HTTP/1.1" 302 - "http://www.vacc-sag.org/?PAGE=booking_atc" "Mozilla/5.0 (Windows; U; Windows NT 5.1; de; rv:1.8.1.13) Gecko/20080311 Firefox/2.0.0.13"
91.33.204.140 - - [08/Apr/2008:15:17:34 +0200] "GET /atc/insert.asp?Local_ID=27560&Local_URL=http://www.vacc-sag.org/eurobook/retry. ... =0&voice=1 HTTP/1.1" 302 - "http://www.vacc-sag.org/eurobook/" "Mozilla/5.0 (Windows; U; Windows NT 5.1; de; rv:1.8.1.13) Gecko/20080311 Firefox/2.0.0.13"

Note two different IPs, same time and different spelling of your last name. Apparently different software versions, because one provided CID and the other did not.


Michal

Markus Zürcher
Posts: 6
Joined: Mon Feb 11, 2008 6:48 pm

Re: Double bookings - is it a problem of VATBOOK or VACC-SAG?

Post by Markus Zürcher » Tue Apr 08, 2008 2:56 pm

Thx Michal, I'll forward that to our Webmaster...

Post Reply