Support

Akeeba Backup for Joomla!

#40494 mysqli_result object is already closed

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.4.3
PHP version
8.2.12
Akeeba Backup version
9.9.0

Latest post by nicholas on Tuesday, 26 March 2024 16:10 CDT

timread

Hi,

At the point Akeeba backup is trying to backup the database I get this error:

mysqli_result object is already closed

and the backup stops

I'm using Akeeba Backup Professional for Joomla!™ 9.9.0
PHP Version 8.2.12
Joomla! 4.4.3

And running the website on Xampp v3.3.0

Please see logfile attached.

Thanks, Tim

nicholas
Akeeba Staff
Manager

Your actual problem is a few lines above that:

WARNING |20240326 17:27:23|Failed dumping sde_categories from record #0. MySQL error 1194: Table 'sde_categories' is marked as crashed and should be repaired

This tells you that MySQL reports that the sde_categories table is crashed. Since the table is crashed, you get a snowball of errors which ends up with the MySQL connection being dropped, which is the final error reported and the one you saw.

The obvious solution would be to go into phpMyAdmin, select the table, scroll down to the "With Selected:" dropdown and choose Repair.

However, the tables with the sde_ prefix look like they belong to a Joomla! 1.5 or 1.0 installation since I can see the table sde_core_acl_aro which only existed in those ancient Joomla! versions. I actually see plenty of tables which appear to be leftovers of ancient sites, including those with the fac_ prefix.

My recommendation is to exclude all tables which have nothing to do with your site. Go to Akeeba Backup, Control Panel. Click on RegEx Database Exclusion. Click the plus (+) button at the bottom of the (possibly still empty) listing. For the Type select "Exclude this table" and for the Filter Item type in !/^#__/ then click on the save (diskette) button. This instructs Akeeba Backup to just skip over these tables.

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!