1048 Column 'checked_out' cannot be null

[DorsetJoomla]

I have just migrated a site to Joomla 4.3.2 and whenever I go to make changes to an article and save it I get the message 1048 Column 'checked_out' cannot be null The site seems to work but this is annoying. Any suggestions? Database structures report as OK Thanks

[pe7er]

That erros is caused because Joomla tries to save the article with "checked_out" as null.
While your database table structure has that field defined as default value "NOT NULL".

The current J4 has that field defined as
"`checked_out_time` datetime NULL DEFAULT NULL,"
see in the block where #__content is defined, currently line 174: https://github.com/joomla/joomla-cms/bl ... nsions.sql

Use phpMyAdmin to change that field as "default NULL" (as precaution, create a backup of your database before doing so)

[DorsetJoomla]

Thanks for your reply. I have got into the database but not sure what I am looking for to make the change you suggest.
Thanks Dennis

[sozzled]

See (among others):

• viewtopic.php?t=989118
• viewtopic.php?t=999865
• viewtopic.php?t=988520
• viewtopic.php?t=988191
• viewtopic.php?t=988544
• https://www.joomlapolis.com/forum/profe ... ot-be-null
• https://issues.joomla.org/tracker/joomla-cms/39760
• https://github.com/joomla/joomla-cms/issues/29271

[nehabhushan94]

@pe7er it seems that the field _is_ nullable, in which case, it might not be the fix for OPs question..

or am I reading this wrong?

[pe7er]

@pe7er it seems that the field _is_ nullable, in which case, it might not be the fix for OPs question..

Yes, you are right. In Joomla 4 that field is nullable indeed.
In Joomla 3.10 that field was "NOT NULL", see line 366 in https://github.com/joomla/joomla-cms/bl ... joomla.sql

Code: Select all

`checked_out` int unsigned NOT NULL DEFAULT 0,

When a site has been migrated from 3.x to 4.x and something went wrong during the migration, that field might still be "NOT NULL". Which can cause the issue mentioned by the topic starter.