ProAvia

Be aware that this is a v5 issue not v7 - your post has been moved to the v5 Support section. What MySQL or MariaDB version are you using?

One post would have been enough...... Maybe the author will see this and be able to help out.... @flyalaska

Great - thanks for reporting back what worked for you. There is no where I've found in the base installation that it's adding the 'airline' column in the aircraft table. I have checked with and without the APlookup code.

You aren't seeing in in the aircraft table cause it isn't present there. Something somewhere "thinks" it's supposed to be there - hence the error. I can't see where 'airline' is in the add aircraft code. I've checked the data class , module and templates. Have you edited: /core/common/OperationsData.class.php /admin/modules/Operations/Operations.php /admin/templates/ops_aircraftform.php ???? I think that is all the files that include the add aircraft code. Send me admin credentials so I can log into you phpvms admin panel

There is nothing in my phpVMS 5.5.2.72 or my APlookup files that you downloaded that have an 'airline' column in the aircraft table or the aircraft form. Are you adding aircraft manually or importing an aircraft file? Did you do any file edits exfept the APlookup mod?

APlookup shouldn't affect the aircraft. In looking at your table, you are missing the 'airline' field between 'maxcargo' and 'minrank'. Once you figure out how to add the 'airline' column in the correct position the add aircraft should work. I think the 'airline' column is supposed to be added with a specific module you are using (maybe a schedule search module?). What modules have you installed? As you can see in the error - there is no 'airline' entry available in the aircraft table. Notice the '' after '42505', ..... the '' is the missing airline , but you can't add it via add aircraft in the admin panel because it isn't there to be added. Again, guessing a module you added wasn't completely installed.

Look at the database table for aircraft - is there an 'airline' column? Actually, list all the columns in the aircraft table here for us. I see that 'downloadlink', 'imagelink' and 'airline' fields are blank. Insert even a single character in them. Use the letter 'A' in each of those blank fields and let us know what happens.

If you want - PM me admin login details and will have a quick look.

Chances are Hostinger will not turn Strict Mode OFF. Did you attempt to place data in each and every field of the add aircraft form?

You indicated you are on MariaDB 10.2 - check with your host and ask them to turn Strict Mode OFF. You might also try adding an aircraft again - but be sure each and every entry has something in it - even if that something is a space character.

Does it work if you are on the default crystal skin? You can't be on MySQL 5.6 and MariaDB 10.2 at the same time. Which is it? Google is your friend... search there for how to turn on error reporting in PHP.

Interestingly, some need the extra closing bracket - } - and some don't. I will review the APlookup when I have a chance to see if I may have missed a closing bracket.

Totally get that.... I posted that for others as I already know you understood that. It's that copyright and payware thing..... Hopefully someone who has it will PM you.

If anyone chooses to reply - use the PM function only. No discussion of payware modules allowed in public forums here.

I suggest you contact the skin developer.... 209 Studios. https://www.phpvms.209studios.com/

The developer of APVacars is not presently actively developing his ACARS. At present APVacars is NOT compatible with phpVMS v7. See quotes from developer above. There have been no updates on the status of APVacars since July 2020.

If you are using the BlueIce skin by 209 Studios, I suggest you contact the developer of that skin. https://www.phpvms.209studios.com/

It might help if you told us exactly what skin you are using.

Just to be clear - the README.MD file in phpVMS 5.5.2.72 does NOT instruct you to change anything in StatsData.class.php or any other file for that matter. What module or addon are you attempting to add to your phpVMS install?

Do you mean the phpVMS image? In /lib/skins/crystal/images - rename topbanner.jpg to topbanner.jpg.ORIG Copy/paste your image in this same folder and rename to topbanner.jpg If you are using an addon skin, you will need to find the associated banner and rename it in that skin folder.

If you are on shared hosting, you probably can't do any tweaks to PHP. Contact your host and have them set it up.

Do as Doug suggested and get the latest development build from the phpVMS discord. Using beta 4 just isn't going to cut it.

Did you verify you installed Leaflet/OSM correctly? Maybe check it again Any chance you tried changing the map or map provider? Did you change local.config - Config::Set ('MAP_TYPE'... to reflect "OpenStreetMap.Mapnik"? Line should read: Config::Set('MAP_TYPE', 'OpenStreetMap.Mapnik'); <---- need this one And the old line either deleted or commented out.... //Config::Set('MAP_TYPE', 'G_HYBRID_MAP');

Suggest you read this in its entirety - https://docs.phpvms.net/ Then re-read the installation section again Be sure your hosting supports the requirements

There is no free ACARS solution for phpVMS v7 at this time.