Installation of Advanced Pack Fails

[tobias]

Hi there,

We cannot properly install Advanced Pack, the log show the following errors:

[2017-11-20 07:03:42] Espo.ALERT: Rebuild database fault: PDOException: SQLSTATE[HY000]: General error: 1030 Got error 1 from storage engine in D:\home\site\wwwroot\crm\vendor\doctrine\dbal\lib\Doctrine\DBAL\Connection.php:699 Stack trace: #0 D:\home\site\wwwroot\crm\vendor\doctrine\dbal\lib\Doctrine\DBAL\Connection.php(699): PDO->query('CREATE TABLE bp...') #1 D:\home\site\wwwroot\crm\application\Espo\Core\Utils\Database\Schema\Schema.php(215): Doctrine\DBAL\Connection->executeQuery('CREATE TABLE bp...') #2 D:\home\site\wwwroot\crm\application\Espo\Core\DataManager.php(93): Espo\Core\Utils\Database\Schema\Schema->rebuild(NULL) #3 D:\home\site\wwwroot\crm\application\Espo\Core\DataManager.php(60): Espo\Core\DataManager->rebuildDatabase(NULL) #4 D:\home\site\wwwroot\crm\application\Espo\Controllers\Admin.php(51): Espo\Core\DataManager->rebuild() #5 D:\home\site\wwwroot\crm\application\Espo\Core\ControllerManager.php(116): Espo\Controllers\Admin->postActionRebuild(Array, '', Object(Slim\Http\Request)) #6 D:\home\site\wwwroot\crm\application\Espo\Core\Application.php(226): Espo\Core\ControllerManager->process('Admin', 'rebuild', Array, '', Object(Slim\Http\Request)) #7 [internal function]: Espo\Core\Application->Espo\Core\{closure}() #8 D:\home\site\wwwroot\crm\vendor\slim\slim\Slim\Slim.php(1210): call_user_func_array(Object(Closure), Array) #9 D:\home\site\wwwroot\crm\vendor\slim\slim\Slim\Slim.php(1356): Slim\Slim->applyHook('slim.before.dis...') #10 D:\home\site\wwwroot\crm\vendor\slim\slim\Slim\Middleware\Flash.php(85): Slim\Slim->call() #11 D:\home\site\wwwroot\crm\vendor\slim\slim\Slim\Middleware\MethodOverride.php(92): Slim\Middleware\Flash->call() #12 D:\home\site\wwwroot\crm\application\Espo\Core\Utils\Api\Auth.php(112): Slim\Middleware\MethodOverride->call() #13 D:\home\site\wwwroot\crm\application\Espo\Core\Utils\Api\Slim.php(125): Espo\Core\Utils\Api\Auth->call() #14 D:\home\site\wwwroot\crm\application\Espo\Core\Application.php(88): Espo\Core\Utils\Api\Slim->run() #15 D:\home\site\wwwroot\crm\api\v1\index.php(33): Espo\Core\Application->run() #16 {main}  Next Doctrine\DBAL\DBALException: An exception occurred while executing 'CREATE TABLE bpmn_user_task (id VARCHAR(24) NOT NULL, name VARCHAR(255) DEFAULT NULL, deleted TINYINT(1) DEFAULT '0', action_type VARCHAR(255) DEFAULT NULL, resolution VARCHAR(255) DEFAULT '', is_resolved TINYINT(1) DEFAULT '0' NOT NULL, description LONGTEXT DEFAULT NULL, resolution_note LONGTEXT DEFAULT NULL, is_canceled TINYINT(1) DEFAULT '0' NOT NULL, created_at DATETIME DEFAULT NULL, modified_at DATETIME DEFAULT NULL, target_id VARCHAR(24) DEFAULT NULL, target_type VARCHAR(100) DEFAULT NULL, process_id VARCHAR(24) DEFAULT NULL, assigned_user_id VARCHAR(24) DEFAULT NULL, created_by_id VARCHAR(24) DEFAULT NULL, modified_by_id VARCHAR(24) DEFAULT NULL, flow_node_id VARCHAR(24) DEFAULT NULL, INDEX `target` (target_id, target_type), INDEX `IDX_344AC0987EC2F574` (process_id), INDEX `IDX_344AC098ADF66B1A` (assigned_user_id), INDEX `IDX_344AC098B03A8386` (created_by_id), INDEX `IDX_344AC09899049ECE` (modified_by_id), INDEX `IDX_344AC09853D5B5A` (flow_node_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = MyISAM':  SQLSTATE[HY000]: General error: 1030 Got error 1 from storage engine in D:\home\site\wwwroot\crm\vendor\doctrine\dbal\lib\Doctrine\DBAL\DBALException.php:91 Stack trace: #0 D:\home\site\wwwroot\crm\vendor\doctrine\dbal\lib\Doctrine\DBAL\Connection.php(702): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(PDOException), 'CREATE TABLE bp...', Array) #1 D:\home\site\wwwroot\crm\application\Espo\Core\Utils\Database\Schema\Schema.php(215): Doctrine\DBAL\Connection->executeQuery('CREATE TABLE bp...') #2 D:\home\site\wwwroot\crm\application\Espo\Core\DataManager.php(93): Espo\Core\Utils\Database\Schema\Schema->rebuild(NULL) #3 D:\home\site\wwwroot\crm\application\Espo\Core\DataManager.php(60): Espo\Core\DataManager->rebuildDatabase(NULL) #4 D:\home\site\wwwroot\crm\application\Espo\Controllers\Admin.php(51): Espo\Core\DataManager->rebuild() #5 D:\home\site\wwwroot\crm\application\Espo\Core\ControllerManager.php(116): Espo\Controllers\Admin->postActionRebuild(Array, '', Object(Slim\Http\Request)) #6 D:\home\site\wwwroot\crm\application\Espo\Core\Application.php(226): Espo\Core\ControllerManager->process('Admin', 'rebuild', Array, '', Object(Slim\Http\Request)) #7 [internal function]: Espo\Core\Application->Espo\Core\{closure}() #8 D:\home\site\wwwroot\crm\vendor\slim\slim\Slim\Slim.php(1210): call_user_func_array(Object(Closure), Array) #9 D:\home\site\wwwroot\crm\vendor\slim\slim\Slim\Slim.php(1356): Slim\Slim->applyHook('slim.before.dis...') #10 D:\home\site\wwwroot\crm\vendor\slim\slim\Slim\Middleware\Flash.php(85): Slim\Slim->call() #11 D:\home\site\wwwroot\crm\vendor\slim\slim\Slim\Middleware\MethodOverride.php(92): Slim\Middleware\Flash->call() #12 D:\home\site\wwwroot\crm\application\Espo\Core\Utils\Api\Auth.php(112): Slim\Middleware\MethodOverride->call() ... [] []
[2017-11-20 07:03:42] Espo.ERROR: API [POST]:/Admin/rebuild, Params:Array ( ) , InputData:  - Error while rebuilding database. See log file for details. [] []
[2017-11-20 07:03:43] Espo.ERROR: Display Error: Error while rebuilding database. See log file for details., Code: 500 URL: /api/v1/Admin/rebuild [] []

Espo runs as a web app on Microsoft Azure.

NB: MySQL for Azure does not allow MyISAM, which cause heaps of problems during migration. Given the above error logs, this seem to be the problem again.

How should we proceed?

- Tobias

[tanya]

Hello Tobias.
If I understand you right, you can't even create any new entity, because of engine. But MyISAM is default engine for EspoCRM.
open application/Espo/Core/Utils/Database/DBAL/Platforms/MySqlPlatform.php, find _getCreateTableSQL and modify it.
It is not upgrade safe hard code.
If I found any other solution, I will answer.

[tobias]

Hi Tanya,

Thanks for the hint, which seems to do the trick. We've documented the hack to remember for the next upgrade. What you could think of is to allow users to select their preferred storage engine.