5.3.0 install error

[serefkoca]

I have a error when installing Espocrm 5.3.0

‘Ajax Error’

[tanya]

Hi,

https://github.com/espocrm/documenta...bleshooting.md

Also check file permissions: https://github.com/espocrm/documenta...-based-systems

[shef]

I have the exact same issue. Check the screenshot.

None of the suggested solutions in the links tanya has provided work.

I checked the logs and I see this in the logs:

[2018-07-10 16:06:10] Espo.ALERT: Rebuild database fault: exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 1283 Column 'body_plain' cannot be part of FULLTEXT index' in /home/MY_DOMAIN/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:699 Stack trace: #0 /home/MY_DOMAIN/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(699): PDO->query('CREATE TABLE `e...') #1 /home/MY_DOMAIN/public_html/application/Espo/Core/Utils/Database/Schema/Schema.php(196): Doctrine\DBAL\Connection->executeQuery('CREATE TABLE `e...') #2 /home/MY_DOMAIN/public_html/application/Espo/Core/DataManager.php(95): Espo\Core\Utils\Database\Schema\Schema->rebuild(NULL) #3 /home/MY_DOMAIN/public_html/application/Espo/Core/DataManager.php(62): Espo\Core\DataManager->rebuildDatabase(NULL) #4 /home/MY_DOMAIN/public_html/install/core/Installer.php(236): Espo\Core\DataManager->rebuild() #5 /home/MY_DOMAIN/public_html/install/core/actions/buildDatabase.php(33): Installer->buildDatabase() #6 /home/MY_DOMAIN/public_html/install/index.php(146): include('/home/finconsul...') #7 {main}  Next exception 'Doctrine\DBAL\DBALException' with message 'An exception occurred while executing 'CREATE TABLE `email` (id VARCHAR(24) NOT NULL COLLATE utf8_unicode_ci, name VARCHAR(255) DEFAULT NULL COLLATE utf8_unicode_ci, deleted TINYINT(1) DEFAULT '0', from_name VARCHAR(255) DEFAULT NULL, from_string VARCHAR(255) DEFAULT NULL, reply_to_string VARCHAR(255) DEFAULT NULL, address_name_map MEDIUMTEXT DEFAULT NULL, is_replied TINYINT(1) DEFAULT '0' NOT NULL, message_id VARCHAR(255) DEFAULT NULL COLLATE utf8_unicode_ci, message_id_internal VARCHAR(300) DEFAULT NULL, body_plain MEDIUMTEXT DEFAULT NULL, body MEDIUMTEXT DEFAULT NULL, is_html TINYINT(1) DEFAULT '1' NOT NULL, status VARCHAR(255) DEFAULT 'Archived' COLLATE utf8_unicode_ci, has_attachment TINYINT(1) DEFAULT '0' NOT NULL, date_sent DATETIME DEFAULT NULL, delivery_date DATETIME DEFAULT NULL, created_at DATETIME DEFAULT NULL, modified_at DATETIME DEFAULT NULL, is_system TINYINT(1) DEFAULT '0' NOT NULL, from_email_address_id VARCHAR(24) DEFAULT NULL COLLATE utf8_unicode_ci, parent_id VARCHAR(24) DEFAULT NULL COLLATE utf8_unicode_ci, parent_type VARCHAR(100) DEFAULT NULL COLLATE utf8_unicode_ci, created_by_id VARCHAR(24) DEFAULT NULL COLLATE utf8_unicode_ci, sent_by_id VARCHAR(24) DEFAULT NULL COLLATE utf8_unicode_ci, modified_by_id VARCHAR(24) DEFAULT NULL COLLATE utf8_unicode_ci, assigned_user_id VARCHAR(24) DEFAULT NULL COLLATE utf8_unicode_ci, replied_id VARCHAR(24) DEFAULT NULL COLLATE utf8_unicode_ci, account_id VARCHAR(24) DEFAULT NULL COLLATE utf8_unicode_ci, INDEX `IDX_MESSAGE_ID` (message_id), INDEX `IDX_FROM_EMAIL_ADDRESS_ID` (from_email_address_id), INDEX `IDX_PARENT` (parent_id, parent_type), INDEX `IDX_CREATED_BY_ID` (created_by_id), INDEX `IDX_SENT_BY_ID` (sent_by_id), INDEX `IDX_MODIFIED_BY_ID` (modified_by_id), INDEX `IDX_ASSIGNED_USER_ID` (assigned_user_id), INDEX `IDX_REPLIED_ID` (replied_id), INDEX `IDX_ACCOUNT_ID` (account_id), INDEX `IDX_DATE_SENT` (date_sent, deleted), INDEX `IDX_DATE_SENT_STATUS` (date_sent, status, deleted), FULLTEXT INDEX `IDX_SYSTEM_FULL_TEXT_SEARCH` (name, body_plain, body), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB':  SQLSTATE[HY000]: General error: 1283 Column 'body_plain' cannot be part of FULLTEXT index' in /home/MY_DOMAIN/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:91 Stack trace: #0 /home/MY_DOMAIN/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(702): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(PDOException), 'CREATE TABLE `e...', Array) #1 /home/MY_DOMAIN/public_html/application/Espo/Core/Utils/Database/Schema/Schema.php(196): Doctrine\DBAL\Connection->executeQuery('CREATE TABLE `e...') #2 /home/MY_DOMAIN/public_html/application/Espo/Core/DataManager.php(95): Espo\Core\Utils\Database\Schema\Schema->rebuild(NULL) #3 /home/MY_DOMAIN/public_html/application/Espo/Core/DataManager.php(62): Espo\Core\DataManager->rebuildDatabase(NULL) #4 /home/MY_DOMAIN/public_html/install/core/Installer.php(236): Espo\Core\DataManager->rebuild() #5 /home/MY_DOMAIN/public_html/install/core/actions/buildDatabase.php(33): Installer->buildDatabase() #6 /home/MY_DOMAIN/public_html/install/index.php(146): include('/home/MY_DOMAIN...') #7 {main} [] []

Is there any way to overcome this issue?

[tarasm]

What is your version of MySQL?

[shef]

tarasm this is the MySQL version:

Server version: 5.6.39-log - MySQL Community Server (GPL)

[tarasm]

It's a bug for MySQL 5.6. Please download a new version of EspoCRM 5.3.1, https://www.espocrm.com/download/.

[shef]

Works like a charm. Thanks!