Error 500: Error while rebuilding database

[Ashif Malayil]

Whenever i am trying to create a field i am getting this error, What may be the issue?

See log file for details :-

[2024-05-18 05:32:50] ALERT: Rebuild database fault: PDOException: SQLSTATE[HY000]: General error: 1709 Index column size too large. The maximum column size is 767 bytes in /var/www/html/vendor/doctrine/dbal/src/Driver/PDO/Connection.php:82 Stack trace: #0 /var/www/html/vendor/doctrine/dbal/src/Driver/PDO/Connection.php(82): PDO->query() #1 /var/www/html/vendor/doctrine/dbal/src/Connection.php(1035): Doctrine\DBAL\Driver\PDO\Connection->query() #2 /var/www/html/application/Espo/Core/Utils/Database/Schema/Schema.php(233): Doctrine\DBAL\Connection->executeQuery() #3 /var/www/html/application/Espo/Core/Utils/Database/Schema/SchemaProxy.php(53): Espo\Core\Utils\Database\Schema\Schema->rebuild() #4 /var/www/html/application/Espo/Core/DataManager.php(146): Espo\Core\Utils\Database\Schema\SchemaProxy->rebuild() #5 /var/www/html/application/Espo/Core/DataManager.php(115): Espo\Core\DataManager->rebuildDatabase() #6 /var/www/html/application/Espo/Controllers/FieldManager.php(103): Espo\Core\DataManager->rebuild() #7 /var/www/html/application/Espo/Core/Api/ActionProcessor.php(97): Espo\Controllers\FieldManager->postActionCreate() #8 /var/www/html/application/Espo/Core/Api/RequestProcessor.php(136): Espo\Core\Api\ActionProcessor->process() #9 /var/www/html/application/Espo/Core/Api/RequestProcessor.php(111): Espo\Core\Api\RequestProcessor->proceed() #10 /var/www/html/application/Espo/Core/Api/RequestProcessor.php(82): Espo\Core\Api\RequestProcessor->processInternal() #11 /var/www/html/application/Espo/Core/Api/Starter.php(103): Espo\Core\Api\RequestProcessor->process() #12 /var/www/html/vendor/slim/slim/Slim/Handlers/Strategies/RequestResponse.php(43): Espo\Core\Api\Starter->Espo\Core\Api\{closure}() #13 /var/www/html/vendor/slim/slim/Slim/Routing/Route.php(384): Slim\Handlers\Strategies\RequestResponse->__invoke() #14 /var/www/html/vendor/slim/slim/Slim/MiddlewareDispatcher.php(81): Slim\Routing\Route->handle() #15 /var/www/html/vendor/slim/slim/Slim/MiddlewareDispatcher.php(81): Slim\MiddlewareDispatcher->handle() #16 /var/www/html/vendor/slim/slim/Slim/Routing/Route.php(341): Slim\MiddlewareDispatcher->handle() #17 /var/www/html/vendor/slim/slim/Slim/Routing/RouteRunner.php(84): Slim\Routing\Route->run() #18 /var/www/html/vendor/slim/slim/Slim/Middleware/RoutingMiddleware.php(59): Slim\Routing\RouteRunner->handle() #19 /var/www/html/vendor/slim/slim/Slim/MiddlewareDispatcher.php(147): Slim\Middleware\RoutingMiddleware->process() #20 /var/www/html/vendor/slim/slim/Slim/Middleware/ErrorMiddleware.php(107): class@anonymous->handle() #21 /var/www/html/vendor/slim/slim/Slim/MiddlewareDispatcher.php(147): Slim\Middleware\ErrorMiddleware->process() Unminify assets or how to recreate t...o.min.js file? /var/www/html/vendor/slim/slim/Slim/MiddlewareDispatcher.php(81): class@anonymous->handle() Unminify assets or how to recreate t...o.min.js file? /var/www/html/vendor/slim/slim/Slim/App.php(215): Slim\MiddlewareDispatcher->handle() #24 /var/www/html/vendor/slim/slim/Slim/App.php(199): Slim\App->handle() Unminify assets or how to recreate t...o.min.js file? /var/www/html/application/Espo/Core/Api/Starter.php(79): Slim\App->run() how to upgrade ? /var/www/html/application/Espo/Core/ApplicationRunners/Api.php(49): Espo\Core\Api\Starter->start() how to upgrade ? /var/www/html/application/Espo/Core/Application/RunnerRunner.php(85): Espo\Core\ApplicationRunners\Api->run() #28 /var/www/html/application/Espo/Core/Application.php(78): Espo\Core\Application\RunnerRunner->run() #29 /var/www/html/public/api/v1/index.php(37): Espo\Core\Application->run() #30 {main} Next Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[HY000]: General error: 1709 Index column size too large. The maximum column size is 767 bytes in /var/www/html/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:26 Stack trace: #0 /var/www/html/vendor/doctrine/dbal/src/Driver/PDO/Connection.php(87): Doctrine\DBAL\Driver\PDO\Exception::new() #1 /var/www/html/vendor/doctrine/dbal/src/Connection.php(1035): Doctrine\DBAL\Driver\PDO\Connection->query() #2 /var/www/html/application/Espo/Core/Utils/Database/Schema/Schema.php(233): Doctrine\DBAL\Connection->executeQuery() #3 /var/www/html/application/Espo/Core/Utils/Database/Schema/SchemaProxy.php(53): Espo\Core\Utils\Database\Schema\Schema->rebuild() #4 /var/www/html/application/Espo/Core/DataManager.php(146): Espo\Core\Utils\Database\Schema\SchemaProxy->rebuild() #5 /var/www/html/application/Espo/Core/DataManager.php(115): Espo\Core\DataManager->rebuildDatabase() #6 /var/www/html/application/Espo/Controllers/FieldManager.php(103): Espo\Core\DataManager->rebuild() #7 /var/www/html/application/Espo/Core/Api/ActionProcessor.php(97): Espo\Controllers\FieldManager->postActionCreate() #8 /var/www/html/application/Espo/Core/Api/RequestProcessor.php(136): Espo\Core\Api\ActionProcessor->process() #9 /var/www/html/application/Espo/Core/Api/RequestProcessor.php(111): Espo\Core\Api\RequestProcessor->proceed() #10 /var/www/html/application/Espo/Core/Api/RequestProcessor.php(82): Espo\Core\Api\RequestProcessor->processInternal() #11 /var/www/html/application/Espo/Core/Api/Starter.php(103): Espo\Core\Api\RequestProcessor->process() #12 /var/www/htm... [] []

[shalmaxb]

Try this: https://forum.espocrm.com/forum/inst...ding-to-6-0-10

[eymen-elkum]

The issue is you have lot of varchar fields on some of your entities, set the max lengths for them, the default is 255 as I think, you need some optimisation on it