Support

Akeeba Backup for Joomla!

#37366 Database Support Problem on restore

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
3.10.10
PHP version
8.1 & 7.4 (I've tried both)
Akeeba Backup version
8.1.7

Latest post by nicholas on Tuesday, 28 June 2022 01:29 CDT

mccolley

I have been trying to restore a site on a customer's account but got an error in the preflight saying there was no support for the database. 

I did this several times with different backups and each failed for the same reason.

Then I took one of the backups and tried to recover it on my hosting (also Dreamhost). Same result.

I just tested a backup from a completely different site and got the same failure.

Is there a method for extracting the files manually so I can get this site back up?

 

nicholas
Akeeba Staff
Manager

If you click on Next does it work? If it does, there's nothing else you need to worry about. If it doesn't, it tells you what to do on your server.

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!

mccolley

Hi Nicholas,

I'm struggling to understand how this process is no longer working.  The error message I get is:  Database: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation. 

My hosting company says there have been no access changes recently.  I am attempting to restore to a previously created empty database (although the pre-flight warning happens before any access info is provided).

My backup is only days (6/22) old and I keep Joomla 3.10.10 and Akeeba (8.1.7)  updated (although I don't know the versions used since both got updates this week).  My version for Kickstart is also the latest 7.1.2.

How can I test where the breakdown is occurring?

 

nicholas
Akeeba Staff
Manager

Okay, this is useful information, I know what exactly is the problem. It's a bug we have fixed in Akeeba Backup 8.1.8. So let's see what we can do about it.

If you can take a new backup: upgrade to Akeeba Backup 8.1.8, take a new backup and restore it. You will not have this problem.

If you cannot take a new backup: try using PHP 7.4 first. If this is not possible or if this does not work please let me know, I will have to give you the updated installer and instructions to use it with your existing backup.

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!

mccolley

Thanks, Nicholas

Switching back to PHP 7.4 and clicking past the preflight warning did most of the trick.  Since I was comparing the workings of two versions of a component that broke some things with an update, I made gooid use of your troubleshooting guide, as well.

As always, thanks for the quick response.

nicholas
Akeeba Staff
Manager

You're welcome and I apologise for the restoration script issue. We tried to fix a PHP 8 issue and it didn't go very smoothly. At least we got something out of it, we rethought the way the Database Support message is displayed and what to do if there is indeed no database connection method the restoration script can use to restore your site's database.

Have a great day!

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!

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!