Error: SELECT would examine more than MAX_JOIN_SIZE rows

[marpe]

When I go to the Joomla update page, I get an error message. I am asking for help what to do with it:

Code: Select all

42000, 1104, 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 

[ceford]

Came up somewhere else not so long ago. The only thing I can find is this:

https://issues.joomla.org/tracker/joomla-cms/17580

Anyone else?

[Carlo Rhiger]

Two of "my sites" come up with the same error when I try to update J4.1.5. to J4.2.2.
Searched the web, but could only find "professor-like" solutions not telling exactly which file to edit - typical.
I hope someone will come up with an understandable solution.

[henningbak]

Hi folks
I get the exacty same error message (1104) when I update Joomla from 4.2.2 to 4.2.3
Any Ideas?
Henning

[Per Yngve Berg]

MAX_JOIN_SIZE is set to small in the Configuration file of your database server.

[zib23]

Hello,
Where can I find that configuration file please?

[Per Yngve Berg]

https://stackoverflow.com/questions/248 ... on#2485758

[henningbak]

I got a solution that worked fine from Joomla 4.2.3 to Joomla 4.2.8:
Open the file:
/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php,
After Line 290 insert a statement:
mysqli_query($this->connection,"SET SQL_BIG_SELECTS = 1;" );
Result:
if ($this->options['sqlModes'] !== [])
{
$this->connection->query('SET @@SESSION.sql_mode = \'' . implode(',', $this-
>options['sqlModes']) . '\';');
mysqli_query($this->connection,"SET SQL_BIG_SELECTS = 1;" );
}

This change does not work with Joomla update to 4.2.9!