Joomla 4.0.5: 1048 Column 'checked_out_time' cannot be null

General questions relating to Joomla! 4.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
stawebnice
Joomla! Apprentice
Joomla! Apprentice
Posts: 32
Joined: Wed Sep 19, 2012 6:25 am
Location: Czech Republic
Contact:

Joomla 4.0.5: 1048 Column 'checked_out_time' cannot be null

Post by stawebnice » Sun Dec 19, 2021 8:18 pm

Hi,

please does anyone experience this?

Since I updated my web on 4.0.3 to Joomla 4.0.5 I am getting this error when I try to save any setting, menu, article, page builder page...

1048 Column 'checked_out_time' cannot be null

The Global checking shows only tables of SP page builder that it cannot clear at all.

Reinstall of Joomla does not work even through upload of package in administration :/

Database fix shows that everything is ok and even when I select all and click Fix, it does not help.

Does anyone know how to fix this, please?

Petra

User avatar
Per Yngve Berg
Joomla! Master
Joomla! Master
Posts: 28816
Joined: Mon Oct 27, 2008 9:27 pm
Location: Romerike, Norway

Re: Joomla 4.0.5: 1048 Column 'checked_out_time' cannot be null

Post by Per Yngve Berg » Sun Dec 19, 2021 9:09 pm

What table is the column in?

The column 'checked_out_time' is present in several tables. Those I have looked at have NULL allowed.

In J3 it does not have Null allowed.

User avatar
Yiannistaos
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 180
Joined: Sat Aug 08, 2009 11:37 am
Contact:

Re: Joomla 4.0.5: 1048 Column 'checked_out_time' cannot be null

Post by Yiannistaos » Sun Dec 19, 2021 9:48 pm

Try this:

Code: Select all

UPDATE `YOUR_TABLE_NAME` SET checked_out_time = '1970-01-01 00:00:00';
https://www.web357.com/ - Useful Extensions for Joomla!

User avatar
Per Yngve Berg
Joomla! Master
Joomla! Master
Posts: 28816
Joined: Mon Oct 27, 2008 9:27 pm
Location: Romerike, Norway

Re: Joomla 4.0.5: 1048 Column 'checked_out_time' cannot be null

Post by Per Yngve Berg » Mon Dec 20, 2021 4:05 am

Not correct.

Alter the table and change the allow null on the column definition.

This is an upgrade that did not completed.

jooomlaa
Joomla! Apprentice
Joomla! Apprentice
Posts: 5
Joined: Wed Nov 30, 2016 6:31 am

Re: Joomla 4.0.5: 1048 Column 'checked_out_time' cannot be null

Post by jooomlaa » Mon Jan 24, 2022 11:10 am

Yes, I have this error too. Went in with some Joomla 4 update. Since then, almost every save action in the backend has been acknowledged with this error. Some of the data is still saved, but the data record remains checked out (marked with a lock in front of it)

In the past there was a function in Joomla 3 to check and correct the database consistency. In Joomla 4 I can't find this anymore.

User avatar
Per Yngve Berg
Joomla! Master
Joomla! Master
Posts: 28816
Joined: Mon Oct 27, 2008 9:27 pm
Location: Romerike, Norway

Re: Joomla 4.0.5: 1048 Column 'checked_out_time' cannot be null

Post by Per Yngve Berg » Mon Jan 24, 2022 11:36 am

System->Database

jooomlaa
Joomla! Apprentice
Joomla! Apprentice
Posts: 5
Joined: Wed Nov 30, 2016 6:31 am

Re: Joomla 4.0.5: 1048 Column 'checked_out_time' cannot be null

Post by jooomlaa » Mon Jan 24, 2022 12:01 pm

Yes, I was able to find the repair function again. Unfortunately it doesn't fix the error. There are 4 lines to be repaired, but these remain in the list even after the function has been executed.


Post Reply

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