Bug With Mysql 5.7


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: install

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: [Download] [Hide] [Select]
SET storage_engine=MYISAM;


Replace by:
Code: [Download] [Hide] [Select]
SET defaultq_storage_engine=MYISAM;


And install is done :mryellow:

You will do update this bug :wink:

Subject: Re: Bug With Mysql 5.7
Thanks! Will page @MG with that.

Profile PM  
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


Page 1 of 1


  
You cannot post new topics
You cannot reply to topics
You cannot edit your posts
You cannot delete your posts
You cannot vote in polls
You cannot attach files
You can download files
You cannot post calendar events

   

This is a "Lo-Fi" version of our main content. To view the full version with more information, formatting and images, please click here.

Powered by Icy Phoenix based on phpBB
Generation Time: 0.9644s (PHP: 2% SQL: 98%)
SQL queries: 16 - Debug Off - GZIP Enabled