Ошибка обновления 42000, 1104 - Joomla 6, Joomla 5 и Joomla 4: Общие вопросы

Found the solution: o fix it i just have to edit the file libraries\joomla\database\driver\mysqli.php
and to insert the line
mysqli_query($this->connection,"SET SQL_BIG_SELECTS = 1;" ); или mysql_query($this->connection,"SET SQL_BIG_SELECTS = 1;" );
in the function connect after the line 168( mysqli_query($this->connection, "SET @@SESSION.sql_mode = '';")

	// If needed, set the sql modes.
		if ($this->options['sqlModes'] !== [])
		{ 
			$this->connection->query('SET @@SESSION.sql_mode = \'' . implode(',', $this->options['sqlModes']). '\';');
			$this->connection->query('SET SQL_BIG_SELECTS = 1;' );
		}

// If needed, set the sql modes.
		if ($this->options['sqlModes'] !== [])
		{
			$this->connection->query('SET @@SESSION.sql_mode = \'' . implode(',', $this->options['sqlModes']). '\';');
		mysqli_query($this->connection,"SET SQL_BIG_SELECTS = 1;" );  
		}