Support

Akeeba Backup for Joomla!

#12440 Backup Failed - Show View command denied to user

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 user64052 on Sunday, 27 May 2012 11:15 CDT

Sunday, 27 May 2012 01:16 CDT

user64052
Mandatory information about my setup:

Have I read the related troubleshooter articles above before posting (which pages?)? No
Have I searched the tickets before posting? No
Have I read the documentation before posting (which pages?)? No
Joomla! version: (unknown)
PHP version: (unknown)
MySQL version: (unknown)
Host: (optional, but it helps us help you)
Akeeba Backup version: (unknown)

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.

Description of my issue:

Sunday, 27 May 2012 06:45 CDT

nicholas
You have to ask your host to give your MySQL user the SHOW VIEW privilege. Right now there is one MySQL VIEW in your database and we are not allowed to view its definition. If Akeeba Backup would let you ignore that error, you'd end up with an incomplete backup, that's why we choose to fail the backup in this case.

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!

Sunday, 27 May 2012 11:09 CDT

user64052
Is this a result of a recent change to Akeeba? I am asking because I have been using it successfully for a very long time. All of a sudden I am getting this error and I don't believe I made any changes.

Sunday, 27 May 2012 11:15 CDT

nicholas
No, it is because you installed or updated a component which now uses MySQL VIEWs. In case I didn't make this clear, this error message does not come from Akeeba Backup, it comes from your database server. Your database server complains that your database user is not allowed to list VIEWs. In short, the issue has little to do with Akeeba Backup's code and has everything to do with the kind of stuff you've got on your database and how it works.

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!

Sunday, 27 May 2012 11:15 CDT

user64052
Ok, nevermind. Found the problem. Somehow the "Show View" privilege for the MySQL user had been disabled. All is good.

Thanks for the prompt reply.

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!