Support

Akeeba Backup for Joomla!

#37809 Instalation problem

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.2
PHP version
7.4
Akeeba Backup version
9.3.2

Latest post by nicholas on Friday, 30 September 2022 10:54 CDT

Gosiaeu

NIEZWYKLE WAŻNE : Dołącz plik ZIP zawierający plik dziennika Akeeba Backup, abyśmy mogli pomóc Ci w rozwiązaniu problemu z tworzeniem kopii zapasowych lub przywracaniem. Jeśli plik ma ponad 10 MB, prześlij go na swój serwer i zamieść do niego link.

 

Hello,

I cannot install akeeba, I get this message:

JInstaller::Installation: SQL Table error 'u290060_jos6.jos_akeebabackup_profiles' doesn't exist

 

I'm looking forward to your response!

Gosia

nicholas
Akeeba Staff
Manager

It looks like you had previously installed Akeeba Backup but you did not uninstall it cleanly. Most likely you just deleted (some of) the component's files and its database tables. Unfortunately, this is NOT how you are supposed to uninstall extensions in Joomla. It leaves database records behind which tell Joomla that the extension is already installed. As a result, Joomla will try to upgrade instead of install the extension next time you try to install its package. However, since the database tables are missing the update process fails.

What you did requires removing the database records from the #__extensions and #__schemas table pertaining to the Akeeba Backup component. Please note that doing so will create orphaned entries in the #__assets table which may cause problems to your site. That's why you should never try to remove Joomla extensions manually.

If you have a backup of your site from before your failed attempt at manual uninstallation now is a good time to restore it. If this is not possible do what I said in the paragraph above having in mind that what you are doing did create a small problem on your site so please, never, EVER try to remove an extension's files and tables instead of uninstalling it through the System, Manage, Extensions page of Joomla.

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!

Gosiaeu

Welcome,

thank you for your reply.

I have not uninstalled anything manually, I always uninstall everything with the help of the system.
I did upgrade to J4 and this problem occurred.

 

Gosia

nicholas
Akeeba Staff
Manager

If you have just upgraded from Joomla 3 you could not have installed Akeeba Backup 9 — it's only installable on Joomla 4.

In this case something is wrong with your configuration.php file. Either your database name ($db) or the database table name prefix ($dbprefix) is wrong, namely there is a discrepancy in the lowercase and uppercase letters.

If this is not the case, something is broken in your database so despite the fact that we include a SQL script which tries to create a database table (and Joomla executes) your database server does not create the table. Therefore the next line in that script which tries to add the default backup profile cannot execute and returns the error you gave me. If this is the case you need to talk to your host. There is nothing you or us can do to fix a broken database (neither of us has the database access level required to do that).

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!