Support

Admin Tools

#40005 AdminTools 7.4.5 database problems after 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 nicholas on Tuesday, 19 December 2023 07:47 CST

sparksarts

After updating AdminTools Pro from 7.4.4 to 7.4.5, Joomla's Maintenance: Database shows 1 problem with AdminTools. Selecting AdminTools and clicking the Update Structure button does not solve the problem.

Tooltip on the 1 Problem badge shows these issues:

  • Table 'xx_admintools_log' has the wrong type or attributes for column 'reason' with type enum('other','admindir','awayschedule','adminpw','ipwl','ipbl','sqlishield','antispam','tpone','tmpl','wafblacklist','template','muashield','csrfshield','badbehaviour','geoblocking','rfishield','dfishield','uploadshield','xssshield','httpbl','loginfailure','securitycode','sessionshield','external','nonewadmins','nonewfrontendadmins','configmonitor','phpshield','404shield','itemidshield'). (From file 7.1.1-20220209.sql.)
  • Table 'xx_admintools_log' has the wrong type or attributes for column 'reason' with type enum. (From file 7.4.5-20231214.sql.)
  • 10 database changes were checked.</li><li>19 database changes did not alter table structure and were skipped.
  • 19 database changes did not alter table structure and were skipped.

This same issue occurred on all 18 of my Joomla 4 websites.

Demo video: https://share.zight.com/yAuB7j10 

 

nicholas
Akeeba Staff
Manager

There is no need to worry. This is a cosmetic Joomla! issue.

This is Joomla failing to understand what our update SQL code does, thereby WRONGLY inferring that the database is not updated. As far as I know, this is a known issue with ENUM fields and we've certainly seen it before (in Akeeba Ticket System, a few months ago). It's not causing any problem other than it being annoying, and us having to tell people that yeah, this is Joomla dropping the ball, nothing to see here.

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!

sparksarts

Thanks for the explanation. I love your sarcasm!

nicholas
Akeeba Staff
Manager

:)

We've published version 7.4.6 which solves the problem. We had to erase a file, pretending Admin Tools 7.1.1 (the last time we had previously updated this table column) never existed. This convinced Joomla to see only the latest file and happily report that everything is fine.

This must be the silliest reason I've ever had to make a new release. In the end of the day, the problem is that Joomla! saw this column had changed twice, in version 7.1.1 and 7.4.5, correctly saw that it follows version 7.4.5, then stupidly reported that the column no longer adheres to the two and a half years older version 7.1.1.

I would've normally filed this as a bug, but they've blocked me from submitting bugs on GitHub and/or the Joomla! issue tracker. So, yeah, all I can do is being sarcastic and work around obvious bugs in Joomla instead of, you know, fix them like I had been doing between 2009 and 2014. Hopefully someone else will let the maintainers know and they will fix this issue. It's simple, really. It's just a case of filtering an array, hint hint wink wink for any core maintainers reading this.

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!