• Resolved cdfwebdev

    (@cdfwebdev)


    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 SEO

    
    WordPress 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 =

    ……………….
    `

    • This topic was modified 2 years, 4 months ago by cdfwebdev.
    • This topic was modified 2 years, 4 months ago by Yui. Reason: formatting
Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Support Abz

    (@abzlevelup)

    Hi @cdfwebdev, sorry to hear about this. Since you have an active license and for us to help you better, please open a Support Ticket on our Help Desk. Also, for us to follow WordPress Forum Guidelines in regard to premium users.

    We look forward to helping you out with this one. Hang in there.

    Best,
    Abz

    Thread Starter cdfwebdev

    (@cdfwebdev)

    Hi

    I’m trying to submit a ticket but its not submitting. I’m stuck with the loading animation on the submit button.

    Can I contact you another way?

    Thanks

    Plugin Support Abz

    (@abzlevelup)

    Hi @cdfwebdev, yikes. Could you try using a different browser, and see if that works?

    Best,
    Abz

    Plugin Support Abz

    (@abzlevelup)

    Hey @cdfwebdev, this thread has been inactive for a while, so we’re going to go ahead and mark it Resolved. Please feel free to open a new thread if any other questions come up, and we’d be happy to help.

    Cheers,
    Abz

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.