ProAvia

What happens if you use the same PHP version? Have you tried phpVMS 5.5.2.72 with PHP 7.1?

Have you tried on a fresh development install using the same phpVMS and PHP version?

Yeah - that high record number is a bit odd. Might be beneficial to undo any changes you've made in the past few days and see if it resolves itself. Other than that, I am out of ideas.

Maybe pull the codeshare module out and try it that way. Does your codeshare module have any DATE or DATETIME fields? I have no idea how it could send an email on a new submittal and show it on the front page without there being a DB entry.

Anything in your error_log file or in the console? What about the /admin error_log? That PIREP ID number is a strange issue. Any other table that they might be in?

A few members have reported issues with MariaDB 10.2 and higher - don't remember exactly what the issues were though. Rolling back to MariaDB 10.1 resolved the issues for them. Of course, rolling back is not an option for all though. I can't comment on your use of PHP 7.1 with phpVMS 5.5.2 - I know that 5.5.2 won't work for me on PHP 7.2 (that was my main reason for updating 5.5.2 to 5.5.2.72 as my host forced us to PHP 7.2). I have never heard of the info showing on the front page of the site and not being in the DB. Have you looked thru your DB tables to see if you can find the info? Obviously the data is getting to the site if a submittal email goes to you and the info is present on the front page. Wrong PIREP ID is strange too. What happens with a manual PIREP submittal? Maybe try a fresh install in a separate directory - keep it totally default and then tie it to your present DB to try to debug the issue. Any change this might have anything to do with your recently updated code share module or any others you may be using? I can't comment on your use of PHP 7.1 with phpVMS 5.5.2 - I know that 5.5.2 won't work for me on PHP 7.2 (that was my main reason for updating 5.5.2 to 5.5.2.72 as my host forced us to PHP 7.2). You could also try installing 5.5.2.72 on a test site and then tie your existing DB (or a copy of it) to that test install. There are a few minor DB changes between 5.5.2 and 5.5.2.72 - but those have to do with date and datetime default parameters for MySQL 5.7 and shouldn't cause any issues. But, you may wish to explore those changes as they may apply to MariaDB 10.3 as well.... https://stackoverflow.com/questions/45537777/phpvms-incorrect-date-value-0000-00-00-for-column-lastlogin-at-row-1/

Were PIREPS working properly prior to today or the last few days? Did your host happen to "upgrade" your PHP or MySQL/MariaDB version? What have you added/edited in the last week or so? Manual PIREPS, automated PIREPS (what ACARS program?), or both? Have you checked the error_log file in main phpVMS directory and in /admin directory for any errors? phpVMS version? PHP version? MySQL/MariaDB version? Maybe check to see if the PHP configuration has changed in the last week. Maybe create a phpinfo.php file to check. For others who read this that don't know how... https://www.hostinger.com/tutorials/how-to-create-phpinfo-file

Did you download the module from the link in the first post? If not, where did you get it from? The module files in the first post do include the template files. What version of phpVMS are you using? If phpVMS 5.5.2 or 5.5.2.72, you will need to convert the module files from .tpl to .php - this entails reviewing all the module files and changing any reference of .tpl to ,php and then renaming the template files from .tpl to .php

While it's a headache, we have been able to get 15+ addons to work just fine under PHP 7.2 . What we found is that many have similar errors and are easily fixed.

Are you using an ACARS program to allow pilots to submit their PIREPS? If so, what program is it? kACARS_Free, smartCARS, etc....... If using manual PIREPS, maybe your pilots are being impatient and double clicking the submit button or sending in duplicate manual PIREPS?? It would be best to contact your host to assist with setting up error reporting and the error_log file. There should be an error_log file in both the main phpVMS directory and the /admin directory. This allows general phpVMS errors to be logged in the main phpVMS directory file and admin specific errors to be logged in the /admin phpVMS directory. Chances are it may show errors in the admin side - and if so, we would need to see those to help you out. So talk with your host about setting that up and let us know.

What ACARS program are you using? Is error logging turned on? Are any error showing in the error_log file in the main phpVMS directory or in the /admin directory?

That would depend on what the PHP version is set to for the phpVMS directory. In my hosting, I can set the PHP version on a directory by directory basis as well as on a subdomain basis. You will need to contact your host to help you with that as hosting use varying methods to implement it.

You have to have at least one airport in the database - the default install adds KJFK as that default and I believe it also shows KJFK as a hub. You need to verify that error reporting is ON and that you have PHP set to log errors to a file named error_log that is usually located in the main phpVMS directory. Ask your host how to set all that up - as requirements may be different between hosts.

PHP 7.3 will not work with phpVMS versions less than version 7. It might be possible to set a lower PHP version for the phpVMS directory through your cPanel or other hosting panel. May wish to contact your host to help you our with that. If using phpVMS 5.5.2, set the PHP version for phpVMS to PHP 5.6 - if using phpVMS 5.5.2.72, set the PHP version for phpVMS to 7.0, 7.1 or 7.2

It is recommended not to add airports that you don't intend to have schedules to. Many times, phpVMS loads the entire airports table. Having 52,000+ airports will take a while to load. Although, this shouldn't have an effect in importing/adding aircraft. As for the Google "issue" - you will still see that occassionally as there is at least one map (maybe more) that a successful conversion to OSM/Leaflet maps does not remedy. But that should not affect aircraft import/add. Is there and error_log file?

You should be able to find it in cPanel - which may be your web hosting interface - on the right hand side under server information. Also maybe look on the initial page that loads when you go to phpMyAdmin for clues. Lastly, you could ask your host.

phpVMS version? PHP version? MySQL or MariaDB version? ACARS program and version?

It works on my site with phpVMS 5.5.2.72 under PHP 7.2 / MySQL 5.6 -- but my LoA.php file is a bit different. I'll look at it later today and let you know what I find.

Is error logging turned on? Are there any other errors not related to aircraft in the error_log file? Any issues adding airports or schedules?

Sorry, missed that connection... What version of the LoA module? Where did you download it from?

I was actually asking @djtiger76 After I get his response, I may have a solution which might benefit both of you.

What version of the module do you have? Where did you get it from? In local.config around line 23, post the complete DBASE_TYPE line

Have a look at my post again and also provide answers to the other 4 questions. After we have all that info, we should be able to assist you further.

Do you have error reporting turned on and is there anything in the error_log file? In some installs using PHP 7.2 (like mine) you need to add to the .user.ini file or php.ini file (located in same directory as phpVMS) to get the errors to show in error_log file. Have you checked the console in Chrome or any other browser to see if there are errors? Who is your webhost?

There is presently at least one ACARS in development and testing for phpVMS v7 (not a TFDI product). I would guess it will not be available until after phpVMS v7 has been released. There have been rumors that smartCARS will offer a version 3 that will also be compatible - but I haven't seen anything lately on the TFDI front.