Support

Admin Tools

#36270 DB errors

Posted in ‘Admin Tools 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
n/a
PHP version
n/a
Admin Tools version
n/a

Latest post by gstyles on Monday, 06 December 2021 06:32 CST

gstyles

Please see attached image. Thanks GWS

nicholas
Akeeba Staff
Manager

This is a known issue. This has to do with the way the database page in Joomla works. It goes through all of the update SQL files sequentially. If version X updates the schema of table and version X+1 drops that table because it's no longer necessary Joomla reports an error with the intentionally removed table.

Essentially and against its own documentation, Joomla requires developers to retroactively modify their database update scripts. There are ways around that but they result in the Database page not picking up the changes, meaning it's unable to fix a broken database table. As I've written many time in the past, Joomla's extension installation is subpar and unfit for purpose. Several people were telling me that I only say that because I have mown framework. Well, fine. Here is me trying to use Joomla's subpar features. Here is the proof that even on a very simple case, dropping a table, Joomla trips over its own feet.

In any case, this will be fixed by retroactively changing the update SQL files in a new release scheduled for later today.

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!

gstyles

Thanks for heads up Nicholas. I'll wait for the update.

nicholas
Akeeba Staff
Manager

We just made the release. You should see it available on your site in a few hours.

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!

gstyles

Now that is good service.Thanks.

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!