Environment
- AtroCore 2.2.31 (upgraded from 1.13.53 via 2.0.0 → 2.1.26 → 2.2.31)
- atrocore/pim 1.15.27
- atrocore/export 1.10.14
- atrocore/import 1.10.15
- PHP 8.4 (Sury repo)
- Apache 2.4.58, Ubuntu 24.04 LTS
- MySQL 8.0.45
I did a big update, from 1.13.53 → 2.2.31
The Export Feed deprecated and now moved to Export, so far most is working, but some exports won’t work. Started debugging, after rebuild a 28 rows Export by hand Field and Attribute step by stept, I end up with the conclusion, 27 works, everything abote, Failed. The msg in the database on export_job:
An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1116 Too many tables; MySQL can only use 61 tables in a join
I could upload you also my tl tr claude export, though everything I said above should be enough, at the moment I cannot change to Postgress, we have export-by-Stored-Procedures …
I can’t imagine that export is limited by X Attributes or Fields, there must be some setting, working edit, etc. can someone help?
