Support

Akeeba Backup for Joomla!

#43173 Problems with views

Posted in ‘Akeeba Backup for Joomla!’
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.4.7
PHP version
9.4
Akeeba Backup version
10.3.6

Latest post by nicholas on Sunday, 19 July 2026 13:02 CDT

Sunday, 19 July 2026 09:26 CDT

[email protected]
I've encountered a major problem.
I'm trying to restore a backup, but during the restore process, I get a "table does not exist" error when creating a view. Upon further investigation, I noticed that the file containing the view, in the export, is named site.s140, while the table creation is in the site.s202 file.
Perhaps this explains why it's not finding the table when creating the view. Is it perhaps creating the view before the table?
Can you explain how to proceed?
Thanks, Nathan

Sunday, 19 July 2026 13:02 CDT

nicholas

In the Database Restoration page set "With existing tables" to "Backup" and "Stop On Create Error" to No (grey).

These problems normally only happen when there are circular table references, when the referenced tables' names are substrings of other backed up tables, or the view definition has nested subqueries which cannot be analyzed correctly by the SQL lexer/parser. It's also possible you used an older version to take the backup; older versions allowed you to disable the table/view dependency analyzer which could lead to this chicken and egg problem.

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!