Error 0 Could not load root metadata. after upgrading from 5.0.3 to 5.1.0

[sergio-scl]

Steps to reproduce the issue

Panel Dashboard

Expected result

All oK

Actual result

Hi,

After updating from 5.0.3 to 5.1.0 I receive an error upon completion and now when I enter the panel it appears that I am on 5.1.0 but the Modifications, Extensions and Requests components do not load (they appear in red).
Additionally, if I click on Update Joomla I receive the error: 0 Could not load root metadata.

System information (as much as possible)

PHP 8.2
Debian

Log file contains:

2024-04-22T08:22:06+00:00 INFO 188.214.xx.xx update Test logging
2024-04-22T08:22:06+00:00 INFO 188.214.xx.xx update Actualización inciciadoa por el usuario Super User (734). La versión antigua es la 5.0.3.
2024-04-22T08:22:08+00:00 INFO 188.214.xx.xx update Descargando el archivo desde https://s3-us-west-2.amazonaws.com/joomla-official-downloads/joomladownloads/joomla5/Joomla_5.1.0-Stable-Update_Package.zip?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIA6LXDJLNUINX2AVMH%2F20240422%2Fus-west-2%2Fs3%2Faws4_request&X-Amz-Date=20240422T082207Z&X-Amz-Expires=60&X-Amz-SignedHeaders=host&X-Amz-Signature=1f980e307a90db1c72c8c7e101b07ff5a82d5818cba6805588fe54cb511905db.
2024-04-22T08:22:16+00:00 INFO 188.214.xx.xx update El archivo Joomla_5.1.0-Stable-Update_Package.zip se ha descargado.
2024-04-22T08:22:17+00:00 INFO 188.214.xx.xx update Iniciando la instalación de la versión nueva.

Additional comments

[richard67]

Is that really the complete log? If so, then the update has started and then nothing happened, no database updates were run.

[sergio-scl]

Is that really the complete log? If so, then the update has started and then nothing happened, no database updates were run.

Yes, this is the last content of the /log/joomla_update.log file

Is there another location with a more detailed file?

[richard67]

Is there another location with a more detailed file?

No, that’s the only one, and if that doesn’t show anything then nothing happened.

[richard67]

Do you have a backup from before the update? If so, restore that backup and then try the update again, but make sure to have error reporting set to „None“ in Global Configuration before starting the update.

[sergio-scl]

Now I have deleted DB manually and recovered Akeeba backup with Kickstart and now it gives me the error: 0 Cannot instantiate abstract class Joomla\Module\Login\Administrator\Helper\LoginHelper

P.S.: There is not a single time I want to update my Joomla that I don't have problems. :(

[richard67]

Does it help if you delete the file administrator/cache/autoload_psr4.php? It should be recreated again after a page reload. Maybe the restoration of the backup did not include that file so there is still the 5.1 version.

[sergio-scl]

Does it help if you delete the file administrator/cache/autoload_psr4.php? It should be recreated again after a page reload. Maybe the restoration of the backup did not include that file so there is still the 5.1 version.

No, same result.

[richard67]

Then something else went wrong with restoring that backup. As you said you have used an empty database to restore it, right? Have you also used an empty folders so that no 5.1 files were left

[sergio-scl]

Then something else went wrong with restoring that backup. As you said you have used an empty database to restore it, right? Have you also used an empty folders so that no 5.1 files were left

I had not deleted the entire directory. I just restored having deleted everything (directory + database) and this worked!

I now have my site back in 5.0.3

Any recommendations for updating and not "breaking" anything? Or do I wait for a better time to see if they release any more updates?

Thanks!!!

[richard67]

As I said before, switch error reporting to „None“ in Global Configuration and then try again to update. If that fails again, you now know how to properly restore a backup.

[sergio-scl]

As I said before, switch error reporting to „None“ in Global Configuration and then try again to update. If that fails again, you now know how to properly restore a backup.

I have done what you tell me and now when I update I receive the following error:

An error occurred
The Joomla updater cannot communicate correctly with the file that is responsible for carrying out the update administrator/components/com_joomlaupdate/extract.php. This usually occurs for one of the following reasons:

The file administrator/components/com_joomlaupdate/update.php, which contains the update instructions to be applied, cannot be created. For example: due to permission problems.
The above mentioned file cannot be read by the extract.php script due to permission issues.
Your browser, network equipment, or server is corrupting the password we send with each request to extract.php for security reasons.
Please try using a different browser, without any browser extensions installed, ideally on a different computer connected to the internet and using a different provider. If the error persists, you may want to contact your hosting provider.

