Failed migration from 3.10.9 to 4.1.4

Need help upgrading your Joomla! website or converting to Joomla! 4.x?

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Windows Defender SmartScreen Issues <-- please read this if using Windows 10.
Post Reply
quollby
Joomla! Apprentice
Joomla! Apprentice
Posts: 6
Joined: Tue Jun 21, 2022 1:54 am

Failed migration from 3.10.9 to 4.1.4

Post by quollby » Tue Jun 21, 2022 2:14 am

I had a functioning website running Joomla 3.10.9 and backed up the contents. Then I tried to update to 4.1.4 but the attempt failed. I then restored the backup in an attempt to return to the stable version on 3.10.9 - but that also reported errors.
It seems that I should have also done a database dump and also restored that - but I hadn't been aware of the need for that.
I'm now stuck with nothing working properly. Is there any way that I can get the old 3.10.9 site working stably again? If I could do that, I could then try to update more carefully.
Hoping someone can help.

User avatar
AMurray
Joomla! Exemplar
Joomla! Exemplar
Posts: 7758
Joined: Sat Feb 13, 2010 7:35 am
Location: Australia

Re: Failed migration from 3.10.9 to 4.1.4

Post by AMurray » Tue Jun 21, 2022 3:28 am

The database contains the contents of your site so not sure what you actually backed up when you say you
"backed up the contents".

