Imanol Posted August 29, 2017 Report Posted August 29, 2017 (edited) Hi everyone, Since last week my virtual airline can not receive flights reports because the PIREPS function stopped working by surprise (manually or through smartCARS). I tried reinstalling the PIREPS module, the classes files and the whole site using the last version of phpVMS available but it does not work either. I contacted my hosting provider and after some tests they told me it could be a problem compatibility with MariaDB. Last Wednesday they updated their servers, including MariaDB, since then I have this issue. Here you have more details: SQL: 10.2.8-MariaDB phpMyAdmin: 4.7 Apache: 2.4.27 + LSAPI PHP 7.0.22 Could be this a problem with MariaDB? Edited August 29, 2017 by Imanol Quote
Moderators servetas Posted August 30, 2017 Moderators Report Posted August 30, 2017 PHP 7.0.22? phpVMS is compatible with PHP up to 5.6. Are you able to set your PHP back to 5.6? Quote
Imanol Posted August 30, 2017 Author Report Posted August 30, 2017 Hi @servetas, it's set to 5.6 but it does not work either. Acoording what my hosting provider said, this could be an imcopatibily problem with MariaDB. I tested phpVMS with 000webhost (With php 7.0 and a previews version of mariaDB) and it works perfectely. Quote
Cor Posted March 27, 2018 Report Posted March 27, 2018 I have the same problems now. Did you find the solution? PHP 5.6.34 and MariaDB 10.2.12 Regards, Cor Quote
yourairways Posted April 28, 2019 Report Posted April 28, 2019 On 3/29/2018 at 8:10 PM, Cor said: Solution back to MariaDB 10.1 Dear all It looks like this has hit our airline now. It all started after pilots were not able to file PIREPs with error "There was an error adding your PIREP : Schedule does not exist. Please update this manually.". As the error made no sence, I googeled for hrs., tried different steps, but nothing has worked so far. I have been contact with our hosting company and they sayd that they performed an update from MariaDB 10.1.38 to 10.3.14. rollback not possible. So it looks like it might be related. I am running phpvms 5.5.x @ http://efb.flying.ee/ with highly customized systems, not really ready to move to phpvms 7 yet. Rest of the site works perfectly, sending PIREPs is impossible. Is there anyone who can advise what to do further besides rollback or get another hosting company? There has to be a solution from our side as I can imagine that this problem will spread as MariaDB 10.3 is out since 2017? Waiting for a soonest reply. Quote
yourairways Posted April 29, 2019 Report Posted April 29, 2019 Dear all "Fixed" the problem by moving phpvms installation to fivedev hosting, but I guess another solution is needed to be future proof. BR Heigo Quote
Administrators Nabeel Posted April 29, 2019 Administrators Report Posted April 29, 2019 16 hours ago, yourairways said: Dear all It looks like this has hit our airline now. It all started after pilots were not able to file PIREPs with error "There was an error adding your PIREP : Schedule does not exist. Please update this manually.". As the error made no sence, I googeled for hrs., tried different steps, but nothing has worked so far. I have been contact with our hosting company and they sayd that they performed an update from MariaDB 10.1.38 to 10.3.14. rollback not possible. So it looks like it might be related. I am running phpvms 5.5.x @ http://efb.flying.ee/ with highly customized systems, not really ready to move to phpvms 7 yet. Rest of the site works perfectly, sending PIREPs is impossible. Is there anyone who can advise what to do further besides rollback or get another hosting company? There has to be a solution from our side as I can imagine that this problem will spread as MariaDB 10.3 is out since 2017? Waiting for a soonest reply. Is there an error log or possible to get the error from SQL? I was gonna ask what the sql error, etc, might be above this line: https://github.com/nabeelio/phpvms_v2/blob/88656de961463b46ce742c77455c67c5c06fdfac/core/modules/PIREPS/PIREPS.php#L127 Quote
yourairways Posted May 7, 2019 Report Posted May 7, 2019 Hi, could you please advise where to get/access the SQL error log? Did not find anything related from cPanel. There was nothing specific on error_log created by phpVMS itself. Quote
Administrators ProAvia Posted May 8, 2019 Administrators Report Posted May 8, 2019 (edited) phpVMS 5.5.2 won't install correctly using MySQL 5.7 While there are some incompatibilities and feature differences between Maria DB and MySQL........ Maria DB 10.2 is compatible with MySQL 5.7 Maria DB 10.0 is compatible with MySQL 5.6 https://mariadb.com/kb/en/library/mariadb-vs-mysql-compatibility/ Edited May 8, 2019 by ProAvia Quote
Administrators Nabeel Posted May 8, 2019 Administrators Report Posted May 8, 2019 16 hours ago, yourairways said: Hi, could you please advise where to get/access the SQL error log? Did not find anything related from cPanel. There was nothing specific on error_log created by phpVMS itself. Unfortunately, you'll have to edit the code where I pointed out so that you can output the exact message there. Unfortunately, it could just be that the code is just too "old" to support maria properly. As @ProAvia pointed out, though they're supposed to be compatible, there could still be issues in compat Quote
JohanVLC Posted August 21, 2019 Report Posted August 21, 2019 (edited) It seems we got this problem too. Any progress on how to solve this? We can't go back to an early version of MariaDB Fresh install. phpVMS 5.5.27, php7.2 Edited August 21, 2019 by JohanVFRclubNL Quote
Administrators ProAvia Posted August 21, 2019 Administrators Report Posted August 21, 2019 (edited) 1 hour ago, JohanVFRclubNL said: It seems we got this problem too. Any progress on how to solve this? We can't go back to an early version of MariaDB Fresh install. phpVMS 5.5.27, php7.2 Did you mean version 5.5.2.72 ? What version of php... 7.2.?? What version of Maria DB? Do you have the option of using MySQL instead of Maria DB? Edited August 21, 2019 by ProAvia Quote
JohanVLC Posted August 22, 2019 Report Posted August 22, 2019 9 hours ago, ProAvia said: Did you mean version 5.5.2.72 ? What version of php... 7.2.?? What version of Maria DB? Do you have the option of using MySQL instead of Maria DB? phpVMS: Version ##REVISION## 5.5.2.72 (phpVMS 5.5.2 for PHP 7.2) php version: 7.2.21 MariaDB-1:10.3.14 I have no option for MySQL Quote
Administrators ProAvia Posted August 22, 2019 Administrators Report Posted August 22, 2019 (edited) phpVMS 5.5.2.72 was tested with MySQL 5.6 and 5.7 - it was not tested with any versions of MariaDB. Are you able to change the version of MariaDB to 10.1 or 10.2? Can you downgrade you PHP version to 5.6? If so, install phpVMS 5.5.2 (Simpilot version). Who is you web hosting company? Here are a couple of links that may or may not help.... https://mariadb.com/kb/en/library/incompatibilities-and-feature-differences-between-mariadb-103-and-mysql-57/ https://mariadb.com/kb/en/library/mariadb-vs-mysql-compatibility/ EDIT - can you post any error_log files? Have you opened your browser console to see if any errors are posted there? Edited August 22, 2019 by ProAvia Error logs request Quote
Vincentxx Posted July 31, 2021 Report Posted July 31, 2021 Hello, Need anyone a working Solution? I have a Wirking Solution, but only Work on full access to the mysqld Config.. Regards, Quote
Strider Posted August 14, 2021 Report Posted August 14, 2021 This is due to strict mode being implemented, I had found a work around by putting INSERT IGNORE for all insert requests. Basically it comes down to the way phpvms stores the date and time of a pirep being filed. Using the INSERT IGNORE will allow the data to be submitted to the db as it ignores any error that is thrown up. It is not the best but for what i can see the only way to work around this problem if you do not have a VPS or dedicated server. As most hosts are reluctant to turn strict mode off. Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.