General error: 1116 Too many tables; MariaDB can only use 61 tables in a join

[isopahasusi]

Hello,

I updated my webshop top 8.1.6 version from 1.7. I deleted all products and encountered this error message when trying to add products:

An unexpected error occurred. [PrestaShopException code 0]: SQLSTATE[HY000]: General error: 1116 Too many tables; MariaDB can only use 61 tables in a join

How can I fix this?

[Knowband Plugins]

Hi,

You can increase the table join limit in MariaDB configuration, though this is generally not recommended for production environments as it may affect performance. the file is my.cnf
optimizer_switch="engine_condition_pushdown=off"
Restart MariaDB after making this change.
Enable debug mode in PrestaShop to get more detailed information about the query causing the issue and look for any custom overrides in the override directory that might be modifying SQL queries.

[isopahasusi]

Hello,

I tried debugging mode when used csv import and it gives messages in attachement: