Page 1 of 1

canceling a leasing contract fails

Posted: Wed Jan 09, 2019 1:01 pm
by gcl
Hi,
I cannot cancel a contract, the message is:

MySQL error Array ( [0] => Array ( [errno] => 1054 [sqlstate] => 42S22 [error] => Unknown column 'buy_fleet' in 'field list' ) )

MySQL query select l.ID, l.AC_ID, l.Sel_VAID, l.Buy_VAID, l.Dep_status, l.Deposit, l.HomeBase, l.LastPayment, from_unixtime(expire) as exp, expire, ((a.StateEng1 + a.StateEng2 + a.StateEng3 + a.StateEng4 + a.StateGear + a.StateHull) / (adb.Engines + 2) ) AS State, a.Location, a.Status, a.Registration, adb.Manufacturer, adb.Type, adb.Price, va.ID as sva_id, va.Name as sname, va2.ID as bva_id, va2.Name as bname, va.Official, fleet_id, sel_fleet, buy_fleet From (fsa_lease l, fsa_aircraft a, fsa_aircraft_db as adb) left join fsa_virtual_airline va on l.Sel_VAID=va.ID left join fsa_virtual_airline va2 on a.va_id = va2.id where l.ID = '123785' and l.AC_ID = a.ID and a.ACDB_ID = adb.ID

Just to inform you.

Re: canceling a leasing contract fails

Posted: Wed Jan 09, 2019 3:43 pm
by ADAM-007
I can second this.

Global is due to return two aircraft to us including the 787-9 which was cancelled by a CEO. and an A330 which is due to return to us as its lease has ran out.

Re: canceling a leasing contract fails

Posted: Wed Jan 09, 2019 7:07 pm
by joefremont
Agreed, should be fixed now.

Re: canceling a leasing contract fails

Posted: Wed Jan 09, 2019 8:30 pm
by ADAM-007
Looks like the A330 returned and I got a message about the 787 again but its not returned.

Re: canceling a leasing contract fails

Posted: Wed Jan 09, 2019 9:50 pm
by joefremont
ADAM-007 wrote:
Wed Jan 09, 2019 8:30 pm
Looks like the A330 returned and I got a message about the 787 again but its not returned.
Are we talking about G-ADBL? It looks like it's not supposed to be returned until June.

Re: canceling a leasing contract fails

Posted: Thu Jan 10, 2019 10:46 am
by ADAM-007
Hi Joe, Thats right, But Frank is returning it early manually and has tried twice.

Please see this screenshot:
G-ADBLReturn.PNG
G-ADBLReturn.PNG (18.21 KiB) Viewed 3447 times

Re: canceling a leasing contract fails

Posted: Thu Jan 10, 2019 11:28 am
by gcl
I just returned the 789 manually, worked fine now.
Thank you