V2 Calendar Month View MAX_JOIN_SIZE error

  • Resolved wayne01

    (@wayne01)


    2 years, 1 month ago

    Calendar Month view not returning events when V2 is enabled. WP debug log shows “WordPress database error The SELECT would examine more than MAX_JOIN_SIZE rows;… ”

    Both my Production and staging environments on ipower hosting have the issue.
    My “Playground Test” Websites do not have the issue, calendar view returns the expected events (IONOS hosting service and MAMP PRO desktop).

    Tested with all plugins deactivated (WordFence 7.5.8, TablePress 1.14, Duplicator 1.4.4) and cache/cookies cleared. Did not resolve the issue.

    Tried a recommendation I found on the web to add the following to the theme function.php file.
    add_action(‘init’, ‘tribe_allow_large_joins’);
    function tribe_allow_large_joins(){
    global $wpdb;
    $wpdb->query(‘SET SQL_BIG_SELECTS=1’);

    This surpressed the debug log message – however the events were still not returned.

    Configuration has WordPress 5.9.1, PHP 7.4.10 (on ipower hosting)

    The URL I provided is my staging site.
    Any suggestions or help would be appreciated

    The page I need help with: [log in to see the link]

Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter wayne01

    (@wayne01)

    2 years, 1 month ago

    I just thought maybe higher permissions were needed with the work around I found.

    I modified ‘SET SQL_BIG_SELECTS=1’ workaround to be at the session level
    SET SESSION SQL_BIG_SELECTS=1.

    That solved the SQL failure.

    I should have worked a little more before asking for help.

    Plugin Contributor GeoffBel

    (@geoffbel)

    2 years, 1 month ago

    Hey @wayne01

    Thank you for reaching out.
    First off, thank you for sharing your workaround.

    Are you good to go or do you still need help with anything?

    Best,
    Geoff

    Thread Starter wayne01

    (@wayne01)

    2 years, 1 month ago

    No further help needed at this time.

    Thanks for replying.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘V2 Calendar Month View MAX_JOIN_SIZE error’ is closed to new replies.