Error "The SELECT would examine more than MAX_JOIN_SIZE rows;..."

Need help installing Joomla! 5.x? For all Joomla! 5.x installation issues please use this forum.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Windows Defender SmartScreen Issues <-- please read this if using Windows 10
Post Reply
zeta77
Joomla! Apprentice
Joomla! Apprentice
Posts: 46
Joined: Tue Jun 09, 2020 12:57 pm

Error "The SELECT would examine more than MAX_JOIN_SIZE rows;..."

Post by zeta77 » Wed Apr 17, 2024 12:16 pm

I updated to 5.1.0 and received the following error:

Joomla Version Update Status
Notice The update completed with errors.

Brief list of captured errors
The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay (The update error log gives basically the same info)

Issue# 1: I did use SET SQL_BIG_SELECTS=1 as suggested in several places (also by my host, ONE.COM). However, that does not seem to make the error go away. Is there a better fix?
Issue# 2: I cannot see any problems with the site and my update status is now "green = no update needed". So, do I have to concern myself with this error. If so - what problems should I expect to see?

User avatar
Per Yngve Berg
Joomla! Master
Joomla! Master
Posts: 31019
Joined: Mon Oct 27, 2008 9:27 pm
Location: Romerike, Norway

Re: Error "The SELECT would examine more than MAX_JOIN_SIZE rows;..."

Post by Per Yngve Berg » Wed Apr 17, 2024 2:06 pm

Did you reapply the patch after the update? The file have been replaced and you patch no longer is present.


Post Reply

Return to “Installation Joomla! 5.x”