Pull Request for Issue #44727 .

This edit, allows the globalcheckin plugin task to work with 3rd party plugins that use "NOT NULL" in the checkout_out column.

The previous code only half catered for this case and resulted in -2 error code when run.

Note the behaviour of the scheduled globalcheckin task is inconsistent with a global checkin done from the admin control panel which works ok with "nut null".

See #44727

Summary of Changes

This edit, allows the globalcheckin plugin task to work with 3rd party plugins that use "NOT NULL" in the checkout_out column.
The previous code only half catered for this case and resulted in -2 error code when run.
Note the behaviour of the scheduled globalcheckin task is inconsistent with a global checkin done from the admin control panel which works ok with "nut null".

See #44727

Testing Instructions

Have a prefixed table with the checked_out column with NULL not allowed.
Have the globalcheckin task enabled and running on a schedule
Do some backend admin to checkout an item from this table and leave it checked out for long enough for globalcheckin to be triggered on it.

Actual result BEFORE applying this Pull Request

The task returns error code -2, resulting in task failure email if configured to send emails on failure.
The item remains checked out

Expected result AFTER applying this Pull Request

The "item" is checked in by the scheduled task.

Link to documentations

Please select:

• No documentation changes for docs.joomla.org needed
• No documentation changes for manual.joomla.org needed