If you encounter the following error message in Joomla 4.4 onwards within YourSites then your YourSites server has been configured with a lower MAX_JOIN_SIZE than the default. This can end up setting SQL_BIG_SELECTS to a value of zero automatically.

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

You can probably resolve this by configuring a custom database session query on the advanced tab of the YourSites configutation (https://yourdomain/administrator/index.php?option=com_config&view=component&component=com_yoursites) and scroll down on the "advanced" tab

Custom Database Session Query

We love every single one of our users, without you YourSites simply couldn't happen! So we would love a review at the Joomla! JED so we can let others know about us too, please take a minute to write a review:

If you feel you have something negative to say, we would implore you to speak to us first, as we really really don't want anyone to be unhappy!