Error 500: Error while rebuilding database. See log file for details.

[sarunijus]

Any more ideas, how can I fix database, Tanya? many thanks.

[tanya]

http://forum.espocrm.com/forum/general/27886-upgrade-not-working

do you have any prefixes in database tables?

[sarunijus]

No prefixes in database tables..I've already tried this : Possible it helps https://github.com/espocrm/espocrm/issues/217, not working.

[tanya]

Sorry, no any idea

[sarunijus]

thanks, I also installed fresh copy of espocrm 4.8.2, imported database tables from the main, but situation is the same. So it means I won't be able to upgrade to newer version, right?

[tanya]

Yes, and you won't be able even add new entity or fields....
What if you install new instance and check, if it will work?

[MediaBerg]

Hi Tanya,

same problem with version 5.5.6.

Here is the log:

[2019-03-05 08:30:41] Espo.ALERT: Rebuild database fault: PDOException: SQLSTATE[HY000]: General error: 1283 Column 'description' cannot be part of FULLTEXT index in/mywebsitename.de/crm/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:699 Stack trace: #0/mywebsitename.de/crm/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(699): PDO->query('CREATE FULLTEXT...') #1/mywebsitename.de/crm/application/Espo/Core/Utils/Database/Schema/Schema.php(196): Doctrine\DBAL\Connection->executeQuery('CREATE FULLTEXT...') #2/mywebsitename.de/crm/application/Espo/Core/DataManager.php(95): Espo\Core\Utils\Database\Schema\Schema->rebuild('Account') #3/mywebsitename.de/crm/application/Espo/Core/DataManager.php(62): Espo\Core\DataManager->rebuildDatabase('Account') #4/mywebsitename.de/crm/application/Espo/Controllers/FieldManager.php(71): Espo\Core\DataManager->rebuild('Account') #5/mywebsitename.de/crm/application/Espo/Core/ControllerManager.php(143): Espo\Controllers\FieldManager->postActionCreate(Array, Object(stdClass), Object(Slim\Http\Request), Object(Slim\Http\Response)) #6/mywebsitename.de/crm/application/Espo/Core/ControllerManager.php(159): Espo\Core\ControllerManager->processRequest(Object(Espo\Controllers\FieldManag er), 'create', Array, Object(stdClass), Object(Slim\Http\Request), Object(Slim\Http\Response)) #7/mywebsitename.de/crm/application/Espo/Core/Application.php(281): Espo\Core\ControllerManager->process('FieldManager', 'create', Array, '{"type":"varcha...', Object(Slim\Http\Request), Object(Slim\Http\Response)) #8 [internal function]: Espo\Core\Application->Espo\Core\{closure}() #9/mywebsitename.de/crm/vendor/slim/slim/Slim/Slim.php(1210): call_user_func_array(Object(Closure), Array) #10/mywebsitename.de/crm/vendor/slim/slim/Slim/Slim.php(1356): Slim\Slim->applyHook('slim.before.dis...') #11/mywebsitename.de/crm/vendor/slim/slim/Slim/Middleware/Flash.php(85): Slim\Slim->call() #12/mywebsitename.de/crm/vendor/slim/slim/Slim/Middleware/MethodOverride.php(92): Slim\Middleware\Flash->call() #13/mywebsitename.de/crm/application/Espo/Core/Utils/Api/Auth.php(138): Slim\Middleware\MethodOverride->call() #14/mywebsitename.de/crm/application/Espo/Core/Utils/Api/Slim.php(125): Espo\Core\Utils\Api\Auth->call() #15/mywebsitename.de/crm/application/Espo/Core/Application.php(93): Espo\Core\Utils\Api\Slim->run() #16/mywebsitename.de/crm/api/v1/index.php(33): Espo\Core\Application->run() #17 {main} Next Doctrine\DBAL\DBALException: An exception occurred while executing 'CREATE FULLTEXT INDEX IDX_SYSTEM_FULL_TEXT_SEARCH ON `account` (name, description, billing_address_city, billing_address_street, billing_address_country, billing_address_postal_code)': SQLSTATE[HY000]: General error: 1283 Column 'description' cannot be part of FULLTEXT index in/mywebsitename.de/crm/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:91 Stack trace: #0/mywebsitename.de/crm/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(702): Doctrine\DBAL\DBALException::driverExceptionDuring Query(Object(PDOException), 'CREATE FULLTEXT...', Array) #1/mywebsitename.de/crm/application/Espo/Core/Utils/Database/Schema/Schema.php(196): Doctrine\DBAL\Connection->executeQuery('CREATE FULLTEXT...') #2/mywebsitename.de/crm/application/Espo/Core/DataManager.php(95): Espo\Core\Utils\Database\Schema\Schema->rebuild('Account') #3/mywebsitename.de/crm/application/Espo/Core/DataManager.php(62): Espo\Core\DataManager->rebuildDatabase('Account') #4/mywebsitename.de/crm/application/Espo/Controllers/FieldManager.php(71): Espo\Core\DataManager->rebuild('Account') #5/mywebsitename.de/crm/application/Espo/Core/ControllerManager.php(143): Espo\Controllers\FieldManager->postActionCreate(Array, Object(stdClass), Object(Slim\Http\Request), Object(Slim\Http\Response)) #6/mywebsitename.de/crm/application/Espo/Core/ControllerManager.php(159): Espo\Core\ControllerManager->processRequest(Object(Espo\Controllers\FieldManag er), 'create', Array, Object(stdClass), Object(Slim\Http\Request), Object(Slim\Http\Response)) #7/mywebsitename.de/crm/application/Espo/Core/Application.php(281): Espo\Core\ControllerManager->process('FieldManager', 'create', Array, '{"type":"varcha...', Object(Slim\Http\Request), Object(Slim\Http\Response)) #8 [internal function]: Espo\Core\Application->Espo\Core\{closur... [] []

