Error while rebuilding database.

[peterberlin]

hallo

We have activated the full-text search for the entity account.
When the database is rebuilt (administration), the error message appears (see above). The log file says:

[2018-08-13 12:46:29] Espo.INFO: SCHEMA, Execute Query: CREATE FULLTEXT INDEX IDX_SYSTEM_FULL_TEXT_SEARCH ON `account` (kundennummer_p, sage_e_kd_nr, name2, name, kundennummer_b, billing_address_city, billing_address_postal_code) [] []
[2018-08-13 12:46:29] Espo.ALERT: Rebuild database fault: PDOException: SQLSTATE[HY000]: General error: 1283 Column 'billing_address_city' cannot be part of FULLTEXT index in /var/www/html/crm/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:699 Stack trace: #0 /var/www/html/crm/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(699): PDO->query('CREATE FULLTEXT...') #1 /var/www/html/crm/application/Espo/Core/Utils/Database/Schema/Schema.php(196): Doctrine\DBAL\Connection->executeQuery('CREATE FULLTEXT...') #2 /var/www/html/crm/application/Espo/Core/DataManager.php(95): Espo\Core\Utils\Database\Schema\Schema->rebuild(NULL) #3 /var/www/html/crm/application/Espo/Core/DataManager.php(62): Espo\Core\DataManager->rebuildDatabase(NULL) #4 /var/www/html/crm/application/Espo/Controllers/Admin.php(51): Espo\Core\DataManager->rebuild() #5 /var/www/html/crm/application/Espo/Core/ControllerManager.php(118): Espo\Controllers\Admin->postActionRebuild(Array, '', Object(Slim\Http\Request)) #6 /var/www/html/crm/application/Espo/Core/Application.php(227): Espo\Core\ControllerManager->process('Admin', 'rebuild', Array, '', Object(Slim\Http\Request)) #7 [internal function]: Espo\Core\Application->Espo\Core\{closure}() #8 /var/www/html/crm/vendor/slim/slim/Slim/Slim.php(1210): call_user_func_array(Object(Closure), Array) #9 /var/www/html/crm/vendor/slim/slim/Slim/Slim.php(1356): Slim\Slim->applyHook('slim.before.dis...') #10 /var/www/html/crm/vendor/slim/slim/Slim/Middleware/Flash.php(85): Slim\Slim->call() #11 /var/www/html/crm/vendor/slim/slim/Slim/Middleware/MethodOverride.php(92): Slim\Middleware\Flash->call() #12 /var/www/html/crm/application/Espo/Core/Utils/Api/Auth.php(121): Slim\Middleware\MethodOverride->call() #13 /var/www/html/crm/application/Espo/Core/Utils/Api/Slim.php(125): Espo\Core\Utils\Api\Auth->call() #14 /var/www/html/crm/application/Espo/Core/Application.php(88): Espo\Core\Utils\Api\Slim->run() #15 /var/www/html/crm/api/v1/index.php(33): Espo\Core\Application->run() #16 {main} Next Doctrine\DBAL\DBALException: An exception occurred while executing 'CREATE FULLTEXT INDEX IDX_SYSTEM_FULL_TEXT_SEARCH ON `account` (kundennummer_p, sage_e_kd_nr, name2, name, kundennummer_b, billing_address_city, billing_address_postal_code)': SQLSTATE[HY000]: General error: 1283 Column 'billing_address_city' cannot be part of FULLTEXT index in /var/www/html/crm/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:91 Stack trace: #0 /var/www/html/crm/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(702): Doctrine\DBAL\DBALException::driverExceptionDuring Query(Object(PDOException), 'CREATE FULLTEXT...', Array) #1 /var/www/html/crm/application/Espo/Core/Utils/Database/Schema/Schema.php(196): Doctrine\DBAL\Connection->executeQuery('CREATE FULLTEXT...') #2 /var/www/html/crm/application/Espo/Core/DataManager.php(95): Espo\Core\Utils\Database\Schema\Schema->rebuild(NULL) #3 /var/www/html/crm/application/Espo/Core/DataManager.php(62): Espo\Core\DataManager->rebuildDatabase(NULL) #4 /var/www/html/crm/application/Espo/Controllers/Admin.php(51): Espo\Core\DataManager->rebuild() #5 /var/www/html/crm/application/Espo/Core/ControllerManager.php(118): Espo\Controllers\Admin->postActionRebuild(Array, '', Object(Slim\Http\Request)) #6 /var/www/html/crm/application/Espo/Core/Application.php(227): Espo\Core\ControllerManager->process('Admin', 'rebuild', Array, '', Object(Slim\Http\Request)) #7 [internal function]: Espo\Core\Application->Espo\Core\{closure}() #8 /var/www/html/crm/vendor/slim/slim/Slim/Slim.php(1210): call_user_func_array(Object(Closure), Array) #9 /var/www/html/crm/vendor/slim/slim/Slim/Slim.php(1356): Slim\Slim->applyHook('slim.before.dis...') #10 /var/www/html/crm/vendor/slim/slim/Slim/Middleware/Flash.php(85): Slim\Slim->call() #11 /var/www/html/crm/vendor/slim/slim/Slim/Middleware/MethodOverride.php(92): Slim\Middleware\Flash->call() #12 /var/www/html/crm/application/Espo/Core/Utils/Api/Auth.php(121): Slim\Middleware\MethodOverride->call() #13 /var/www/html/crm/application/Espo/Core/Utils/Api/Slim.php(125): Espo\Core\Utils\Api\Auth->call() #14 /var/www/html/crm/application/Espo/Core/Application.php(88): Espo\Core\Utils\Api\Slim->run() #15 /var/www/html/crm/api/v1/index.php(33): Espo\Core\Application->run() #16 {main}

what do we have to do?
peter

[tarasm]

All columns from full text search should have the same collation. Open your database via phpmyadmin and check/change column collation.

[peterberlin]

thank you.
it works.