Defect #1222

SQL installation problem for MySQL 5.7+

Added by Magoni Bruno about 4 years ago. Updated about 4 years ago.

Status:NewStart date:12/09/2015
Priority:NormalDue date:
Assignee:-% Done:


Target version:-
Affected version:4.3.2


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
and will replace the two current statements
SET NAMES 'utf8';


#1 Updated by Magoni Bruno about 4 years ago

  • Assignee set to Technical Committee

#2 Updated by Van Hoecke Hélène about 4 years ago

  • Assignee deleted (Technical Committee)

Also available in: Atom PDF