[2019-03-05 08:30:41] Espo.ERROR: API [POST]:/Admin/fieldManager/:scope, Params:Array ( [scope] => Account ) , InputData: {"type":"varchar","required":false,"trim":true,"dy namicLogicVisible":null,"dynamicLogicRequired":nul l,"dynamicLogicReadOnly":null,"name":"shopsystem", "label":"Shopsystem","tooltipText":null,"isPersona lData":false,"inlineEditDisabled":false,"default": null,"maxLength":null,"options":[],"audited":false,"readOnly":false,"tooltip":fal se} - Error while rebuilding database. See log file for details. [] []

[2019-03-05 08:30:41] Espo.ERROR: Display Error: Error while rebuilding database. See log file for details., Code: 500 URL: /crm/api/v1/Admin/fieldManager/Account [] []

What can I do to add a few more entities to company.

[Maximus]

Hello,
hope this will be helpful https://stackoverflow.com/questions/...fulltext-index

[MediaBerg]

Hi Maximus,

thanks for your quick reply. Do have a hint for a not database-geek?

Thanks,
Andreas

[Maximus]

Have you created some custom fields or change something in Espo directories before you faced this error? Do you use Espo on the cloud?

[MediaBerg]

I've tried to create a view custom fields in the company section. #Admin/fieldManager/scope=Account. ( Administration » Entität Manager » Firma » Felder)

Add mainly textboxes.

Some of them work. All others not. Always the same error Error 500: Error while rebuilding database. See log file for details.

I installed espo on a shared server
Error messages whilst setup:

max_execution_time	30	Fail (180 is recommended)
max_input_time	60	Fail (180 is recommended)
memory_limit	128M	Fail (256M is recommended)

all other success.

[Maximus]

I am pretty sure that this error is caused by bad changes in custom. Try to check this "Column 'description' cannot be part of FULLTEXT". Did you customized it? Check your JSON syntax.

[MediaBerg]

Do you mean this one?
And is this solution just for company (Firma) or all others entities as well?

[MediaBerg]

Works! Great Maximus. Thanks!!!!

[punkyard]

Hi, I was renaming labels when Espo started to slow down, displayed Error 500. I tried 'empty and rebuilt cache' : Error 500 error rebuiding database, see log file :

