SQL installation problem for MySQL 5.7+
easySDI installation package returns SQL error when played under MySQL 5.7.x and maybe for lesser MySQL version...
Problem comes from easySDI core install.sql files whith
SET storage_engine=InnoDB; statement which must be replaced by
SET SESSION default_storage_engine=InnoDB; - MySQL storage engine variable's name has changed :-(
Fortunately ENGINE option in CREATE statement is still the same for last MySQL stable version; so it seems important now to check that all CREATE statements are mentionning such ENGINE option in install.sql file to guarantee correct easySDI database deployment.
Having a close look in same file about
-- force default collation for the same reason -- find how ?!statement
SET NAMES 'utf8' COLLATE 'utf_general_ci';should do the trick regarding http://dev.mysql.com/doc/refman/5.6/en/set-statement.html
and will replace the two current statements
SET NAMES 'utf8'; SET CHARACTER SET utf8;