is pw 2.7.3 not compatible with mysql 5.7.12?

[adrianmak]

I ve a fresh pw 2.7.3 installation on fresh installation of ubuntu 16.04

The stock mysql version is  5.7.12 and php version is 7.0.4

However, I got a bunch of sql error during installation

[Robin S]

Just a guess: there might be a setting in sql_mode that PW doesn't like.

Maybe NO_ZERO_DATE or NO_ZERO_IN_DATE - I'm not sure what the PW requirements are regarding sql_mode settings.

[gebeer]

@adrianmak We're ecperiencing problems on a PW 2.7.0 install after MySQL upgrade to 5.7. Do you have any further findings, are PW 2.7 and MySQL 5.7 versions not compatible or did you get it to work?

[Robin S]

2 hours ago, gebeer said:

We're ecperiencing problems on a PW 2.7.0 install after MySQL upgrade to 5.7

Maybe you can update to PW 2.8.x? More recent versions of PW have fixed some MySQL 5.7 issues and make some SQL mode settings in /wire/config.php.

[gebeer]

@Robin S 

Thanks for the tip.

In 3.x there is a setting 

$config->dbSqlModes = array(
	"5.7.0" => "remove:STRICT_TRANS_TABLES,ONLY_FULL_GROUP_BY"
);

in https://github.com/processwire/processwire/blob/master/wire/config.php#L869

But it seems that 2.8 is not supporting those mode settings. At least I cant find anything related in https://github.com/processwire/processwire-legacy/blob/master/wire/core/WireDatabasePDO.php or https://github.com/processwire/processwire-legacy/blob/master/wire/config.php

[LostKobrakai]

Try this:

https://github.com/processwire/processwire-issues/issues/28#issuecomment-252870084

[gebeer]

@LostKobrakai That did the trick. Site is back to normal now. Thanks a lot!