Icy Phoenix :: View topic - Bug With Mysql 5.7

atmoner [ Sun 05 Feb, 2017 13:13 ]
Post subject: Bug With Mysql 5.7

I want to install last version of Icy Phoenix 2.2.0.105
But in install i get this erreur when i install database:

Small search on web for term "Unknown system variable 'storage_engine'":

Quote:
Using mysql 5.7 is the problem.

http://dev.mysql.com/doc/refman/5.7/en/mysql-nutshell.html

Removed features:
The storage_engine system variable. Use default_storage_engine instead.

So my question, where i can change the variable "storage_engine"? I have search in install folder but nothing....

EDIT
Ok! Find...
In install/schemas/mysql_schema.sql, search:

Code: [Hide] [Select]

SET storage_engine=MYISAM;

Replace by:

Code: [Hide] [Select]

SET defaultq_storage_engine=MYISAM;

And install is done

You will do update this bug

Informpro [ Mon 06 Feb, 2017 21:59 ]
Post subject: Re: Bug With Mysql 5.7

Thanks! Will page @MG with that.

Mighty Gorgon [ Tue 07 Feb, 2017 22:33 ]
Post subject: Re: Bug With Mysql 5.7

Hi, thank you for reporting, this has been already reported but not fixed yet.

I have fixed on my local package and I will update GITHUB soon with the fix.

Thank you very much for your help.

P.S.: there's a small typo on your replacement code... there's an extra Q

Icy Phoenix

General Support - Bug With Mysql 5.7