Support

Akeeba Backup for Joomla!

#39103 SQL Table 'xxx_akeebabackup_profiles' doesn't exist

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
4.3.2
PHP version
n/a
Akeeba Backup version
8.0.29

Latest post by nicholas on Thursday, 15 June 2023 08:31 CDT

wicko

I have recently updated my Joomla site from 3.9 to 4.3.2. Because of the warning with the update I uninstalled all Akeeba products and intended to reinstall the JM4 versions once the site was up and running.

So I have been able in reinstall Akeeba Admin Tools Pro but am unable to install Akeeba Backup Pro as says the SQL tab le is missing. I see this error also in the system setting in the database option. If I press tom update the structure it fails.

danger Table 'databaseName.xxxxxx_akeebabackup_profiles' doesn't exist   How can I fix this issue and reinstall Akeeba Backup?   Version installed: pkg_akeebabackup-9.6.1-pro   regards
David

Web design and development in Reading and Oxfordshire UK.

Wicko Web design

nicholas
Akeeba Staff
Manager

Do not trust the broken and untrustworthy information in the so-called “Pre-update check”. Its logic is completely broken. It tries to use the extension update information to determine if a version of an extension is compatible with the new version of Joomla. This is idiotic, and I have told the Joomla! maintainers four times between August 2020 and July 2021 (the year prior to the Joomla 4.0 stable release).

Extension developers will of course choose to not make available an older version of their extension to a newer Joomla version. We do not want people installing Akeeba Backup 8 on Joomla 4, even though technically it is compatible. The reason is that it does not and cannot have full support for some Joomla 4 features which are not present in Joomla 3. Joomla shows that in the “pre-update check” as Akeeba Backup 8 not being compatible with Joomla 4 which is, not to put too fine a point on it, utter bollocks and completely against our official migration guide. Do note that the latest version of Akeeba Backup 8 includes a system plugin which hijacks the results of the “pre-update check” to restore the truth about our software. We shouldn't have to do that. Joomla MUST NOT give false information to its users and spread FUD about third party software. What they are doing is class action lawsuit material. I have warned them.

It would further seem that the uninstallation didn't fully work and you are left with entries in the #__schemas table about Akeeba Backup which further mislead Joomla's utterly broken extensions installer code to treat this as an update, instead of a clean installation. Hence the error message you receive. When I tried reporting this and other major problems with the Joomla extensions installer and updater I was treated like rubbish, they personally attacked my professional capacity and integrity, and when I submitted a Code of Conduct violation form I was laughed at and blocked from contributing to Joomla because I "cause drama". Well, if reporting real issues and asking to not be slandered for that is "drama", sure, I do. If the Joomla maintainers don't want to interact with their community they should just take the project private and let the community fork it into something that is actually community-led, not just in theory. As a side note, all other major extension developers have long stopped contributing to Joomla exactly because of this toxic behaviour from the project's leadership. Now the Joomla maintainers are on their own. They made their bed, they have to sleep in it. But I digress.

The first thing you can try in your case is to completely uninstall and reinstall Akeeba Backup. Please remember that you need to uninstall the Akeeba Backup package extension, not the component.

If this doesn't help, uninstall Akeeba Backup once more. Then look in your #__extensions table. Is there a row with element = com_akeeba? If so, note down the extension_id for that row. Then open the #__schemas table. Find the row in that table that has the same extension_id you noted before and delete it. This will finally let Joomla do a clean install of Akeeba 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!

wicko

Wow I can understand your frustration. This is quite concerning for those who continue to build sites on Joomla.

I will personally mention this to Brian Teeman. There where regular meet up events for Joomla 4 and perhaps this might be a good place to voice your concerns. Joomla was always my preferred CMS but has become a bit static.

As for Akeeba, I am one of many who consider your products to be a must on any CMS install. I work on many sites both Jooma and WordPress and but Akeeba products on the top of the list when building up these sites.

 

So this is what I did.

I looked at the Extension tables and deleted the com_akeeba-backup table. I then tried to install again and it still failed but did recreate the table in extensions. I checked the #_schema table and could see duplicate tables with the same ID that related the the table error notified in the JM4 database structure page. I removed these but this still did not allow me to install the plug.

So I then downloaded the JM3 version 8.3.1 and installed that which installed fine. I was then able to reinstall the JM4 version 9.6.1 successfully. Interestingly enough the table from the original error has still not been created in the database but only the #_akeeba_common table. However I now have 2 Akeeba backup menus in components. One says to continue to migrate V8 to V9 but then the other does not open and says there are error sayingthe Akeeba database tables are corrupt. 

Looking at the database for my JM3 version of the site this does not have the com_akeebabackup_profiles table.

In JM4 I then uninstalled the Abeeka Backup V9 and then opened the V8 version in Components. This as before said I needed to migrate to V9 that was compatible to JM4. I then installed V9 again and was able to open the new version in Components and complete the migartion and then uninstalled the V8 version.

I have since managed to create a backup stored on Dropbox. I did see this warning when creating the backup Akeeba\Engine\Dump\Native\Mysql :: Table #__content_frontpage has a prefix of #__. This would cause restoration errors; table skipped.

So this is looking to have now installed ok but there are still a few issues which probably related to the upgrade from JM3 - JM4.

 

regards

David

Web design and development in Reading and Oxfordshire UK.

Wicko Web design

nicholas
Akeeba Staff
Manager

Yeah, something looks to have been VERY stuck in your database or your filesystem. The usual suspects are phantom records in #__extensions or #__schema, with a very plausible runner-up being a leftover package manifest file in administrator/manifests.

This could all be solved if Joomla had advanced options in the installer interface, one of them being “Treat this as a fresh installation” which would tell Joomla's code to nuke the extension folders before writing files into them, and run the extension's installation SQL files (instead of the update SQL files). Of course, that's a very pragmatic approach to the messy state real-world sites end up in. If you were to try to explain that to Joomla maintainers who only understand ideal conditions in a lab environment they will not “get it”. If they don't “get it” they will not allow it to be implemented, even if there are willing bodies to do the work.

This is where my frustration stems from. In the past, us 3PDs were Joomla's “reality check”, its grounding. We offer support to our clients, we see how nonsensically messy real sites can get, we figure out why stuff breaks, and how to fix them. We were allowed to offer our insight as issued, code fixes, and entire features. Over the past decade, we were pushed aside. Demoting issues talking about more generic stuff to "discussions" and making the RFC process opaque and impenetrable from outsiders has led Joomla to become an echo chamber for its so-called leadership. This is a dangerous position for any organisation to find itself in.

The only light at the end of this tunnel is that there are people in the organisation who are trying to undo the lasting damage of the project's restructuring in 2015. Why, yes! The echo chamber Joomla leadership has found itself in was caused by that restructuring. I had explicitly warned them about what would happen before (https://www.dionysopoulos.me/refactoring-joomla.html) and towards the conclusion (https://www.dionysopoulos.me/the-problem-is-the-vision.html) of the restructuring. I didn't fall from the sky, I was a business consultant for Christ's sake! I saw all the red flags of dysfunctional organisations in the proposed structure. Hence this this comment of mine, made 9 years ago, reads today as eerily prescient.

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!