Defect #1222

SQL installation problem for MySQL 5.7+

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

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

0%

Category:-
Target version:-
Affected version:4.3.2

Description

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;

History

#1 Updated by Magoni Bruno almost 4 years ago

  • Assignee set to Technical Committee

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

  • Assignee deleted (Technical Committee)

Also available in: Atom PDF