Fltbook V2 Cannot Add Aircraft

[xrb936]

Hi guys, I was trying to add Fltbook V2 to my Phpvms 5.5.2.72 and import fltbook.sql file to database. However, I realized that after I install it, I cannot add aircraft via admin panel anymore.

 

To be more specific, it is caused by /core/comman/PIREPData.class.php. Looks like this mod changed this file and add one line:

FltbookData::updateAircraftLocation($pirep_details->aircraftid, $pirep_details->arricao);

If I removed it, everything is OK then. Can anyone please help me out? Thanks a lot.

[webrandustry]

Hello,

You can show the code in `PIREPData.class.php`

The `FltbookData.class.php` does not contain any class such as `updateAircraftLocation()`

Reference : https://github.com/web541/phpVMS-FltbookSystem/blob/master/core/common/FltbookData.class.php

[xrb936]

  On 10/24/2020 at 7:27 AM, webrandustry said:

Hello,

You can show the code in `PIREPData.class.php`

The `FltbookData.class.php` does not contain any class such as `updateAircraftLocation()`

Reference : https://github.com/web541/phpVMS-FltbookSystem/blob/master/core/common/FltbookData.class.php

Expand  

I see. But why that mod has that file modified? And also, I just realized that I cannot either add any route either...

[xrb936]

  On 10/24/2020 at 7:27 AM, webrandustry said:

Hello,

You can show the code in `PIREPData.class.php`

The `FltbookData.class.php` does not contain any class such as `updateAircraftLocation()`

Reference : https://github.com/web541/phpVMS-FltbookSystem/blob/master/core/common/FltbookData.class.php

Expand  

Uh I see. You were checking the v1, but I am using v2 now.

[webrandustry]

  On 10/24/2020 at 8:40 AM, xrb936 said:

Uh I see. You were checking the v1, but I am using v2 now.

Expand  

Oh sorry

So regarding the error you are getting, have you imported the fltbook.sql file in your database?

If yes, make sure, you have a column name 'location' in the phpvms_aircraft table.

 

[xrb936]

  On 10/24/2020 at 8:52 AM, webrandustry said:

Oh sorry

So regarding the error you are getting, have you imported the fltbook.sql file in your database?

If yes, make sure, you have a column name 'location' in the phpvms_aircraft table.

 

Expand  

Yes I have...🤣😍

[webrandustry]

Ahh okay, got the issue.

Go to phpvms_aircraft table -> Structure -> Select these two columns : 'airline' and 'location' -> CLick on change at the bottom -> Set Default for both as NULL in the dropdown.

 

That should solve the issue.

[xrb936]

  On 10/24/2020 at 9:10 AM, webrandustry said:

Ahh okay, got the issue.

Go to phpvms_aircraft table -> Structure -> Select these two columns : 'airline' and 'location' -> CLick on change at the bottom -> Set Default for both as NULL in the dropdown.

 

That should solve the issue.

Expand  

Uh thank you so much! You saved my life, or at least, half... I am still having problem with adding route. Kept getting error like:

There was an error adding the schedule, already exists DB error: Data truncated for column 'price' at row 1

 

[webrandustry]

  On 10/24/2020 at 9:35 AM, xrb936 said:

Uh thank you so much! You saved my life, or at least, half... I am still having problem with adding route. Kept getting error like:

There was an error adding the schedule, already exists DB error: Data truncated for column 'price' at row 1

 

Expand  

You're welcome

 

Do the same process I mentioned earlier for price column in phpvms_schedules

Edited October 24, 2020 by webrandustry

[xrb936]

  On 10/24/2020 at 2:27 PM, webrandustry said:

Do the same process I mentioned earlier for price column in phpvms_schedules

Expand  

Thanks, I figured it out!

[webrandustry]

  On 10/24/2020 at 2:28 PM, xrb936 said:

Thanks, I figured it out!

Expand  

Glad, you fixed it

 

[web541]

  On 10/24/2020 at 9:10 AM, webrandustry said:

Go to phpvms_aircraft table -> Structure -> Select these two columns : 'airline' and 'location' -> CLick on change at the bottom -> Set Default for both as NULL in the dropdown.

Expand  

This is fine for the location column, but the airline column should not be NULL at any point. If it is, then you need to re-install the module correctly as you may be missing some admin files otherwise it will not work as expected.