Field type currency, why does it affects, General error: 1116

[Russ]

Hey guys, trying to add a field with type currency, to the "Opportunity" record type, once I am doing that, immediately get error 500, the only thing that helps to remove this error and make the system functional again, is to delete that "Currency type field".

Digging logs helped me understand the cause of Error 500:
"General error: 1116 Too many tables; MariaDB can only use 61 tables in a join"

I am not joining any tables, not creating any relations, just adding a new field type, is there any way to bypass this?

Thanks

[Kharg]

I think you will have to wait till Espo 7.3.0

https://github.com/espocrm/espocrm/issues/2535

[yuri]

See https://github.com/espocrm/documenta...bles-in-a-join

[victor]

Hi Russ,

Kharg and yuri are right.

• It is necessary to change the content in application/Espo/Core/Utils/Database/Orm/Fields/Currency.php to https://github.com/espocrm/espocrm/b...s/Currency.php
• In data/config.php add

  'currencyNoJoinMode' => true,

• Cleare Cashe or make Rebuild.

Also inspect Foreign fields in various entities (especially custom ones). Make sure that the Foreign type field of Entity A is NOT combined with the Foreign type field of Entity B. If such fields were accidentally created, they must be deleted. An alternative can be a formula with assignment of the Foreign attribute of the field to Varchar.

[Russ]

Thanks!!!