2.3.14: Error when loading sample data

[Heklaterriol]

An error has occurred. Column 'checked_out_time' cannot be null

I guess a leftover from jemproject/JEM-Project#1408 (wrong time format in sample events SQL import file)

# | Function | Location
1 | () | JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:433
2 | mysqli_stmt->execute() | JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:433
3 | Joomla\Database\Mysqli\MysqliStatement->execute() | JROOT/libraries/vendor/joomla/database/src/DatabaseDriver.php:675
4 | Joomla\Database\DatabaseDriver->execute() | JROOT/administrator/components/com_jem/models/sampledata.php:81
5 | JemModelSampledata->loadData() | JROOT/administrator/components/com_jem/controllers/sampledata.php:35
6 | JemControllerSampledata->load() | JROOT/libraries/src/MVC/Controller/BaseController.php:672
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/administrator/components/com_jem/jem.php:55
8 | require_once() | JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:71
9 | Joomla\CMS\Dispatcher\LegacyComponentDispatcher::Joomla\CMS\Dispatcher\{closure}() | JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:73
10 | Joomla\CMS\Dispatcher\LegacyComponentDispatcher->dispatch() | JROOT/libraries/src/Component/ComponentHelper.php:355
11 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/AdministratorApplication.php:143
12 | Joomla\CMS\Application\AdministratorApplication->dispatch() | JROOT/libraries/src/Application/AdministratorApplication.php:186
13 | Joomla\CMS\Application\AdministratorApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:294
14 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/administrator/includes/app.php:61
15 | require_once() | JROOT/administrator/index.php:32

[Heklaterriol]

Error is gone. Maybe a cache problem right after the update(?)

[mckillo]

When you have installed the new version, the table has defined datatime type as null and default null, this is the reason that the error is gone (before your datetime was not null). All datetime must be null (See https://issues.joomla.org/tracker/joomla-cms/29429, not more 0000-00-00 ...).

[mckillo]

Can be closed.

[Heklaterriol]

Why does it occur and what is the solution then?

[mckillo]

It have occured because you have intalled new version on old beta version, in this case (now), the tables aren't update and the field of datetime have not null and the new code these fields can be null ... .and can be error if the field is null. With a new install 2.3.14, do you have this error? In my test, no.