WordPress database error Too many tables; MariaDB can only use 61 tables
-
Seeing lots of errors logged with the error below, any suggestions?
We have these plugins installed:
The Events Calendar PRO
The Events Calendar: Filter Bar
WPML Multilingual CMS
Yoast SEOWordPress database error Too many tables; MariaDB can only use 61 tables in a join for query SELECT wphu_posts.ID, CAST( orderby_event_date_utc_meta.meta_value AS DATETIME ) AS event_date_utc FROM wphu_posts LEFT JOIN wphu_postmeta ON ( wphu_posts.ID = wphu_postmeta.post_id AND wphu_postmeta.meta_key = '_EventHideFromUpcoming' ) LEFT JOIN wphu_postmeta AS mt1 ON ( wphu_posts.ID = mt1.post_id ) JOIN wphu_icl_translations wpml_translations ON wphu_posts.ID = wpml_translations.element_id AND wpml_translations.element_type = CONCAT('post_', wphu_posts.post_type) LEFT JOIN wphu_postmeta as tribe_event_end_date ON ( wphu_posts.ID = tribe_event_end_date.post_id AND tribe_event_end_date.meta_key = '_EventEndDateUTC' ) LEFT JOIN wphu_postmeta AS orderby_event_date_utc_meta ON ( orderby_event_date_utc_meta.post_id = wphu_posts.ID AND orderby_event_date_utc_meta.meta_key = '_EventStartDateUTC' ) LEFT JOIN wphu_postmeta AS all_day_6357e75e57681 ON (wphu_posts.ID = all_day_6357e75e57681.post_id AND all_day_6357e75e57681.meta_key = '_EventAllDay') INNER JOIN wphu_postmeta AS tod_start_date_6357e75e57682 ON (wphu_posts.ID = tod_start_date_6357e75e57682.post_id AND tod_start_date_6357e75e57682.meta_key = '_EventStartDate') INNER JOIN wphu_postmeta AS tod_duration_6357e75e57683 ON (wphu_posts.ID = tod_duration_6357e75e57683.post_id AND tod_duration_6357e75e57683.meta_key = '_EventDuration') LEFT JOIN wphu_postmeta AS all_day_6357e7604a7ca ON (wphu_posts.ID = all_day_6357e7604a7ca.post_id AND all_day_6357e7604a7ca.meta_key = '_EventAllDay') INNER JOIN wphu_postmeta AS tod_start_date_6357e7604a7cc ON (wphu_posts.ID = tod_start_date_6357e7604a7cc.post_id AND tod_start_date_6357e7604a7cc.meta_key = '_EventStartDate') INNER JOIN wphu_postmeta AS tod_duration_6357e7604a7cd ON (wphu_posts.ID = tod_duration_6357e7604a7cd.post_id AND tod_duration_6357e7604a7cd.meta_key = '_EventDuration') LEFT JOIN wphu_postmeta AS all_day_6357e79173852 ON (wphu_posts.ID = all_day_6357e79173852.post_id AND all_day_6357e79173852.meta_key = '_EventAllDay') INNER JOIN wphu_postmeta AS tod_start_date_6357e79173854 ON (wphu_posts.ID = tod_start_date_6357e79173854.post_id AND tod_start_date_6357e79173854.meta_key = '_EventStartDate') INNER JOIN wphu_postmeta AS tod_duration_6357e79173855 ON (wphu_posts.ID = tod_duration_6357e79173855.post_id AND tod_duration_6357e79173855.meta_key = '_EventDuration') LEFT JOIN wphu_postmeta AS all_day_6358171f5346f ON (wphu_posts.ID = all_day_6358171f5346f.post_id AND all_day_6358171f5346f.meta_key = '_EventAllDay') INNER JOIN wphu_postmeta AS tod_start_date_6358171f53470 ON (wphu_posts.ID = tod_start_date_6358171f53470.post_id AND tod_start_date_6358171f53470.meta_key = '_EventStartDate') INNER JOIN wphu_postmeta AS tod_duration_6358171f53471 ON (wphu_posts.ID = tod_duration_6358171f53471.post_id AND tod_duration_6358171f53471.meta_key = '_EventDuration') LEFT JOIN wphu_postmeta AS all_day_63583b86559fb ON (wphu_posts.ID = all_day_63583b86559fb.post_id AND all_day_63583b86559fb.meta_key = '_EventAllDay') INNER JOIN wphu_postmeta AS tod_start_date_63583b86559fd ON (wphu_posts.ID = tod_start_date_63583b86559fd.post_id AND tod_start_date_63583b86559fd.meta_key = '_EventStartDate') INNER JOIN wphu_postmeta AS tod_duration_63583b86559fe ON (wphu_posts.ID = tod_duration_63583b86559fe.post_id AND tod_duration_63583b86559fe.meta_key = '_EventDuration') LEFT JOIN wphu_postmeta AS all_day_6357e7604a7ec ON (wphu_posts.ID = all_day_6357e7604a7ec.post_id AND all_day_6357e7604a7ec.meta_key = '_EventAllDay') INNER JOIN wphu_postmeta AS tod_start_date_6357e7604a7ed ON (wphu_posts.ID = tod_start_date_6357e7604a7ed.post_id AND tod_start_date_6357e7604a7ed.meta_key = '_EventStartDate') INNER JOIN wphu_postmeta AS tod_duration_6357e7604a7ee ON (wphu_posts.ID = tod_duration_6357e7604a7ee.post_id AND tod_duration_6357e7604a7ee.meta_key = '_EventDuration') LEFT JOIN wphu_postmeta AS all_day_6357e79173897 ON (wphu_posts.ID = all_day_6357e79173897.post_id AND all_day_6357e79173897.meta_key = '_EventAllDay') INNER JOIN wphu_postmeta AS tod_start_date_6357e79173898 ON (wphu_posts.ID = tod_start_date_6357e79173898.post_id AND tod_start_date_6357e79173898.meta_key = '_EventStartDate') INNER JOIN wphu_postmeta AS tod_duration_6357e79173899 ON (wphu_posts.ID = tod_duration_6357e79173899.post_id AND tod_duration_6357e79173899.meta_key = '_EventDuration') LEFT JOIN wphu_postmeta AS all_day_6358171f534a0 ON (wphu_posts.ID =
……………….
`
Viewing 4 replies - 1 through 4 (of 4 total)
Viewing 4 replies - 1 through 4 (of 4 total)
- The topic ‘WordPress database error Too many tables; MariaDB can only use 61 tables’ is closed to new replies.