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

Yes

It even works on MySQL 8   😁

@bfarber

@bfarber

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

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.

Edited March 31, 20196 yr by Tom S.

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.

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.