What kind of backup did you do, and where did you try to restore it from? Did you simply overwrite the 4.x files with the 3.10.x files? That would mess things up, indeed. At minimum, for restoring you need to install a clean set of 3.10.x files, and your original database (which you now indicate you don't have).

However, your web host may be able to restore the site to a point before you tried the migration to 4.x, but also check your web-host admin tool (e.g. cPanel) to see if there's a way to restore backups.

If and when you get a site working the first thing I'd recommend is installing Akeeba Backup and making a backup with that before any attempt to migrate to Joomla 4.
Regards - A Murray

quollby
Joomla! Apprentice
Joomla! Apprentice
Posts: 6
Joined: Tue Jun 21, 2022 1:54 am

Re: Failed migration from 3.10.9 to 4.1.4

Post by quollby » Tue Jun 21, 2022 8:26 am

Many thanks! I backed up my site using Plesk Obsidian > Websites & Domains > Backup & Restore. I thought it backed up only "contents" but not the database, but I now realise I seem to have been wrong. The backup manager lists the backup content as (a) Configuration, (b) Mail messages and (c) User files and databases. So the database was included.

I saved the backup file to the hard drive of my computer. Then used the Plesk Upload File function to copy the file into the main httpdocs folder (to overwrite the existing files). Presumably that folder is the one that, shortly beforehand, had tried but failed to upgrade to Joomla 4.1.4 (so the 3.10.9 backup would have overwritten the 4.1.4 files). So, from what you said, that would mess things up.

What should I do? Should I first copy all the files in the httpdocs folder into another folder, as a safety precaution? Next I could delete all the files in the httpdocs folder. Then I could do a clean restore from the backup file on my computer.

Do you agree with this suggestion? Would this process replace the database?

The saved backup was created just before I attempted the upgrade to Joomla 4.1.4. So, if the above process works, I should be able to attempt the upgrade again but proceeding with greater caution.

User avatar
Webdongle
Joomla! Master
Joomla! Master
Posts: 41558
Joined: Sat Apr 05, 2008 9:58 pm

Re: Failed migration from 3.10.9 to 4.1.4

Post by Webdongle » Tue Jun 21, 2022 9:03 am

quollby wrote:
Tue Jun 21, 2022 8:26 am
... Then used the Plesk Upload File function to copy the file into the main httpdocs folder (to overwrite the existing files). ...
That is your mistake. Restoring a site should be done on an empty folder and new database. You need to delete the files and create a new database.
http://www.weblinksonline.co.uk/
https://www.weblinksonline.co.uk/updating-joomla.html
"When I'm right no one remembers but when I'm wrong no one forgets".

User avatar
AMurray
Joomla! Exemplar
Joomla! Exemplar
Posts: 7758
Joined: Sat Feb 13, 2010 7:35 am
Location: Australia

Re: Failed migration from 3.10.9 to 4.1.4

Post by AMurray » Wed Jun 22, 2022 12:08 am

Now you have stated you're using the Plesk Backup/Restore, I would suggest when you get the site restored you install Akeeba Backup, as that will allow for, I think, faster restoration when and if needed.

Given that Plesk is a hosting thing, any assistance with that should be obtained from your web host.
Regards - A Murray

quollby
Joomla! Apprentice
Joomla! Apprentice
Posts: 6
Joined: Tue Jun 21, 2022 1:54 am

Re: Failed migration from 3.10.9 to 4.1.4

Post by quollby » Wed Jun 22, 2022 2:47 am

Thanks Webdongle and AMurray!

I have now completed the following steps:
- copied all the files from /httpdocs/ to another folder (for safety);
- removed all the folders and files from /httpdocs/ which is now empty;
- added a new database (using Plesk), with a new name and a new user (the old database is still present).

What should I do next. I think I should use Plesk to restore the backup made BEFORE my failed upgrade attempt. Please confirm (before I proceed).

Should that populate the new database?

User avatar
Webdongle
Joomla! Master
Joomla! Master
Posts: 41558
Joined: Sat Apr 05, 2008 9:58 pm

Re: Failed migration from 3.10.9 to 4.1.4

Post by Webdongle » Wed Jun 22, 2022 8:12 am

If when restoring plesk allows you to populate the new database then do that. Otherwise your need to empty your original database then restore the plesk backup
http://www.weblinksonline.co.uk/
https://www.weblinksonline.co.uk/updating-joomla.html
"When I'm right no one remembers but when I'm wrong no one forgets".

quollby
Joomla! Apprentice
Joomla! Apprentice
Posts: 6
Joined: Tue Jun 21, 2022 1:54 am

Re: Failed migration from 3.10.9 to 4.1.4

Post by quollby » Thu Jun 23, 2022 3:31 am

Thanks Webdongle!

Your second option, of emptying my original database then restoring, seemed the safest option, so that is what I did. In Plesk I used the Drop Tables command for all the tables in the database.

After the restoration, I received this message: "Restoration of the backup June 16, 2022 04:17 PM completed, though some problems occurred", with an option to download the log. Here is the log:

WARNING: () The webmail service roundcube is unavailable. It will be replaced with CheaperDomains Webmail for the following objects: quollbooks.com.au


WARNING: () New configuration files were not created. Error: nginx: [emerg] cannot load certificate &quot;/usr/local/psa/var/certificates/cert-Lbf9FS&quot;: BIO_new_file() failed (SSL: error:02001002:system library:fopen:No such file or directory:fopen('/usr/local/psa/var/certificates/cert-Lbf9FS','r') error:2006D080:BIO routines:BIO_new_file:no such file)
nginx: configuration file /etc/nginx/nginx.conf test failed


WARNING: () New configuration files were not created. Error: AH00526: Syntax error on line 50 of /etc/httpd/conf/plesk.conf.d/webmails/aquaatoll.com.au_webmail.conf:
SSLCertificateFile: file '/usr/local/psa/var/certificates/cert-Lbf9FS' does not exist or is empty


I would be most grateful for your help in understanding what this means and what I should do next?

When I tried to log into the Joomla Administration backend, the following message was displayed:

Congratulations! Joomla! is now installed.
PLEASE REMEMBER TO COMPLETELY REMOVE THE INSTALLATION FOLDER.
You will not be able to proceed beyond this point until the "installation" folder has been removed. This is a security feature of Joomla!


There was a button [Remove "installation" folder] - should I click that?

I have earlier backups made roughly at monthly intervals for the past year. If I can't get this backup to restore correctly, is it worth trying to restore older backups?

I would very much appreciate help in what to do next.

quollby
Joomla! Apprentice
Joomla! Apprentice
Posts: 6
Joined: Tue Jun 21, 2022 1:54 am

Re: Failed migration from 3.10.9 to 4.1.4

Post by quollby » Thu Jun 23, 2022 3:37 am

A further thought: the Plesk database manager has a "Check and Repair" option. Should I run that?

User avatar
Webdongle
Joomla! Master
Joomla! Master
Posts: 41558
Joined: Sat Apr 05, 2008 9:58 pm

Re: Failed migration from 3.10.9 to 4.1.4

Post by Webdongle » Thu Jun 23, 2022 8:55 am

Try it. If it doesn't work just reinstate your backup again.

You need to delete the installation folder. It appears that backup was made just after you installed Joomla.

You need to ask your Host about the other errors.
http://www.weblinksonline.co.uk/
https://www.weblinksonline.co.uk/updating-joomla.html
"When I'm right no one remembers but when I'm wrong no one forgets".

quollby
Joomla! Apprentice
Joomla! Apprentice
Posts: 6
Joined: Tue Jun 21, 2022 1:54 am

Re: Failed migration from 3.10.9 to 4.1.4

Post by quollby » Fri Jun 24, 2022 7:48 am

I am pleased to report that I restored the backup and it seems to have worked correctly. The Joomla Administration (backend) seems to be working normally and so is the live website (frontend).

I again ran the Pre-Update Check for Joomla 4 and all seems fine with Joomla itself:
- Required PHP & Database Settings : Passed
- Recommended PHP Settings : Passed

The Extensions Pre-Update Check reported some unavailable information and some potential update issues for some extensions being used. I need to take these up with the developers of these extensions. Consequently, I will not proceed with the update to Joomla 4, at present.

Many thanks for your help!

User avatar
Webdongle
Joomla! Master
Joomla! Master
Posts: 41558
Joined: Sat Apr 05, 2008 9:58 pm

Re: Failed migration from 3.10.9 to 4.1.4

Post by Webdongle » Fri Jun 24, 2022 7:59 am

Now take AMurray's advise and use Akeeba to make a backup
http://www.weblinksonline.co.uk/
https://www.weblinksonline.co.uk/updating-joomla.html
"When I'm right no one remembers but when I'm wrong no one forgets".


Post Reply

Return to “Migrating and Upgrading to Joomla! 4.x”