Incorrect datetime value: ” for column ‘c

Home \ forums/topic \ Incorrect datetime value: ” for column ‘c

Support Home Page Forums Joomla Software Easy Folder Listing Pro Plugin Incorrect datetime value: ” for column ‘c

Viewing 15 posts - 1 through 15 (of 15 total)
  • Author
  • #3319

    Hello. Just purchase and have installed on Joomla4 latest version. I get the following error if I set ANY attrcibute in the shortcode:

    Save failed with the following error: Incorrect datetime value: ” for column ‘checked_out_time’ at row 1

    But the article actually does save. Then when I view the article on the frontend, this error:
    1292 – Incorrect datetime value: ” for column ‘checked_out_time’ at row 1

    The only time I can get the plugin to work is I just use base shortcode without any attribute overrides.


    Update. If I setup all the attributes in a profile, then refer that profile only in the shortcode it works.

    But anytime I override attributes in the shortcode I get this error.

    Michael Gilkes

    @Crazy5650. Thanks for posting.

    OK. I am not getting that error on my test servers. So, something is going on with your setup. Can you please let me know your PHP version, MySql or Postgresql version, and the version of Easy Folder Listing Pro you have installed? Can you confirm that your Joomla version is 4.2.4?


    Joomla! Version 4.2.3
    PHP Version 8.0.25
    Server mysql
    Version 8.0.30
    Collation utf8mb4_0900_ai_ci
    Conn Collation utf8mb4_0900_ai_ci


    just purchased so think I have latest version of extension.

    Extensions Details
    Extension Name Enabled Type of Extension Version
    Easy Folder Listing Pro Component Yes component 4.1.1
    Easy Folder Listing Pro Companion Content Plugin Yes content plugin 2.0
    Easy Folder Listing Pro Companion Code Helper Plugin Yes editors-xtd plugin 2.0
    Easy Folder Listing Pro Companion Module Yes module 2.1

    I AM running on local development environment….

    Michael Gilkes

    @Crazy5650. Thanks for posting the version information. Everything seems fine. The only main difference between your setup and mine is that your mysql server is version 8.0.30, while my test servers use 5.7.34. Since your setup is on local development, can you check the the database tables, __eflp_profiles and __eflp_icons for what the default value for the ‘checked_out_time’ column is. It should be NULL. Whatever it is, please let me know.

    If I could reproduce your issue on my test servers, that would be useful.


    Yes the default value for both is NULL


    both tables have values of NULL and the 0000-00-00 00:00:00 in the field.


    If I change the fields with values of 0000-00-00 00:00:00 to null in phpMyAdmin, the error goes away.

    If I edit the field entries of 0000-00-00 00:00:00 to 2022-11-07 00:00:00 in phpMyAdmin, for example, the error goes away.

    Michael Gilkes

    @Crazy5650. Yes. I am glad the default is NULL. It is supposed to be NULL by default. The error you experienced occurs because of the invalid value “0000-00-00 00:00:00” being inputted into the field. I dealt with this issue since version 3.6, when MySQL deprecated the use of that value. I am not too sure how those values got into your table. There shouldn’t be anything in the code that does that.

    Did you recently upgraded your MySQL from an older version to a newer one? Or maybe updated the extension from an older version?


    I may have updated from the free version? Let me do a complete uninstall including deleting the tables and reinstall see what happens.


    Now I am getting this. All ‘Checked_oujt_times” are null in the two tables profiles and icons.

    Incorrect datetime value: ” for column ‘checked_out_time’ at row 1

    Call stack
    # Function Location
    1 () JROOT\libraries\vendor\joomla\database\src\Mysqli\MysqliStatement.php:435
    2 Joomla\Database\Mysqli\MysqliStatement->execute() JROOT\libraries\vendor\joomla\database\src\DatabaseDriver.php:675
    3 Joomla\Database\DatabaseDriver->execute() JROOT\plugins\content\easyfolderlistingpro\easyfolderlistingpro.php:455
    4 plgContentEasyFolderListingPro->createProfile() JROOT\plugins\content\easyfolderlistingpro\easyfolderlistingpro.php:408
    5 plgContentEasyFolderListingPro->confirmProfile() JROOT\plugins\content\easyfolderlistingpro\easyfolderlistingpro.php:346
    6 plgContentEasyFolderListingPro->normalizeAttributes() JROOT\plugins\content\easyfolderlistingpro\easyfolderlistingpro.php:200
    7 plgContentEasyFolderListingPro->handleInstances() JROOT\plugins\content\easyfolderlistingpro\easyfolderlistingpro.php:129
    8 plgContentEasyFolderListingPro->onContentPrepare() JROOT\libraries\src\Plugin\CMSPlugin.php:279
    9 Joomla\CMS\Plugin\CMSPlugin->Joomla\CMS\Plugin\{closure}() JROOT\libraries\vendor\joomla\event\src\Dispatcher.php:486
    10 Joomla\Event\Dispatcher->dispatch() JROOT\libraries\src\MVC\View\AbstractView.php:249
    11 Joomla\CMS\MVC\View\AbstractView->dispatchEvent() JROOT\components\com_content\src\View\Article\HtmlView.php:227
    12 Joomla\Component\Content\Site\View\Article\HtmlView->display() JROOT\libraries\src\MVC\Controller\BaseController.php:639
    13 Joomla\CMS\MVC\Controller\BaseController->display() JROOT\components\com_content\src\Controller\DisplayController.php:121
    14 Joomla\Component\Content\Site\Controller\DisplayController->display() JROOT\libraries\src\MVC\Controller\BaseController.php:672
    15 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT\libraries\src\Dispatcher\ComponentDispatcher.php:143
    16 Joomla\CMS\Dispatcher\ComponentDispatcher->dispatch() JROOT\components\com_content\src\Dispatcher\Dispatcher.php:56
    17 Joomla\Component\Content\Site\Dispatcher\Dispatcher->dispatch() JROOT\libraries\src\Component\ComponentHelper.php:355
    18 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT\libraries\src\Application\SiteApplication.php:200
    19 Joomla\CMS\Application\SiteApplication->dispatch() JROOT\libraries\src\Application\SiteApplication.php:241
    20 Joomla\CMS\Application\SiteApplication->doExecute() JROOT\libraries\src\Application\CMSApplication.php:294
    21 Joomla\CMS\Application\CMSApplication->execute() JROOT\includes\app.php:61
    22 require_once() JROOT\index.php:32

    Michael Gilkes

    @Crazy5650. Thanks for posting your error stack. I am not able to reproduce this error on my test systems. I have a fresh Joomla 4.2.5 installed, and installed the latest release of the extension. Then I added the shortcode {easyfolderlistingpro profile=”1″ folder=”images” method=”table”} then clicked Save, and I get no error. The article saved without any issue.

    Can you explain what you are doing (such as the exact shortcode you use), so we can synchronize our actions, and see if I can reproduce this? Could you also update your Joomla version to the latest 4.2.5 instead of 4.2.3, so we can have equal footing for a comparison? Thanks.

    So, as far as I can tell, there is nothing in the code that should trigger such an error. The error says that an empty string (”) is an incorrect value for datetime checked_out_time column. However, I don’t actually try to change or update the checked_out_time field in my code. This is done automatically in the Joomla code.

    The thing is that when you save the article it renders the code, which executes the profile update to the database, based on the attributes in the shortcode. This is why you get a possible error when you save. So, any errors or notices will pop up when saving the article and not only when displaying in the front end.


    After the fresh install, it apparently doesn’t like the null value in that field. So going into the default profile and just saving it to create a proper date in the checked out field seems to solve the problem. Chalk it up to me using mysql 8. Googling a little a few things came up about uncertainty of joomla compatibility with Mysql 8… So I think I am good. Thanks for your help!

    Michael Gilkes

    @Crazy5650. Ok. Let’s leave it at that for now. If anything else pops up, just let me know. Best Regards.

Viewing 15 posts - 1 through 15 (of 15 total)
  • You must be logged in to reply to this topic.