Hello,
I am trying to join 6 (six) tables together. When i visit the main list, i will see this error:
1116 Too many tables; MySQL can only use 61 tables in a join.
Searching the fabrik_joins database table i've found 57 instances of main list...
The big number of joined tables might be because of another error: when i try to join a new table (List/Data/Joins/Add), the first joined table is removed and the last added joined table is saved. One workaround was to remove all the joins, save the list, edit the list and add again each join. But, that will work only if i will not edit the list again. Soon as i edit the list (for any reason, like changing the name of the list), the first table from join is removed.
I use the github version updated yesterday
Thank you
I am trying to join 6 (six) tables together. When i visit the main list, i will see this error:
1116 Too many tables; MySQL can only use 61 tables in a join.
Searching the fabrik_joins database table i've found 57 instances of main list...
The big number of joined tables might be because of another error: when i try to join a new table (List/Data/Joins/Add), the first joined table is removed and the last added joined table is saved. One workaround was to remove all the joins, save the list, edit the list and add again each join. But, that will work only if i will not edit the list again. Soon as i edit the list (for any reason, like changing the name of the list), the first table from join is removed.
I use the github version updated yesterday
Thank you