[2021-05-04 17:38:47] ALERT: Rebuild database fault: PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-structures (id INT AUTO_INCREMENT NOT NULL COLLATE `utf8_unicode_ci`, account_i' at line 1 in /home/plusjamaqn/lataache/rez0/vendor/doctrine/dbal/src/Driver/PDO/Connection.php:82 Stack trace: #0 /home/plusjamaqn/lataache/rez0/vendor/doctrine/dbal/src/Driver/PDO/Connection.php(82): PDO->query('CREATE TABLE sc...') #1 /home/plusjamaqn/lataache/rez0/vendor/doctrine/dbal/src/Connection.php(1035): Doctrine\DBAL\Driver\PDO\Connection->query('CREATE TABLE sc...') #2 /home/plusjamaqn/lataache/rez0/application/Espo/Core/Utils/Database/Schema/Schema.php(230): Doctrine\DBAL\Connection->executeQuery('CREATE TABLE sc...') #3 /home/plusjamaqn/lataache/rez0/application/Espo/Core/Utils/Database/Schema/SchemaProxy.php(53): Espo\Core\Utils\Database\Schema\Schema->rebuild() #4 /home/plusjamaqn/lataache/rez0/application/Espo/Core/DataManager.php(122): Espo\Core\Utils\Database\Schema\SchemaProxy->rebuild(NULL) #5 /home/plusjamaqn/lataache/rez0/application/Espo/Core/DataManager.php(93): Espo\Core\DataManager->rebuildDatabase(NULL) #6 /home/plusjamaqn/lataache/rez0/application/Espo/Controllers/Admin.php(54): Espo\Core\DataManager->rebuild() #7 /home/plusjamaqn/lataache/rez0/application/Espo/Core/ControllerManager.php(106): Espo\Controllers\Admin->postActionRebuild(Array, '', Object(Espo\Core\Api\RequestWrapper), Object(Espo\Core\Api\ResponseWrapper)) #8 /home/plusjamaqn/lataache/rez0/application/Espo/Core/Api/RouteProcessor.php(84): Espo\Core\ControllerManager->process('Admin', 'rebuild', Object(Espo\Core\Api\RequestWrapper), Object(Espo\Core\Api\ResponseWrapper)) #9 /home/plusjamaqn/lataache/rez0/application/Espo/Core/ApplicationRunners/Api.php(184): Espo\Core\Api\RouteProcessor->process('/Admin/rebuild', Object(Espo\Core\Api\RequestWrapper), Object(Espo\Core\Api\ResponseWrapper)) #10 /home/plusjamaqn/lataache/rez0/application/Espo/Core/ApplicationRunners/Api.php(112): Espo\Core\ApplicationRunners\Api->processRequest(Array, Object(Espo\Core\Api\RequestWrapper), Object(Espo\Core\Api\ResponseWrapper), Array) #11 /home/plusjamaqn/lataache/rez0/vendor/slim/slim/Slim/Handlers/Strategies/RequestResponse.php(43): Espo\Core\ApplicationRunners\Api->Espo\Core\ApplicationRunners\{closure}(Object(Sli m\Psr7\Request), Object(Slim\Psr7\Response), Array) #12 /home/plusjamaqn/lataache/rez0/vendor/slim/slim/Slim/Routing/Route.php(381): Slim\Handlers\Strategies\RequestResponse->__invoke(Object(Closure), Object(Slim\Psr7\Request), Object(Slim\Psr7\Response), Array) #13 /home/plusjamaqn/lataache/rez0/vendor/slim/slim/Slim/MiddlewareDispatcher.php(81): Slim\Routing\Route->handle(Object(Slim\Psr7\Request)) #14 /home/plusjamaqn/lataache/rez0/vendor/slim/slim/Slim/MiddlewareDispatcher.php(81): Slim\MiddlewareDispatcher->handle(Object(Slim\Psr7\Request)) #15 /home/plusjamaqn/lataache/rez0/vendor/slim/slim/Slim/Routing/Route.php(341): Slim\MiddlewareDispatcher->handle(Object(Slim\Psr7\Request)) #16 /home/plusjamaqn/lataache/rez0/vendor/slim/slim/Slim/Routing/RouteRunner.php(84): Slim\Routing\Route->run(Object(Slim\Psr7\Request)) #17 /home/plusjamaqn/lataache/rez0/vendor/slim/slim/Slim/Middleware/RoutingMiddleware.php(60): Slim\Routing\RouteRunner->handle(Object(Slim\Psr7\Request)) #18 /home/plusjamaqn/lataache/rez0/vendor/slim/slim/Slim/MiddlewareDispatcher.php(140): Slim\Middleware\RoutingMiddleware->process(Object(Slim\Psr7\Request), Object(Slim\Routing\RouteRunner)) #19 /home/plusjamaqn/lataache/rez0/vendor/slim/slim/Slim/Middleware/ErrorMiddleware.php(107): class@anonymous->handle(Object(Slim\Psr7\Request)) #20 /home/plusjamaqn/lataache/rez0/vendor/slim/slim/Slim/MiddlewareDispatcher.php(140): Slim\Middleware\ErrorMiddleware->process(Object(Slim\Psr7\Request), Object(class@anonymous)) #21 /home/plusjamaqn/lataache/rez0/vendor/slim/slim/Slim/MiddlewareDispatcher.php(81): class@anonymous->handle(Object(Slim\Psr7\Request)) #22 /home/plusjamaqn/lataache/rez0/vendor/slim/slim/Slim/App.php(215): Slim\MiddlewareDispatcher->handle(Object(Slim\Psr7\Request)) #23 /home/plusjamaqn/lataache/rez0/vendor/slim/slim/Slim/App.php(199): Slim\App->handle(Object(Slim\Psr7\Request)) #24 /home/plusjamaqn/lataache/rez0/application/Espo/Core/ApplicationRunners/Api.php(94): Slim\App->run() #25 /home/plusjamaqn/lataache/rez0/application/Espo/Core/Application.php(95): Espo\Core\ApplicationRunners\Api->run() #26 /home/plusjamaqn/lataache/rez0/api/v1/index.php(37): Espo\Core\Application->run('Espo\\Core\\Appli...') #27 {main} Next Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-structures (id INT AUTO_INCREMENT NOT NULL COLLATE `utf8_unicode_ci`, account_i' at line 1 in /home/... [] []