Support

Akeeba Backup for Joomla!

#22880 Upgrade to J3 failed and restore failed

Posted in ‘Akeeba Backup for Joomla! 4 & 5’
This is a public ticket

Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.

Environment Information

Joomla! version
n/a
PHP version
n/a
Akeeba Backup version
n/a

Latest post by on Wednesday, 05 August 2015 17:20 CDT

[email protected]
EXTREMELY IMPORTANT: Please attach a ZIP file containing your Akeeba Backup log file in order for us to help you with any backup or restoration issue. If the file is over 2Mb, please upload it on your server and post a link to it.

I cannot submit a log because I cannot access the backend, so cannot run Alice.

Site URL: www.titsey.org.uk

Description of my issue: Upgrade to Joomla 3 achieved white screens in front and back ends. Kickstart restored from the restore point taken pre-Upgrade but said URLs were not applicable, so still white screens in front and back end.

I have taken several backups as per Akeeba guides, so I am still OK but I cannot afford to lose them, i.e. the restore point file has gone since I restored and I don't want to lose my jpa/j01 files and still not have the site back.

This happened once before when I was trying to upgrade to J3 and the backup would not overwrite the J3 files, so I had to delete everything and then backup from scratch using Kickstart.

I just need to know the best way to get out of this predicament. What files should I delete before using Kickstart? Can I rescue anything from what I have already done?

Some help would be very much appreciated.

Regards,
David

[email protected]
Sorry, correction - The time before I had to delete everything, re-install Joomla 2.5 and then restore using Kickstart.

nicholas
Akeeba Staff
Manager
When restoring a DIFFERENT version of Joomla! than the one on your server you MUST delete everything, THEN restore the backup. This is actually written in our documentation. It has to do with the way Joomla! works.

Please note that you do NOT need to install Joomla! 2.5 to restore your Joomla! 2.5 site. You just need to remove all existing files and folders, upload the backup archive and Kickstart and then start the archive extraction and restoration.

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

[email protected]
Thank you, Nicholas. I had read the documentation and deleted all files on my previous attempt, so I have now done that again and attempted a restore using Kickstart. Unfortunately, Kickstart failed par way through.
I checked that I had enough memory and that I had uploaded the backup files in binary mode, then tried again but it failed on each attempt.
I have uploaded the J01 and JPA backup files again but I did not want to risk another attempt to restore the site, so I used the Akeeba Extraction Wizard to carry out a dry run on my PC. This failed to complete the extraction with an error message “invalid archive format” part way through.
Is it possible for you to check out the backup files for me? If you can send me a private email, I will reply with the FTP login details.
Many thanks
David

nicholas
Akeeba Staff
Manager
Before doing that let's try something different: try using Kickstart on a local server. You can use XAMP, MAMP or WAMPserver to set up a local Apache-MySQL-PHP server with just a few clicks and no technical knowledge. Then just put kicsktart.php and the backup archive files in its root and run Kickstart, e.g. http://localhost/kickstart.php

If that fails too please check the following.

Do you have all backup archive parts? It's very likely that you have a multipart backup archive which consists of files with the same name and extensions .jpa, .j01, .j02 etc. You need all of these files to extract the backup. If any of these files is missing the extraction cannot proceed.

How did you download your backup archives? The best way is using FTP or FTPS in Binary Transfer Mode or SFTP (which is always using binary transfer mode). The same applies for uploads, so I guess you are already aware of this. But please do check again.

Did your backup archive transfer correctly or is it truncated? Please check the file size in bytes on both the server you backed up from, your local computer and the server you have uploaded the backup to. If any of these file sizes is different you have a truncated or corrupt-in-transfer backup archive.

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

[email protected]
Thank you, Nicholas. I'll try all you suggest and get back to you after the weekend.

Regards,
David

[email protected]
Hi Nicholas.

In answer to your questions, my backup was in two parts and both parts had been downloaded using binary transfer. The byte size on server and PC were identical.

I installed WAMP and although I had a few issues with the port, I managed to run Kickstart. In the default Hybrid mode, it failed as before about two thirds of the way through, so I changed to Write files Direct and checked the ‘Ignore most errors’.

This time it worked, except I received an SQL=DROP TABLE IF EXISTS `bwr25_ak_profiles` error message and could not continue with restoration of the database, which was disappointing having come this far.

Anyway, I then moved back to the server and ran Kickstart again using Write files Direct and 'Ignore most errors' and hooray - this this time it was entirely successful and I have my site back.

Many thanks for your help. I would be interested to know what the above error message means for future reference.

Best regards,
David

nicholas
Akeeba Staff
Manager
OK, we can now perform post-mortem on this issue.

The key change you made was using "Ignore most errors". This option is designed for cases like yours, when one of the backed up files was corrupt OR shrank in size during the backup. In both cases the file size reported by the operating system of your server (and written into the archive's header block) and the total file size read from the disk did not match. This causes a corrupt file entry in the archive.

When selecting the Ignore Most Errors option you are telling Kickstart to try its best to skip this file and find the next one to extract. It's exactly what I used to do manually with this kind of archives, only five million times faster. That's why I wanted you to run Kickstart on your computer first. If all else failed I'd ask you for this inconspicuous debug.txt file written by Kickstart when extracting archives which would tell me which file was FUBAR and if all else failed would allow me to manually amputate it from the archive with a hex editor and lots of patience (there are some archive mending tricks I couldn't teach Kickstart because they require intuition).

As for the SQL error, it was a temporary fluke in the MySQL server. It somehow lost connection. That's not at all common. Having that happen on top of a very rare corrupt archive issue begs for buying a lottery ticket: you're seriously beating the odds! Anyway. By the time you retried this error condition was resolved and everything worked smoothly.

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

[email protected]
Thank you for making me work it out for myself and for the PM explanation. I'm not that technical and I've learned a lot.

Many thanks,
David

nicholas
Akeeba Staff
Manager
You're welcome!

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

System Task
system
This ticket has been automatically closed. All tickets which have been inactive for a long time are automatically closed. If you believe that this ticket was closed in error, please contact us.

Support Information

Working hours: We are open Monday to Friday, 9am to 7pm Cyprus timezone (EET / EEST). Support is provided by the same developers writing the software, all of which live in Europe. You can still file tickets outside of our working hours, but we cannot respond to them until we're back at the office.

Support policy: We would like to kindly inform you that when using our support you have already agreed to the Support Policy which is part of our Terms of Service. Thank you for your understanding and for helping us help you!