1104 fout bij update naar Joomla 4.3.4

The recent Joomla upgrade to version 4.3.4 showed me the following error:

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 

A 'tempory' solution is:

In php file: /libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php


modify line 330 like below

327 // If needed, set the sql modes.

328		if ($this->options['sqlModes'] !== [])

329		{

330			$this->connection->query('SET @@SESSION.sql_mode = \'' . implode(',', $this->options['sqlModes']) . '\';');

			

			mysqli_query($this->connection, "SET @@SESSION.sql_mode = '';");

331 }


Hereafter the update is successful, however at the end error 1104 shows up again, because the file /libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php is renewed during the update and apparently, at the end of the update, the renewed file is checked again I presume.

My provider One.com points to Joomla and their comment: We cannot change this.


So, I have to modify the MysqliDriver.php file of all the subdomains, or the Joomla organisation culd possibly enter the above mentioned line in the file MysqliDriver.php