UPDATE #__menus SET checked_out=0 WHERE client_id=0
You should be able to check-in menu items.
There are no tables with checked out items or there are no tables with checked out items that match your search.
You can restore your DB by: UPDATE #__menus SET checked_out=DEFAULT WHERE client_id=0
Joomla 4.0.0-beta4
If any of the tables, say #__menu
, contains items saved with older Joomla 3.9 component, they may have items with check_out
being 0. Unfortunately, a few Joomla models only check against user_id and NULL, meaning that the items may/will be semi-locked forever with no way to update them.
administrator/components/com_checkin/src/Model/CheckinModel.php
should be changed to check against something else than >=0. In fact, I don't think that WHERE clause is needed at all.
Labels |
Added:
?
|
Title |
|
We can check if checked_out column is nullable like we do with the date.
We can check if checked_out column is nullable like we do with the date.
Sounds good. Do you wanna make a PR?
Status | New | ⇒ | Closed |
Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2020-09-23 13:41:07 |
Closed_By | ⇒ | SharkyKZ |
@SharkyKZ Could you have a look on this issue?