Hi,

i ran into some problems with a custom content type. This CT contains more than 100 fields, and now i get following error due to mysql limitations (max. 61 joins):

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

Is there any way to modifiy/optimize the select statement in revisioniong_api.inc line 894 or would be a change to an other RDBMS like PostgreSQL the best way?

Kind regards,

Brubaker

Comments

brubakerburns created an issue.

RdeBoer’s picture

RdeBoer
Location Melbourne
CreditAttribution: RdeBoer as a volunteer commented

Change db.
Or split your content type.
100 fields... that's a lot....
If it's not Revisioning falling over, then it will soon be another module spitting the dummy...

carstenG’s picture

carstenG CreditAttribution: carstenG at FFW commented

well..just curios..why do you need more than 100 fields for a single content type.
Seems for me that your architecture is wrong.

svanou’s picture

svanou CreditAttribution: svanou as a volunteer commented

Hi everyone,
We're experiencing the same issue on a Content Type: PDOException: SQLSTATE[HY000]: General error: 1116 Too many tables;
We actually only have 54 fields but 34 of those are taxonomy terms reference.
By any chances, did you find a solution ?
Thanks ! Sylvain