Today marks Malaysia Virtual Airlines 10th birthday. We have had our ups and downs, our fair share of bumpy roads and heavy winds, we have hit some turbulance but have kept on flying.
Regards
Daniel Counahan
CEO of MVA
https://malaysiava.org
Most hosts will not regress to a lower MariaDB/Mysql db version as on shared there are other sites which regressing could break. The best option for that is a VPS or dedicated server. But I think your DB version could be the cause, but it doesn't sound like a problem with strict mode though. As that seems to be mainly causing problems with inserting data into the DB not displaying data. It could also be a modification you made and you made a slight error and the code is not displaying the data. And URL to your VA would be helpful so we can see exactly what is going on.
Is the airlines table populated? If so, check the code for those to see if it is pointing to the right table. Have you edited any of the code recently? Also have you fixed the problem?
I dont think xacars works with phpvms v7. There is one other freeware acars that works, but since phpvms v7 is only in beta all but one acars developers are not supporting phpvms v7 yet.
Thew link needs to point to that address, it seems in the error, the .org is missing, thus it is giving an error, look at the code and see if you can find where the code is going wrong.
Here is an example/template of asking for help.
Hi, I have a problem with my VA, site is not working the way it should can you help me
My database version is: MYSQL 5.7/MariaDB 10.2
PHPVMS 5.5.2/ 5.5.2.72
php version 5.6/7.x
Paid Hosting/freehosting
shared/VPS/Dedicated
I have installed X module recently/ made changes to X files.
Here is the link to my VA site http://myvasite.com/.net/.org
error you receiving goes here
Image of error is an alternative way of showing the error.
Regards
Insert name/username here
If you have an email with a different server, then you will need to setup it up in the local.config file, set the smtp settings to get the emails to go from that.
I have created a module to easily add a Discord Server widget to your VA It is very easy to use, saves you from having to create a page and get the iframe code and putting it in.
You can download it here
You can view a demo here
If this catches the bots then you don't need code for that, recaptcha should stop those bots registering, as they can't only fill out forms, not perform a recaptcha test.
This module allows you to very easily add your promo videos to your site. You just need to fill out a form on the admin panel and it is all done.
You can view a demo of it here
You can download it here
Firstly your host is very rude. Secondly, the script that worked before the upgrade is not sending invalid values, the DB is determining they are by itself. Thirdly disabling strict mode won't break sites that have worked fine even after the upgrade. Your host stinks of "I am too lazy to do it lets just tell them to modify the script."
If you have a VPS you can disable it via the Terminal or a SSH program such as Putty. In terminal type the following:
nano -w /etc/my.cnf
the same with a SSH program. you should be able to edit the config for the db there. look for the line sql_mode= and delete what is there, save and then restart the SQL and strict mode should be off, if not you will have to ask your host.
MYSQL 5.7 can cause problems with phpvms as it by default enables strict mode, which will break your site as pireps will suddenly stop going through. You will need to contact your host to get them to disable it. If you have a VPS or dedicated server you can do that yourself via either the Terminal or an SSH client such as Putty. It seems more and more VA sites are coming up with this problem of PIREPS not submitting, but they get an email saying a PIREP has been filed.
If you have installed my latest module you will need to download the CodeShareData.class.php file and replace the one on your server with the new updated one.
I have created a fairly simple module that will allow you to add a playlist you have made in spotify and have it show on your VA web site, it has the iframe code already in place and just needs a few settings to be added to get it to work.
You can download it here
You can view a demo here
Different code requires different tags to mark commented out text. in php it can be for 1 line // or for multi line /* */ that is the same with javascript too. In html it is <!-- -->
I had edit the insert SQL code for the insertion of data into the db for you but you reinstalled phpvms again, and it would go back to what it was before. I had the pireps working and schedules working for you. Not quite sure why you decided a reinstall was then required after i had gotten those working for you. Ask to see if your host can disable strict mode as i think that might be your cause.
The only version of phpvms that will install without errors into php v7.3 is phpvms v7 which is only in beta testing right now. Make sure you have the settings correctly setup in the admin panel. You need to set the criteria to accept pireps, if it doesn't find or they are not setup it won't work.