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

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

Postby 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
Andreas Fuchs
 
Posts: 32
Joined: Sat Jun 10, 2006 3:59 pm

Postby 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.php&b_day=13&b_month=07&b_year=2006&Controller=Andreas20Fuchs&Position=LSMU_TWR&sTime=1800&eTime=2000&T=0&E=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.php&b_day=13&b_month=07&b_year=2006&Controller=Andreas%20Fuchs&Position=LSMU_TWR&sTime=1800&eTime=2000&T=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.php&EU_ID=83674139

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
User avatar
Michal Rok
Five Star Club
 
Posts: 2431
Joined: Wed Aug 31, 2005 4:23 pm
Location: Warsaw, Poland

Postby 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
Andreas Fuchs
 
Posts: 32
Joined: Sat Jun 10, 2006 3:59 pm

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

Postby 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..
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?

Postby 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.php&b_day=08&b_month=04&b_year=2008&Controller=Markus%20Zuercher&cid=875941&Position=LSAS_CTR&sTime=1700&eTime=1715&T=0&E=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.php&b_day=08&b_month=04&b_year=2008&Controller=Markus%20Z%FCrcher&Position=LSAS_CTR&sTime=1700&eTime=1715&T=0&E=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
User avatar
Michal Rok
Five Star Club
 
Posts: 2431
Joined: Wed Aug 31, 2005 4:23 pm
Location: Warsaw, Poland

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

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

Thx Michal, I'll forward that to our Webmaster...
Markus Zürcher
 
Posts: 6
Joined: Mon Feb 11, 2008 6:48 pm


Return to VATBOOK

Who is online

Users browsing this forum: No registered users and 1 guest

cron