reed0427 Posted March 22, 2022 Report Share Posted March 22, 2022 Logged into my admin page, but for some reason I can't add an aircraft, or modify an existing aircraft. Little help? David Reed Historic Airline Group historicairlinegroup.com Quote Link to comment Share on other sites More sharing options...
Administrators ProAvia Posted March 22, 2022 Administrators Report Share Posted March 22, 2022 That's because your hosting is on MariaDB 10.2. phpVMS 5.5.2.72 has issues with importing with MariaDB 10.2 There is no solution at this point - except direct manipulation of the DB. This isn't for the faint of heart and shouldn't be attempted if you don't know exactly what you are doing. And you should back up the DB before even attempting. Quote Link to comment Share on other sites More sharing options...
reed0427 Posted March 23, 2022 Author Report Share Posted March 23, 2022 So what kind of options do we have? Quote Link to comment Share on other sites More sharing options...
Administrators ProAvia Posted March 23, 2022 Administrators Report Share Posted March 23, 2022 1 - quit changing/adding aircraft, schedules, etc. every 6 months 2 - direct DB manipulation - use caution with this 3 - start planning to upgrade to phpVMS v7 - a big undertaking given your present operation 4 - you already know the other option you've used in the past Quote Link to comment Share on other sites More sharing options...
DisposableHero Posted March 23, 2022 Report Share Posted March 23, 2022 I liked option 3. Given the fact that v7 offers multi airline out of the box and its flexibility for setup and usage, it may be a nice choice for future. Schedules, fleet, operations etc all can be multi airline and if needed relaxed or easily can be restrictive upon airline needs. (costly, needs vmsAcars license) Option 2 looks like the easiest solution, if the operator has enough database knowledge and have backups for worst cases. (free but risky, can be easy if you have enough knowledge) Option 1 is the easiest Quote Link to comment Share on other sites More sharing options...
Strider Posted March 25, 2022 Report Share Posted March 25, 2022 It is due to strict mode, there is a work around which i found that works, but it is not ideal. You just need to add IGNORE to all INSERT statements and it should work. If you have a VPS or dedicated you can turn strict mode off. You can ask your host to turn strict mode off, but 9 times out of 10 they won't do that as it can cause problems for other web sites that share the server your site is on. Quote Link to comment Share on other sites More sharing options...
Administrators ProAvia Posted March 26, 2022 Administrators Report Share Posted March 26, 2022 22 hours ago, Strider said: It is due to strict mode, there is a work around which i found that works, but it is not ideal. You just need to add IGNORE to all INSERT statements and it should work. If you have a VPS or dedicated you can turn strict mode off. You can ask your host to turn strict mode off, but 9 times out of 10 they won't do that as it can cause problems for other web sites that share the server your site is on. It's more than just a Strict Mode issue. Strict Mode is OFF in the MariaDB 10.2 instance he uses. It probably has more to due with an empty value in the default aircraft table for this specifc instance. Shared hosting is being used and Strict Mode has been verified as OFF by his host. But it's possible a similar hack will work - at least in the short term. 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.