I created a view (with the view.module) to try to find, if I have any "nodes" not within a group of taxonomy terms.
When I go to display my view, I get the warning message:

"user warning: Too many tables. MySQL can only use 31 tables in a join query: SELECT node.nid FROM node LEFT JOIN term_node
.../...
E:\DomZeus\sitebuddycom\wwwroot\includes\database.mysql.inc on line 124."

I guess some Drupal sub-system should capture this MySQL/DB limitation (i.e. maximum number of tables in a join ...etc..) and display a more user friendly message, when a database limitation is reach...

I hesitated between a bug report or a feature request...

Thank you,
Christophe D

Comments

mzabala’s picture

Version: 4.7.0-beta4 » 4.6.0

I'm using Civicspace 0.8.2 and got this error.

Fatal error: Too many tables; MySQL can only use 61 tables in a join query: SELECT flexinode_11.textual_data AS flexinode_11, flexinode_62.textual_data AS flexinode_62, flexinode_3.textual_data AS flexinode_3, flexinode_6.numeric_data AS flexinode_6, flexinode_2.textual_data AS flexinode_2, flexinode_4.numeric_data AS flexinode_4, flexinode_15.textual_data AS flexinode_15, flexinode_63.textual_data AS flexinode_63, flexinode_12.textual_data AS flexinode_12, flexinode_16.numeric_data AS flexinode_16, flexinode_13.textual_data AS flexinode_13, flexinode_14.numeric_data AS flexinode_14, flexinode_56.textual_data AS flexinode_56, flexinode_64.textual_data AS flexinode_64, flexinode_40.textual_data AS flexinode_40, flexinode_25.numeric_data AS flexinode_25, flexinode_48.textual_data AS flexinode_48, flexinode_18.numeric_data AS flexinode_18, flexinode_55.textual_data AS flexinode_55, flexinode_65.textual_data AS flexinode_65, flexinode_39.textual_data AS flexinode_39, flexinode_26.numeric_data AS flexinode_26, flexinode_47.tex in /includes/database.mysql.inc on line 66

chrisd’s picture

I'm running the windows release of 4.0.26 what about you ?

magico’s picture

Status: Active » Closed (fixed)