ProAvia

I don't know of a freeware one. You may want to check php-mods or Crazy Creatives for a payware option.

Chances are your PHP install isn't set up correctly or is missing a critical component. Another possibility is one or more file didn't transfer over successfully. Free or shared hosting? Best to keep all your issues in one thread at this point as they are most likely related.

I hesitate to post it here as it's not been tested and may not work. I will PM you.

phpVMS 5.5.2.72 works fine under PHP 7.0 to 7.2 - it has not ben fully tested on PHP 7.3 and higher (as per the readme). Most likely your issue has to do with MariaDB 10.3 - other users have reported issues with MariaDB above 10.1 . phpVMS 5.5.2.72 has not been fully tested on any MariaDB version - but seems to work fine on MariaDB 10.1 . In newer versions of MySQL (above 5.7.4) and MariaDB (above 10.1), most hosts have STRICT MODE set to ON. Ask your host to either turn STRICT MODE to OFF (many hosts wont do that) or downgrade you to the aforementioned MySQL/MariaDB versions or lower. Downgrading to another MySQL/MariaDB version usually means moving to another server or another host.

Changing versions of phpVMS didn't fix it.

fixed what and how? Sharing that here might just help someone else out in the future.

I think it's important to complete the request in this thread - - before moving on to another issue. Without knowing if your PHP is set up correctly, you are just running in circles.

Is this with phpVMS 5.5.2.72? What version of PHP? What version of MySQL or MariaDB?

I realize what Github says as I wrote that.... but it will also work with 7.0 and 7.1 usually. 7.2 is preferred. Suggest you create a phpinfo.php file and place in the root of your hosting temporarily https://mediatemple.net/community/products/dv/204643880/how-can-i-create-a-phpinfo.php-page Then send me your URL via the PM system here and I will check to see if your PHP is set up with the needed items.

I've never seen this error during installation. I did a new install just now and this error didn't show up. Possibly there is something not set up correctly with your hosts PHP installation. Do you hafe the option to change your PHP version from 7.2 to 7.0 or 7.1?

You are using: phpVMS 5.5.2.72 PHP 7.2 MySQL 5.6 What skin are you using - addon skin or default crystal skin? Have you added any modules? Have you changed or added to any files? Is this a brand new install with a brand new database? Post the contents of line 354 of your ezdb_mysqli.class.php file.

Have you read through this and made sure you have it set up correctly? https://docs.phpvms.net/concepts/finances

Crazy Creative has many nice modules. Their response time to customers is a bit slow. Since Charter Ops is a payware module, do not post any code from it or ask how to fix any issues you may have with it here in the public forum. Members who have the module can PM one another directly.

Did you try filing a new manual PIREP and one thru smartCARS? Be sure that you enter data in each field. Also, switch back to the default crystal skin and try there too.

Search the forums for ---- non static method After you fix those, see what other errors are left. Seems like you may be missing maybe 3 files as well.

kACARS_Free and smartCARS both work in MSFS and connect to phpVMS v5.5.2 just fine. You will need FSUIPC (free version). I would guess other ACARS will work as well, but have no first hand knowledge. vmsACARS will NOT work in V5.5.2 - only phpVMS v7.

Look in the console (F12) using Chrome. Chances are your host has Strict Mode on in MySQL 5.7 - ask them to turn it off.

Is error reporting on? Any errors showing in error_log file? Any errors showing in the console?

At my VA, staff are not a part of pilot ranks. Actually, all staff members have two log on accounts - one for staff and one for pilot. Why did we do it that way - no idea, that was over 19 years ago. I use a module to list staff and have the roster set to show only pilots.

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.