canceling a leasing contract fails

Please report Bugs and Problems here
Post Reply
gcl
Ticket Agent
Posts: 27
Joined: Fri Nov 16, 2018 4:58 pm

canceling a leasing contract fails

Post by gcl » Wed Jan 09, 2019 1:01 pm

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.
Image

ADAM-007
Flight Attendant
Posts: 78
Joined: Mon Jun 13, 2016 3:50 pm
Location: EGMC

Re: canceling a leasing contract fails

Post by ADAM-007 » Wed Jan 09, 2019 3:43 pm

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.
Image

User avatar
joefremont
FSAirlines Developer
Posts: 3694
Joined: Tue May 16, 2006 5:46 am
Location: KSFO

Re: canceling a leasing contract fails

Post by joefremont » Wed Jan 09, 2019 7:07 pm

Agreed, should be fixed now.
Image
I've sworn an oath of solitude until the pestilence is purged from the lands.

ADAM-007
Flight Attendant
Posts: 78
Joined: Mon Jun 13, 2016 3:50 pm
Location: EGMC

Re: canceling a leasing contract fails

Post by ADAM-007 » 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.
Image

User avatar
joefremont
FSAirlines Developer
Posts: 3694
Joined: Tue May 16, 2006 5:46 am
Location: KSFO

Re: canceling a leasing contract fails

Post by joefremont » Wed Jan 09, 2019 9:50 pm

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.
Image
I've sworn an oath of solitude until the pestilence is purged from the lands.

ADAM-007
Flight Attendant
Posts: 78
Joined: Mon Jun 13, 2016 3:50 pm
Location: EGMC

Re: canceling a leasing contract fails

Post by ADAM-007 » Thu Jan 10, 2019 10:46 am

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 3392 times
Image

gcl
Ticket Agent
Posts: 27
Joined: Fri Nov 16, 2018 4:58 pm

Re: canceling a leasing contract fails

Post by gcl » Thu Jan 10, 2019 11:28 am

I just returned the 789 manually, worked fine now.
Thank you
Image

Post Reply