Safe to upgrade to MySQL 5.7?

[Tom S.]

Just to be on the safe side. Will the IPS software work as intended with MySQL 5.7?

[bfarber]

Yes

[b416]

It even works on MySQL 8   😁

[Tom S.]

@bfarber

[Tom S.]

@bfarber

[AndyF]

Until someone else replies they (appear) to be more like strict_mode errors, assuming its selectable in later mySQL versions.

[Tom S.]

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.

[Ryan Ashbrook]

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.

[bfarber]

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.