Help changing MyISAM engine to InnoDB during installation


#1

Hi guys, can anybody help me with this issue?
I’m getting an error when I try to install Pimcore 5. I’m using Azure Database for MySQL Server (5.7)

The error is due to Azure Database for my SQL Server only supports InnoDB engine. So, I have to change the engine used during the installation from MyISAM to InnoDB.

How can I change the engine used in this query?

This is the error:
An exception occurred while executing ‘CREATE TABLE application_logs ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, pid INT(11) NULL DEFAULT NULL, timestamp datetime NOT NULL, message varchar(1024) DEFAULT NULL, priority ENUM(‘emergency’,‘alert’,‘critical’,‘error’,‘warning’,‘notice’,‘info’,‘debug’) DEFAULT NULL, fileobject varchar(1024) DEFAULT NULL, info varchar(1024) DEFAULT NULL, component varchar(190) DEFAULT NULL, source varchar(190) DEFAULT NULL, relatedobject int(11) unsigned DEFAULT NULL, relatedobjecttype enum(‘object’,‘document’,‘asset’) DEFAULT NULL, maintenanceChecked tinyint(4) DEFAULT NULL, PRIMARY KEY (id), KEY component (component), KEY timestamp (timestamp), KEY relatedobject (relatedobject), KEY priority (priority) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;’: SQLSTATE[HY000]: General error: 1030 Got error 1 from storage engine


#2

@nicomatute I’ll try to change MyISAM in this file

It is logs table so IMHO it isn’t big risk, but unfortunately I cannot guarranty how this table will work with InnoDb.

This is some kind of workaround but if it works IMHO it will be also great if you’ll create an issue (https://github.com/pimcore/pimcore/issues) with information about Azure problem and question can this table be permanently changed to InnoDb e.g.

I hope this helps,
Kind Regards :slight_smile:


#3

@mgomse
I tried with your suggestion and it worked perfectly. Really appreciate it.

Thank you so much for your help!