Update issue with Joomla

waldo99

Hi,

using JA Trip Quickstart
PHP 8.3
MariaDB 10.11

There is an issue when updating Joomla (or reinstalling Joomla core).

Error message in backend after update:
Notice The update completed with errors. Please examine the update logs /home/.sites/598/site4653660/web/administrator/logs/joomla_update.php for more details.
It is recommended to restore the site from backup, fix the issues that caused the update failure and try to update again.

captured ERROR message:
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

Looking into the Log file joomla_update.php:
An error has occurred while running "JoomlaInstallerScript::updateManifestCaches". Code: 1104. Message: 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.

I have no idea what can cause the problems.
I am using the same host since years.
The only difference is: now there is MariaDB 10.11 in use and not MySQL 8.0 anymore.
(no Error when using the quickstart installation with MySQL 8.0 Database)

So...
could the issues be a database problem or from Quickstart?
How to handle or fix it?

Thanks,
Walter

cssyeah

Hi @waldo99,
I just logged into your admin. You have updated to the latest joomla version 5.3.0 and I see everything is working fine. I do not see the message as you reported.
Kind regards,

waldo99

cssyeah
Hi,

I know that working on backend looks "normal".
the message appears as last step when update is finished.
(You can use the "Reinstall the Joomla core", then you will see.)

I did regular Joomla updates and the Reinstall Update... always the same messages.

Walter

saguaros

Hi Walter,

I tried to take a backup of your site and Reinstall in my dev environment but no error when the update is finished:

Anyway, you can continue using the template and let us know if you encounter any issue with J!5.3.0