Support

Akeeba Backup for Joomla!

#38922 Error installing on Joomla: SQL Table 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
PHP version
8.1
Akeeba Backup version
9.5.1

Latest post by nicholas on Thursday, 27 April 2023 23:48 CDT

Jewels75

I did a clean install of Joomla the other night (I didn't use Softaculous as it gave a lot of issues). I started re-installing my extensions last night and when I got to akeeba, I got an error:

JInstaller: :Install: Error SQL Table 'ultravio_main.dlsjg_akeebabackup_profiles' doesn't exist
Extension installation aborted.
Package Install: There was an error installing an extension: com_akeebabackup-pro.zip
Error installing package

I brought it up on the forums of Joomla.org and they said I should be contacting you.

Any insights?

 

My site's url:  Home (ultravioletstudio.com) (sorry I didn't put it in the url field, I couldn't submit a ticket when I filled out the field)

nicholas
Akeeba Staff
Manager

This is not a clean installation, or at the very least Joomla does not think it is.

When you install an extension, Joomla needs to decide if this is a clean installation or an update and apply a different set of database queries depending on this decision. It makes this decision by looking up information in two tables.

First, it looks in the #__extensions table, in this case: type=component, element=com_akeeba. If there is no record there it is a clean installation.

Note: #__ is meant to be replaced with your table naming prefix, the common few characters and an underscore all of your Joomla and third party extension tables start with.

If there was a record in the #__extensions table, it reads its extension_id. Then, it looks up the #__schemas table for a record with the same extension_id. If none is found it is a clean installation.

If a #__schemas entry is found, it reads the version_id, then it applies all upgrade database queries from the next version onwards.

For some reason, Joomla believes that you have Akeeba Backup already installed, i.e. there is an #__extensions table and a #__schemas table record for it in the database. As a result it tries to apply the update database queries which (reasonably) assume the database tables for Akeeba Backup exist. Since they do not exist, Joomla's extensions installer errors out.

The solution in this case is to remove the #__schemas and #__extensions table records for Akeeba Backup, then retry the installation.

If System, Manage, Extensions shows Akeeba Backup as installed: uninstall it. This will do the trick. Note that you may see it listed as COM_AKEEBABACKUP if the language files for Akeeba Backup are missing.

If that page does not show Akeeba Backup as installed or you cannot uninstall the component we will need to do it The Hard Way: editing the database directly. If it comes to that, let me know and I will ask you for connection information to your site.

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!

Jewels75

I see com_akeebabackup in my list of extensions.

When I try to uninstall I get the following:

Joomla\CMS\Filesystem\Folder::delete: Path is not a folder. Path: [ROOT]/administrator/components/com_akeebabackup Joomla\CMS\Filesystem\Folder::delete: Path is not a folder. Path: [ROOT]/api/components/com_akeebabackup Joomla\CMS\Filesystem\Folder::delete: Path is not a folder. Path: [ROOT]/components/com_akeebabackup Component Uninstall: Can't uninstall. Please remove manually.   I don't see com_akeebabackup in any of the folders mentioned above, in my FTP client.   I swear, I've had the weirdest stuff going on with my site. Ever since I found out I had security issues with my site (that I had for two years apparently, since the Softaculous install from CPanel, installing Joomla 3). I've had one issue after another. Solve one problem, find another, like a domino.   I will need to provide you with my info. Let me know how I can do this.

Jewels75

Sorry, me again. I'm going to remove joomla from my site and install it again to see if the com_akeebabackup shows up, before I do anything else. If it does, I honestly don't know what's happening with my website.

I didn't get very far with redoing my website, I got as far as installing my template, importing my content, and installing a couple of extensions before I tried akeeba.

Will keep you posted.

Jewels75

Success! I reinstalled Joomla 4 and the first thing I did was check the list of extensions. No akeeba to be seen. I went ahead and hit install and it installed perfectly.

Thank you so much for your help!

If I had been far into recreating my site, I would have had you fix the database but I thought why bother you with this when I could just start over.

nicholas
Akeeba Staff
Manager

Fair enough :) I am glad it's now working.

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!