[richard67]

Well then check the permissions of the administrator/components/com_joomlaupdate, and if there is a file named update.php, delete that file. Check also if the downloaded zip file is still in the tmp folder and if it is there, delete that too. Then try again.

[richard67]

If all that doesn’t help, someone else should step in because I need sleep soon and tomorrow have a long working day in my regular job.

[sergio-scl]

If all that doesn’t help, someone else should step in because I need sleep soon and tomorrow have a long working day in my regular job.

Same result.

That's what I'm going to do.
I have restored backup again and see if anyone else can help.

Thanks @richard67

[brianteeman]

P.S.: There is not a single time I want to update my Joomla that I don't have problems. :(

This tells me that at some point you had an upgrade that was not complete and ever since then you have been updating a broken install. No ammount of backups and restore will resolve that.

[sergio-scl]

P.S.: There is not a single time I want to update my Joomla that I don't have problems. :(

This tells me that at some point you had an upgrade that was not complete and ever since then you have been updating a broken install. No ammount of backups and restore will resolve that.

Could be. I had a lot of problems updating my old v3 but very recently we managed to clean up unnecessary extensions and managed to update to v4 and then v 5.1 without problems (at least apparently).

It is true that I did not create this Joomla and it had countless unnecessary plugins before that I eliminated and cleaned.

I don't know how I could find any trace of a previous bad update, if that's what might be causing me problems now. In the meantime, if not, I think we'll have to wait and see if there is more feedback on this upgrade.

[exlemor]

Not tonight as I am going to sleep but in the coming days, I am willing to help you over a Google Meet to try to check out what's happening etc.

[Ruud68]

I had the same issue, (with the resulting 0 Cannot instantiate abstract class Joomla\Module\Login\Administrator\Helper\LoginHelper error).

Issue was that the files on your site where upgraded, but your database due to restore are still on 5.0.3.

The error thrown comes from the guided tours that tries to execute on first login but cannot complete because the database is missing a field.

When you turn on maximum error logging in configuration.php you will see what file the error comes from.

You need to comment out the guided tours lines that cause the error. Then you can login.

DO NOT repair your database as that will indeed repair your database but render you interface useless as then all extensions miss the save / save & close etc. toolbar...

You need to go to the Joomla update and upload the Joomla 5.1 upgrade file and install that: then all files are again copied and your database is upgraded correct.

That fixed it for me.

Sorry that I do not have the detailed steps / filenames etc.

Hope this helps.

---

_{This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/43328.}

[exlemor]

@sergio-scl were you able to use @Ruud68's advice/instructions to fix things?

[sergio-scl]

I had the same issue, (with the resulting 0 Cannot instantiate abstract class Joomla\Module\Login\Administrator\Helper\LoginHelper error).

Issue was that the files on your site where upgraded, but your database due to restore are still on 5.0.3.

The error thrown comes from the guided tours that tries to execute on first login but cannot complete because the database is missing a field.

When you turn on maximum error logging in configuration.php you will see what file the error comes from.

You need to comment out the guided tours lines that cause the error. Then you can login.

DO NOT repair your database as that will indeed repair your database but render you interface useless as then all extensions miss the save / save & close etc. toolbar...

You need to go to the Joomla update and upload the Joomla 5.1 upgrade file and install that: then all files are again copied and your database is upgraded correct.

That fixed it for me.

Sorry that I do not have the detailed steps / filenames etc.

Hope this helps.

This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/43328.

Hello, sorry for not answering sooner but I haven't been able to take a moment to deal with this.

I have activated the log to maximum detail and I have gotten the same error when updating:

Now therefore when I enter the Joomla update I receive the following error:

An error has occurred.
1146 Table 'ddb69566.anvgy_tuf_metadata' doesn't exist

And the components in red do not work on the dashboard:

@exlemor @Ruud68

[brianteeman]

After you received the error message did you follow the advice in the message.

[sergio-scl]

I checked permissions, that wasn't it. I tried in other browsers and neither.
I don't know what more tests to do.
I have also not seen any message appear when the error log has been changed to the maximum.

[richard67]

@sergio-scl Maybe you have for some reason a modified .htaccess file with additional security rules, and that is from 4.0 times to it doesn’t allow to access the extract.php file? Could you check your .htaccess file if the thing described on this page https://docs.joomla.org/Htaccess_changes_after_joomla4.0.4 applies to it?