Support

Pre-sales

#39091 Thinking of Subscribing but...

Posted in ‘Pre-sales and Account Questions’
This is a public ticket

Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.

Latest post by nicholas on Tuesday, 13 June 2023 07:02 CDT

AllyNat

I have used Akeeba free on Joomla 3 previously but now I am on Joomla 4 using PHP8.1, I find issues I need to overcome that may be resolved with purchasing a pro license.

 

My first issue issue is that if I backup a databse only, I get the errors listed below, despite the backup completing successfully.

My Second issue is, does the pro version enable multi select database table exclusion, rather than having to double click the exclude icon for EVERY table?

Undefined property: stdClass::$name in /administrator/components/com_akeebabackup/tmpl/profiles/default.php on line 66

PHP Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /libraries/src/HTML/Helpers/Grid.php on line 122

PHP Warning: Undefined array key "id" in /libraries/src/Table/Table.php on line 1009

 

Thank you for your advice.

 

Ally

nicholas
Akeeba Staff
Manager

Regarding the PHP notices, it would appear that something is broken in your database. It claims there is a backup profile with no ID and no name which is not possible. This is something we can try to fix in your database if you are a subscriber.

Regarding the database table exclusion, you do not need to double click on the icon. You need to single click. When you double click the second click is ignored.

There is a reason I decided against multiple selection lists back in early 2010, after trying to implement the interface that way. A multiple selection would require you to CTRL-click (or CMD-click on a Mac) on each item which is far less practical, especially given the fact that you would need two lists for Exclude This and Exclude Data. Trying to correlate two multiple-select lists is frustrating and error-prone even for me, on a site where I could recite the table names by heart. Doing so when the two lists won't have the same number of items (some database items have to be forcibly excluded in some way, e.g. temporary tables from both and VIEWs only in Exclude Data as they are stored SELECT queries) is borderline torture. Add the fact that a mis-click without holding down CTRL / CMD will clear all selections but the one you just clicked, something which can easily happen with a laptop trackpad as I found out the hard way during my experimentation, and you know exactly why all those years ago I chose to create a different, more streamlined interface to avoid multiple-select lists. Moving back to multiple-select lists would be a massive downgrade.

If you want to exclude multiple tables which all start from the same common string, let's say all tables whose name starts with #__foo (remember, #__ is the common database table name prefix), then yes, the Professional version allows you to use the RegEx Database Table Exclusion feature. In this case you would type /^#__foo_/ as your filter. If you want to exclude all tables which do not belong in your current Joomla installation —what I assume is what you are trying to do— you just need to create a filter for !/^#__/ which reads as exclude every tables whose name does not start with the database table name prefix configured for this site. No more clicking a ton of table names, no more having to redo that every time the number or names of the other tables changes. These, and solutions to other common use cases, are given in the documentation. If you can't figure it out, you can tell us which tables you want to exclude and we'll tell you what to do.

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!

AllyNat

Hello Nicholas

 

Thank you very much for this comprehensive response.

I am now able to fully understand my problem following your explanation.

Case closed.

 

Regards

Ally

nicholas
Akeeba Staff
Manager

You're welcome! have a wonderful 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!