Error on create field 1116 Too many tables; MySQL can only use 61 tables

[DSM]

Hello, I´m using espocrm 4.2.7 and create field show this error:

[2017-05-30 23:08:40] Espo.ERROR: API [GET]:/:controller, Params:Array ( [controller] => InformeJuridico ) , InputData: - SQLSTATE[HY000]: General error: 1116 Too many tables; MySQL can only use 61 tables in a join [] []
[2017-05-30 23:08:40] Espo.ERROR: Display Error: SQLSTATE[HY000]: General error: 1116 Too many tables; MySQL can only use 61 tables in a join, Code: HY000 URL: /crm/api/v1/InformeJuridico?maxSize=20&offset=0&sortBy=created At&asc=false [] []

How to fix it?

thank you

[tanya]

Hello
Check the structure of your data. Also you can attach your custom folder here

[DSM]

Hello, after that error, I have redone the CRM, and I get the same error.

[2017-07-10 20:49:43] Espo.ERROR: API [GET]:/:controller/:id/:link, Params:Array ( [controller] => Cliente [id] => 5948505a54a4d8b7f [link] => hipotecas ) , InputData: - SQLSTATE[HY000]: GeneralMySQL can only use 61 tables in a join [] []
[2017-07-10 20:49:43] Espo.ERROR: Display Error: SQLSTATE[HY000]: General error: 1116 Too many tables; MySQL can only use 61 tables in a join, Code: HY000 URL: /crm/api/v1/Cliente/5948505a54a4d8b7f/hipotecaset=0&sortBy=createdAt&asc=false [] []

I attach the complete folder.


Thanks.

[tanya]

Hello
try to add manually to your file fields the parameter "noJoin": true in entityDefs (custom/Espo/Custom/Resources/metadata/entityDefs) and Rebuild
I recommend you to create a copy of your instance like developer one and test it there. if everything goes right, move the changes to the production

[DSM]

Hello,

I add this parameter to json. But show same error.

thanks

[tanya]

Try this

[DSM]

It works! Thank you.
I had put the nojoin in a wrong place. Sorry.

Thanks again.

[DSM]

Hello Tanya,

I am having the same error again when creating an attachment field. The field is created in the database but it does not appear in the configuration files, I have tried to add it manually, but it does not work.

can you help me? thanks.

[2017-08-05 17:25:53] Espo.ALERT: Rebuild database fault: exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1069 Too many keys specified; max 64 keys allowed' 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 INDEX ID...') #1 /var/www/html/crm/application/Espo/Core/Utils/Database/Schema/Schema.php(215): Doctrine\DBAL\Connection->executeQuery('CREATE INDEX ID...') #2 /var/www/html/crm/application/Espo/Core/DataManager.php(93): Espo\Core\Utils\Database\Schema\Schema->rebuild('Hipoteca') #3 /var/www/html/crm/application/Espo/Core/DataManager.php(60): Espo\Core\DataManager->rebuildDatabase('Hipoteca') #4 /var/www/html/crm/application/Espo/Controllers/FieldManager.php(71): Espo\Core\DataManager->rebuild('Hipoteca') #5 /var/www/html/crm/application/Espo/Core/ControllerManager.php(116): Espo\Controllers\FieldManager->postActionCreate(Array, Array, Object(Slim\Http\Request)) #6 /var/www/html/crm/application/Espo/Core/Application.php(226): Espo\Core\ControllerManager->process('FieldManager', 'create', Array, '{"type":"file",...', Object(Slim\Http\Request)) #7 [internal function]: Espo\Core\Application->Espo\Core\{closure}(NULL) #8 /var/www/html/crm/vendor/slim/slim/Slim/Slim.php(1175): call_user_func(Object(Closure), NULL) #9 /var/www/html/crm/vendor/slim/slim/Slim/Slim.php(1315): 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(112): 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 exception 'Doctrine\DBAL\DBALException' with message 'An exception occurred while executing 'CREATE INDEX IDX_B666D7A6ACECD2C4 ON `hipoteca` (grabacion_cuestionario_inicial_id)': SQLSTATE[42000]: Syntax error or access violation: 1069 Too many keys specified; max 64 keys allowed' 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 INDEX ID...', Array) #1 /var/www/html/crm/application/Espo/Core/Utils/Database/Schema/Schema.php(215): Doctrine\DBAL\Connection->executeQuery('CREATE INDEX ID...') #2 /var/www/html/crm/application/Espo/Core/DataManager.php(93): Espo\Core\Utils\Database\Schema\Schema->rebuild('Hipoteca') #3 /var/www/html/crm/application/Espo/Core/DataManager.php(60): Espo\Core\DataManager->rebuildDatabase('Hipoteca') #4 /var/www/html/crm/application/Espo/Controllers/FieldManager.php(71): Espo\Core\DataManager->rebuild('Hipoteca') #5 /var/www/html/crm/application/Espo/Core/ControllerManager.php(116): Espo\Controllers\FieldManager->postActionCreate(Array, Array, Object(Slim\Http\Request)) #6 /var/www/html/crm/application/Espo/Core/Application.php(226): Espo\Core\ControllerManager->process('FieldManager', 'create', Array, '{"type":"file",...', Object(Slim\Http\Request)) #7 [internal function]: Espo\Core\Application->Espo\Core\{closure}(NULL) #8 /var/www/html/crm/vendor/slim/slim/Slim/Slim.php(1175): call_user_func(Object(Closure), NULL) #9 /var/www/html/crm/vendor/slim/slim/Slim/Slim.php(1315): 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(112): 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} [] []
[2017-08-05 17:25:54] Espo.ERROR: API [POST]:/Admin/fieldManager/:scope, Params:Array ( [scope] => Hipoteca ) , InputData: {"type":"file","required":false,"dynamicLogicVisib le":null,"dynamicLogicRequired":null,"dynamicLogic ReadOnly":null,"name":"grabacionCuestionarioInicia l","label":"Grabacion cuestionario inicial","tooltipText":"","sourceList":[],"tooltip":false} - Error while rebuilding database. See log file for details. [] []
[2017-08-05 17:25:54] Espo.ERROR: Display Error: Error while rebuilding database. See log file for details., Code: 500 URL: /crm/api/v1/Admin/fieldManager/Hipoteca [] []

[tanya]

Do you try it in current version (4.8.1)?