It is telling you that there is no access for that username on the database. Make sure you create the database username and password, and give it all permissions. And use those exact username and password. case sensitive.
Check the error_log also try looking for where the schedule insert is located and put INSERT IGNORE where it actually inserts the data into the table. PHPVMS 5.5.2 will install on php v5.6 and phpvms 5.5.2.72 will install onto 7.1. PHPVMS 5.5.2 with some editing will work after installation on php 7.1. Anything higher with those two versions of phpvms has a high likely of having problems.
PHPVMS version? You need to make sure the code for the custom map points to the right table so gets the right info, and you need to be calling the correct files so it can connect to the db.
Please create your own topic, replying to other topics is not the best way to go, also since your problem is completely different to what this topic is about as well. Please have a look at
on how best to ask for help.
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