We use cookies to improve your experience. No personal information is gathered and we don't serve ads. Cookies Policy.

ExpressionEngine Logo ExpressionEngine
Features Pricing Support Find A Developer
Partners Upgrades
Blog Add-Ons Learn
Docs Forums University
Log In or Sign Up
Log In Sign Up
ExpressionEngine Logo
Features Pro new Support Find A Developer
Partners Upgrades
Blog Add-Ons Learn
Docs Forums University Blog
  • Home
  • Forums

SQLSTATE[HY000]: General error: 1116 Too many tables; MySQL can only use 61 tables in a join:

Development and Programming

CharlottesvilleMedia's avatar
CharlottesvilleMedia
34 posts
4 years ago
CharlottesvilleMedia's avatar CharlottesvilleMedia

(appears to be same as this solved bug? https://expressionengine.com/support/bugs/23649/searching-content-in-the-control-panel)

Just upgraded 5.4 to 6.0 and getting this when trying to load site index:

SQLSTATE[HY000]: General error: 1116 Too many tables; MySQL can only use 61 tables in a join: SELECT t.entry_id, t.channel_id, t.forum_topic_id, t.author_id, t.ip_address, t.title, t.url_title, t.status, t.view_count_one, t.view_count_two, t.view_count_three, t.view_count_four, t.allow_comments, t.comment_expiration_date, t.sticky, t.entry_date, t.year, t.month, t.day, t.edit_date, t.expiration_date, t.recent_comment_date, t.comment_total, t.site_id as entry_site_id, w.channel_title, w.channel_name, w.channel_url, w.comment_url, w.comment_moderate, w.channel_html_formatting, w.channel_allow_img_urls, w.channel_auto_link_urls, w.comment_system_enabled, m.username, m.email, m.screen_name, m.signature, m.sig_img_filename, m.sig_img_width, m.sig_img_height, m.avatar_filename, m.avatar_width, m.avatar_height, m.photo_filename, m.photo_width, m.photo_height, m.role_id, m.member_id, wd.*, md.* , exp_member_data_field_1.*, exp_member_data_field_2.*, exp_member_data_field_3.*, exp_member_data_field_4.*, exp_member_data_field_5.*, exp_member_data_field_6.*, exp_member_data_field_8.*, exp_channel_data_field_9.field_id_9, exp_channel_data_field_9.field_ft_9, exp_channel_data_field_10.field_id_10, exp_channel_data_field_10.field_ft_10, exp_channel_data_field_11.field_id_11, exp_channel_data_field_11.field_ft_11, exp_channel_data_field_12.field_id_12, exp_channel_data_field_12.field_ft_12, exp_channel_data_field_13.field_id_13, exp_channel_data_field_13.field_ft_13, exp_channel_data_field_14.field_id_14, exp_channel_data_field_14.field_ft_14, exp_channel_data_field_15.field_id_15, exp_channel_data_field_15.field_ft_15, exp_channel_data_field_16.field_id_16, exp_channel_data_field_16.field_ft_16, exp_channel_data_field_17.field_id_17, exp_channel_data_field_17.field_ft_17, exp_channel_data_field_18.field_id_18, exp_channel_data_field_18.field_ft_18, exp_channel_data_field_19.field_id_19, exp_channel_data_field_19.field_ft_19, exp_channel_data_field_20.field_id_20, exp_channel_data_field_20.field_ft_20, exp_channel_data_field_21.field_id_21, exp_channel_data_field_21.field_ft_21, exp_channel_data_field_22.field_id_22, exp_channel_data_field_22.field_ft_22, exp_channel_data_field_23.field_id_23, exp_channel_data_field_23.field_ft_23, exp_channel_data_field_24.field_id_24, exp_channel_data_field_24.field_ft_24, exp_channel_data_field_25.field_id_25, exp_channel_data_field_25.field_ft_25, exp_channel_data_field_26.field_id_26, exp_channel_data_field_26.field_ft_26, exp_channel_data_field_27.field_id_27, exp_channel_data_field_27.field_ft_27, exp_channel_data_field_28.field_id_28, exp_channel_data_field_28.field_ft_28, exp_channel_data_field_29.field_id_29, exp_channel_data_field_29.field_ft_29, exp_channel_data_field_30.field_id_30, exp_channel_data_field_30.field_ft_30, exp_channel_data_field_31.field_id_31, exp_channel_data_field_31.field_ft_31, exp_channel_data_field_32.field_id_32, exp_channel_data_field_32.field_ft_32, exp_channel_data_field_33.field_id_33, exp_channel_data_field_33.field_ft_33, exp_channel_data_field_34.field_id_34, exp_channel_data_field_34.field_ft_34, exp_channel_data_field_35.field_id_35, exp_channel_data_field_35.field_ft_35, exp_channel_data_field_36.field_id_36, exp_channel_data_field_36.field_ft_36, exp_channel_data_field_37.field_id_37, exp_channel_data_field_37.field_ft_37, exp_channel_data_field_38.field_id_38, exp_channel_data_field_38.field_ft_38, exp_channel_data_field_39.field_id_39, exp_channel_data_field_39.field_ft_39, exp_channel_data_field_40.field_id_40, exp_channel_data_field_40.field_ft_40, exp_channel_data_field_41.field_id_41, exp_channel_data_field_41.field_ft_41, exp_channel_data_field_42.field_id_42, exp_channel_data_field_42.field_ft_42, exp_channel_data_field_43.field_id_43, exp_channel_data_field_43.field_ft_43, exp_channel_data_field_44.field_id_44, exp_channel_data_field_44.field_ft_44, exp_channel_data_field_45.field_id_45, exp_channel_data_field_45.field_ft_45, exp_channel_data_field_46.field_id_46, exp_channel_data_field_46.field_ft_46, exp_channel_data_field_47.field_id_47, exp_channel_data_field_47.field_ft_47, exp_channel_data_field_48.field_id_48, exp_channel_data_field_48.field_ft_48, exp_channel_data_field_49.field_id_49, exp_channel_data_field_49.field_ft_49, exp_channel_data_field_50.field_id_50, exp_channel_data_field_50.field_ft_50, exp_channel_data_field_51.field_id_51, exp_channel_data_field_51.field_ft_51, exp_channel_data_field_52.field_id_52, exp_channel_data_field_52.field_ft_52, exp_channel_data_field_53.field_id_53, exp_channel_data_field_53.field_ft_53, exp_channel_data_field_54.field_id_54, exp_channel_data_field_54.field_ft_54, exp_channel_data_field_55.field_id_55, exp_channel_data_field_55.field_ft_55, exp_channel_data_field_56.field_id_56, exp_channel_data_field_56.field_ft_56, exp_channel_data_field_57.field_id_57, exp_channel_data_field_57.field_ft_57, exp_channel_data_field_58.field_id_58, exp_channel_data_field_58.field_ft_58 FROM exp_channel_titles AS t LEFT JOIN exp_channels AS w ON t.channel_id = w.channel_id LEFT JOIN exp_channel_data AS wd ON t.entry_id = wd.entry_id LEFT JOIN exp_members AS m ON m.member_id = t.author_id LEFT JOIN exp_member_data AS md ON md.member_id = m.member_id LEFT JOIN exp_member_data_field_1 ON m.member_id = exp_member_data_field_1.member_id LEFT JOIN exp_member_data_field_2 ON m.member_id = exp_member_data_field_2.member_id LEFT JOIN exp_member_data_field_3 ON m.member_id = exp_member_data_field_3.member_id LEFT JOIN exp_member_data_field_4 ON m.member_id = exp_member_data_field_4.member_id LEFT JOIN exp_member_data_field_5 ON m.member_id = exp_member_data_field_5.member_id LEFT JOIN exp_member_data_field_6 ON m.member_id = exp_member_data_field_6.member_id LEFT JOIN exp_member_data_field_8

       
Tom Jaeger's avatar
Tom Jaeger
228 posts
4 years ago
Tom Jaeger's avatar Tom Jaeger

For others who find this. This was resolved on the github issue, and commits linked to it, which will be included in the 6.0.1 release.

https://github.com/ExpressionEngine/ExpressionEngine/issues/708

       

Reply

Sign In To Reply

ExpressionEngine Home Features Pro Contact Version Support
Learn Docs University Forums
Resources Support Add-Ons Partners Blog
Privacy Terms Trademark Use License

Packet Tide owns and develops ExpressionEngine. © Packet Tide, All Rights Reserved.