Support

Admin Tools

#40009 database problem after latest update

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
4.4.1
PHP version
8.2.13
Admin Tools version
7.4.5

Latest post by toonetcreation on Tuesday, 19 December 2023 02:26 CST

toonetcreation

Hi,

After latest admin tools update I get this : https://i.imgur.com/wvVCWWb.png

Same problem after clicking on update database button.

L.

nicholas
Akeeba Staff
Manager

TL;DR: There is no need to worry. This is a cosmetic Joomla! issue. There is nothing anyone can do about it.

For more detail, read on.

Whenever a Joomla! extension's developer updates the structure of the database table of their extension they provide an update SQL file. This file has special SQL code called DDL (Data Definition Language) statements. These are executed when you update the extension and modify the database structure.

This part already ran on update, therefore your database structure is fine.

Joomla! also tries to be “smart” about it, in the sense that that it will try to understand the DDL statements' intent and check the database to figure out if its structure matches the intent it has detected.

Unfortunately, Joomla took the computationally cheap but otherwise problematic approach of using regular expressions to parse DDL statements instead of the correct way of using a parser and lexer (that's the only reliable way a programming language like SQL can be parsed). The result is that we often have a disparity between what the SQL code is meant to do and what Joomla! understands. This disparity leads to misleading errors, like the one you are experiencing.

There is no functional problem here. To the contrary, if we remove the update code we will clear the misleading Joomla database warning, sure, but that would cause a functional error to anyone updating from an earlier version.

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!

toonetcreation

many thanks for your reply nicholas ;-)

was just for info.

but thanks again for the clarification

have a nice christmas

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!