LuxuryCEO Posted April 7, 2021 Report Share Posted April 7, 2021 Hello Guys Ive a big problem here i cant add schedules to my site if i do i get 2 errors one is There was an error adding the schedule, already exists DB error: Field 'route_details' doesn't have a default value << fixing that by adding NULL to the schedules database will result with this one >> There was an error adding the schedule, already exists DB error: Incorrect double value: '' for column luxuryai_phpvms.phpvms_schedules.payforflight at row 1 i also have the Aircraft market Mod on my site Can No Longer add Aircraft have tried adding the Airbus A220-300 to the Airbus Market 3 times the site said Aircraft added but when i checked it was a no show also we can book a flight and fly it with Smartcars but when we land and go to file the pirep guess what it fails to send or doesn't show up in admin for us to accept please help me here am at a dead end and i need this fixed asap if you need to ive attached pictures below Phpvms Version 5.5.2.72 simpilot/php7.2 Theme is : Stislaskin if you require an admin account on the site please pm me asap regards Michael Quote Link to comment Share on other sites More sharing options...
Administrators ProAvia Posted April 8, 2021 Administrators Report Share Posted April 8, 2021 What version of MySQL or MariaDB are you using? Shared hosting, VPS or other hosting? Quote Link to comment Share on other sites More sharing options...
LuxuryCEO Posted April 8, 2021 Author Report Share Posted April 8, 2021 (edited) 7 hours ago, ProAvia said: What version of MySQL or MariaDB are you using? Shared hosting, VPS or other hosting? Hi ProAvia MySQL Version10.3.28-MariaDB-cll-lve what i got off my cpanel hosts updated mysql so we could use Moodle for our Academy Services this happened recently never heard of MariaDB until phpvms7 soo i dont know much about it its paid Hosting By HostPresto been with them for a few years now Michael Edited April 8, 2021 by LuxuryCEO Quote Link to comment Share on other sites More sharing options...
Administrators ProAvia Posted April 8, 2021 Administrators Report Share Posted April 8, 2021 MariaDB is an alternate to MySQL. You have either MySql or MariaDB. phpVMS 5.5.2 and 5.5.2.72 hafe issues with MySql above 5.7.4 and MariaDB above 10.1 Mostly this is related to Strict Mode. Ask your hosting company to turn Strict Mode off. Quote Link to comment Share on other sites More sharing options...
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.