After creating my flexinode with 72 fields, I got the following error when trying to view a flexinode:

user error: Too many tables. MySQL can only use 31 tables in a join
query: SELECT flexinode_4.textual_data AS flexinode_4, flexinode_5.textual_data AS flexinode_5, flexinode_7.textual_data AS flexinode_7, flexinode_8.textual_data AS flexinode_8, flexinode_6.textual_data AS flexinode_6, flexinode_48.textual_data AS flexinode_48, flexinode_43.textual_data AS flexinode_43, flexinode_38.textual_data AS flexinode_38, flexinode_37.textual_data AS flexinode_37, flexinode_39.textual_data AS flexinode_39, flexinode_45.textual_data AS flexinode_45, flexinode_18.textual_data AS flexinode_18, flexinode_42.textual_data AS flexinode_42, flexinode_10.textual_data AS flexinode_10, flexinode_36.textual_data AS flexinode_36, flexinode_35.textual_data AS flexinode_35, flexinode_56.textual_data AS flexinode_56, flexinode_14.textual_data AS flexinode_14, flexinode_58.textual_data AS flexinode_58, flexinode_30.textual_data AS flexinode_30, flexinode_9.textual_data AS flexinode_9, flexinode_19.textual_data AS flexinode_19, flexinode_20.textua in /export/www/html/includes/database.mysql.inc on line 97.

At the very least, it would be really nice if flexinode gave a warning before all the nodes were actually created...

Comments

jonbob’s picture

Assigned: Unassigned » jonbob

A warning was added to 4.4; the HEAD version awaits a real fix, by rewriting the SQL significantly.

jonbob’s picture

Can't be solved the way this module is built. CCK will avoid the joins.