Support

Admin Tools

#40969 Column 'checked_out' cannot be null

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
5.1.2
PHP version
8.2.21
Admin Tools version
7.5.4

Latest post by nicholas on Friday, 02 August 2024 01:45 CDT

bizguy

Upon registration using Community Builder get the following Error

  • Column 'checked_out' cannot be null

I found a ticket in the Community Builder forum that identified Admin Tools as the cause of the issue in their case, and when I disabled it, my issue was resolved as well.

Thanks,

Ed

 

nicholas
Akeeba Staff
Manager

This message is too vague. The only checked_out column we use in any of our tables is in the URL Redirect feature, and it does allow being null. All I can think of is that your tables are out of date, and Joomla's useless "database fix" cannot fix them. This may happen if you had upgraded from Joomla! 3, but Joomla failed to apply the necessary database changes we have included in Admin Tools 7. Let's just say that Joomla's extension updater is not very well written, and Joomla's method for updating database tables leaves A LOT to be desired...

There is one way around that. Export your settings, uninstall the Admin Tools package extension, make sure all tables with _admintools_ are indeed removed, then install Admin Tools again and import your settings.

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!

bizguy

Thanks Nicholas.

I followed your recommendation above:

  • backed up and downloaded my Admin Tools setting, 
  • uninstalled Admin Tools,
  • confirmed all Admin Tools tables were removed from the Joomla DB,
  • ran the Joomla DB fix, although there were no reported issues,
  • reinstalled Admin Tools,
  • imported my saved settings,
  • added my Download ID,
  • tested registering a new member.

The issue remains, so I have disabled Admin Tolls again.

If I can provide more information, just let me know.

Ed

nicholas
Akeeba Staff
Manager

Could you please ask the person who determined that the problem is Admin Tools to please contact us with information on what is going on? A problem we cannot reproduce on software we do not have access to with an error message that could literally be anything is not very helpful, nor is a recommendation to drop all of your site's defenses and let it get hacked a valid recourse. We'd like to find out what the problem is, and address it.

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!

bizguy

Thanks for the reply Nicholas.

I rely on Admin Tools (AT) to protect both Joomla and WordPress sites I maintain, which is why I posted this ticket in the first place. Believe me it was with great reluctance that I unpublished it, but as this was the only mention of a solution to the issue, I used it. The client already had to deal with 38-new registrations that didn't complete because of the issue, and I wanted to avoid more.

Here is the ticket I found on the Community Builder (CB) website #333894

I am unconvinced that AT is the cause of this issue, as I have another site that includes both CB and AT, which doesn't have this issue, but I needed a solution.

I am happy to provide more information or access is that will help solve this issue.

Thank you.

Ed

nicholas
Akeeba Staff
Manager

Yeah, I found that forum post as well. However, I do not use Community Builder. I do not have access to post on their forums, nor can I reproduce the issue. I would like you to help me.

If you cannot get in contact with that person making that claim in the forum that you have access to but I don't, I have another way for you to help me.

Re-enable Admin Tools.

Go to your site's backend, System, Global Configuration. In the System tab set Debug System to Yes. In the Server tab set Error Reporting to Maximum.

Reproduce this error and you will have a far more detailed error report with a stack trace. Please copy it and paste it into your next reply.

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!