Advertisement

Registration failed: Column 'checked_out' cannot be null

General questions relating to Joomla! 5.x.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting.
Forum Post Assistant - If you are serious about wanting help, you should use this tool to help you post.
Windows Defender SmartScreen Issues <-- please read this if using Windows 10
Post Reply
aimlesslady
Joomla! Intern
Joomla! Intern
Posts: 95
Joined: Tue Sep 25, 2007 11:50 am

Registration failed: Column 'checked_out' cannot be null

Post by aimlesslady » Mon Jun 17, 2024 3:32 pm

Since migrating to Joomla 4 & 5 when a user tries to register, after they submit the registration form they get this message Registration failed: Column 'checked_out' cannot be null
and the registration page is still there with the info filled in, minus the password fields.
No email is sent to activate the account, however, the user IS SUBMITTED AND ADDED TO THE USER LIST in the back end.
Registration is set to self.
What can we do not to have this error message and to get the emails to be sent?
FYI, we also use RSForms to register users and get the same error message using that.
However, other forms on the site that are submitted (not using the registration plugin) go through without a hitch, to both users and admin.

Advertisement
User avatar
ceford
Joomla! Hero
Joomla! Hero
Posts: 2818
Joined: Mon Feb 24, 2014 10:38 pm
Location: Edinburgh, Scotland
Contact:

Re: Registration failed: Column 'checked_out' cannot be null

Post by ceford » Mon Jun 17, 2024 6:42 pm


aimlesslady
Joomla! Intern
Joomla! Intern
Posts: 95
Joined: Tue Sep 25, 2007 11:50 am

Re: Registration failed: Column 'checked_out' cannot be null

Post by aimlesslady » Mon Jun 17, 2024 6:50 pm

I saw that but I can’t figure out which table to fix. The only registration table is rsform_registration and there is no checked_out field. I also looked at user’s table and there isn’t one there either. My system >database shows no problems.

User avatar
ceford
Joomla! Hero
Joomla! Hero
Posts: 2818
Joined: Mon Feb 24, 2014 10:38 pm
Location: Edinburgh, Scotland
Contact:

Re: Registration failed: Column 'checked_out' cannot be null

Post by ceford » Mon Jun 17, 2024 6:57 pm

Google to the rescue:

Code: Select all

SELECT DISTINCT TABLE_NAME 
    FROM INFORMATION_SCHEMA.COLUMNS
    WHERE COLUMN_NAME IN ('columnA','ColumnB')
        AND TABLE_SCHEMA='YourDatabase';

aimlesslady
Joomla! Intern
Joomla! Intern
Posts: 95
Joined: Tue Sep 25, 2007 11:50 am

Re: Registration failed: Column 'checked_out' cannot be null

Post by aimlesslady » Mon Jun 17, 2024 7:38 pm

But what is my table name? There isn’t one called registration

User avatar
ceford
Joomla! Hero
Joomla! Hero
Posts: 2818
Joined: Mon Feb 24, 2014 10:38 pm
Location: Edinburgh, Scotland
Contact:

Re: Registration failed: Column 'checked_out' cannot be null

Post by ceford » Mon Jun 17, 2024 8:46 pm

So, for me this query:

Code: Select all

SELECT DISTINCT TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME IN ('checked_out') AND TABLE_SCHEMA='jdm3'; 
Gives me 24 tables containing the column 'checked_out'.

contact_details and user_notes are the most likely to be related to registration. You may have other user related tables.

You could turn on debugging and set error reporting to maximum to see if you get a stack trace. I think the error message is coming from MySQL rather than Joomla but you might find out where it was triggered in the Joomla code.

aimlesslady
Joomla! Intern
Joomla! Intern
Posts: 95
Joined: Tue Sep 25, 2007 11:50 am

Re: Registration failed: Column 'checked_out' cannot be null

Post by aimlesslady » Tue Jun 18, 2024 2:56 pm

Thanks for sticking with me to figure this out. I am not so familiar with databases, but I put the query changing the prefix to my database in the SQL tab. It returned nothing. I also tried changing the debug in my global configuration to on and maximum. When I tried to submit the registration form I got the same error message and no other information. Any other ideas?

aimlesslady
Joomla! Intern
Joomla! Intern
Posts: 95
Joined: Tue Sep 25, 2007 11:50 am

Re: Registration failed: Column 'checked_out' cannot be null

Post by aimlesslady » Tue Jun 18, 2024 3:11 pm

I also checked my user_notes and contact_details tables and the checked_out column is set to NULL.

User avatar
ceford
Joomla! Hero
Joomla! Hero
Posts: 2818
Joined: Mon Feb 24, 2014 10:38 pm
Location: Edinburgh, Scotland
Contact:

Re: Registration failed: Column 'checked_out' cannot be null

Post by ceford » Tue Jun 18, 2024 4:30 pm

In the query I gave you needed to change 'jdm3' to your own database name. Somewhere you have a checked_out column that needs to have the default set to NULL. This problem could be related to RSForms. Have you asked them for help?

aimlesslady
Joomla! Intern
Joomla! Intern
Posts: 95
Joined: Tue Sep 25, 2007 11:50 am

Re: Registration failed: Column 'checked_out' cannot be null

Post by aimlesslady » Tue Jun 18, 2024 4:38 pm

I have asked them for help. Because it happens with the core registration they say it is a Joomla core issue.
So jdm3 is not your prefix but it is your database name? I will try substituting that with my database name. Do I do this in my database to information schema?

User avatar
ceford
Joomla! Hero
Joomla! Hero
Posts: 2818
Joined: Mon Feb 24, 2014 10:38 pm
Location: Edinburgh, Scotland
Contact:

Re: Registration failed: Column 'checked_out' cannot be null

Post by ceford » Tue Jun 18, 2024 4:45 pm

Just use the query in the phpMyAdmin - SQL button at the top of the page.

aimlesslady
Joomla! Intern
Joomla! Intern
Posts: 95
Joined: Tue Sep 25, 2007 11:50 am

Re: Registration failed: Column 'checked_out' cannot be null

Post by aimlesslady » Tue Jun 18, 2024 5:28 pm

Thank you for your patience. I made the query and saw a list of tables. None other than the 2 you mentioned seemed relevant.
But here is an update:
Since I tried changing the checked_out in those 2 tables, tested it, which didn't seem to help, changed it back then saw an update for rsforms and their registration plugin, updated it, and did a global check-in for the database (for the user_notes) it now seems to be working. I don't know what fixed it or a combination, but it works.
Thaks for you help. If nothing else, I learned something about searching for columns with a query.

Advertisement

Post Reply

Return to “General Questions/New to Joomla! 5.x”