Support

Akeeba Backup for Joomla!

#41231 The last error message was: Akeeba\Engine\Dump\Base :: Database Error: Unknown table 'VIEW_TABLE_USAGE' in information_schema SQL=SELECT DISTINCT `TABLE_NAME` AS `dependent`

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
5.2.0
PHP version
8.2
Akeeba Backup version
9.9.7

Latest post by woluweb on Wednesday, 23 October 2024 04:23 CDT

woluweb

Hi,

I have just migrated a J3 website to J4 (where I then install the new J4 versions for Admin Tools and Akeeba Backup, where I migrated the Settings).

Then I migrated to J5.

The whole website works well... but when I want to run my very first backup on this freshly migrated J5 website, I get the following error.
Never had such an error msg.
What should I do?
Txs!

Marc

---

The backup operation has been halted because an error was detected.
The last error message was:

Akeeba\Engine\Dump\Base :: Database Error: Unknown table 'VIEW_TABLE_USAGE' in information_schema SQL=SELECT DISTINCT `TABLE_NAME` AS `dependent`, `REFERENCED_TABLE_NAME` AS `dependency` FROM `INFORMATION_SCHEMA`.`KEY_COLUMN_USAGE` WHERE `TABLE_SCHEMA` = DATABASE() AND `REFERENCED_TABLE_SCHEMA` = `TABLE_SCHEMA` UNION SELECT DISTINCT `VIEW_NAME` AS `dependent`, `TABLE_NAME` AS `dependency` FROM `INFORMATION_SCHEMA`.`VIEW_TABLE_USAGE` WHERE `VIEW_SCHEMA` = DATABASE() AND `TABLE_SCHEMA` = DATABASE();

nicholas
Akeeba Staff
Manager

This is a known issue with old versions of MySQL and MariaDB. I will be releasing a new version today with a workaround for these very old versions of MySQL / MariaDB.

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!

woluweb

Thank you so much Nicholas!

FYI, the database version is the following; 10.5.21-MariaDB (and PHP is 8.2.5).

For the completeness of the information / analysis, I also double checked: I have about 20 other websites having exactly 10.5.21-MariaDB and where there is no issue. But these are always
- either J3 websites
- either J5 but "fresh J5" and not "J5 migrated from J3" websites

(I am of course available if you want to have credentials or if you want me to conduct any additional test)

nicholas
Akeeba Staff
Manager

This is a known issue with old versions of MySQL and MariaDB. I will be releasing a new version today with a workaround for these very old versions of MySQL / MariaDB.

Any version of MariaDB before 11.0 and any version of MySQL before 8.0 are by definition "old" as they are at least one major version behind the current version of said database.

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!

woluweb

OK, good then :)  !

nicholas
Akeeba Staff
Manager

9.9.8 is out

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!

woluweb

Txs Nicholas,

Just installed it on that website and the backup is now running fine :)

Yoohoooo.

Txs again !

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!