Install wizard fails with MySQL 5.7
There are two issues with the installation of toolkit on MySQL 5.7 Prior to 5.7, the default sql_mode was different and there are issues with zero dates, full group by etc. The following two issues need to be resolved:
-
Set sql_mode="". or fix the full joins and the like. The risk is that we may not be standard SQL complaint.
-
The default storage engine is InnoDB for sometime, but in the connection URL we are still setting InnoDB. This doesnt make sense because implementers might want to use XtraDB or another engine. So, we should remove the InnoDB selected from connection and leave it upto the implementer to choose the default storage engine. Fix the connection URL