Tom S. Posted March 24, 2019 Share Posted March 24, 2019 Just to be on the safe side. Will the IPS software work as intended with MySQL 5.7? Link to comment Share on other sites More sharing options...
bfarber Posted March 25, 2019 Share Posted March 25, 2019 Yes Link to comment Share on other sites More sharing options...
b416 Posted March 29, 2019 Share Posted March 29, 2019 It even works on MySQL 8 😁 Link to comment Share on other sites More sharing options...
Tom S. Posted March 30, 2019 Author Share Posted March 30, 2019 @bfarber Link to comment Share on other sites More sharing options...
Tom S. Posted March 31, 2019 Author Share Posted March 31, 2019 @bfarber Link to comment Share on other sites More sharing options...
AndyF Posted March 31, 2019 Share Posted March 31, 2019 Until someone else replies they (appear) to be more like strict_mode errors, assuming its selectable in later mySQL versions. Link to comment Share on other sites More sharing options...
Tom S. Posted March 31, 2019 Author Share Posted March 31, 2019 2 hours ago, AndyF said: Until someone else replies they (appear) to be more like strict_mode errors, assuming its selectable in later mySQL versions. Thanks Andy. I was able to fix them easily myself. I posted them here just to make it clear that there may be issues that IPS are unaware of. MySQL 5.7 enables strict mode by default. So you have to set a default value for all fields that might not get a value set during an INSERT statement. Link to comment Share on other sites More sharing options...
Ryan Ashbrook Posted April 1, 2019 Share Posted April 1, 2019 We actually develop under strict mode (it's enforced through \IPS\Db when IN_DEV is enabled). This would be specific to your site. That column should have a default value of an empty string. Link to comment Share on other sites More sharing options...
bfarber Posted April 1, 2019 Share Posted April 1, 2019 Yes, what Ryan said. Beyond that, if you run into an issue using our software, it is typically better to submit a technical support ticket than to tag a specific developer here on the forums. We don't always have the ability to review everything and/or resolve issues reported here, where-as a ticket will ensure the issue is looked into and addressed, if needed. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.