ProAvia

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.

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.