- This topic has 14 replies, 2 voices, and was last updated 2 years, 2 months ago by
.
-
Posts
-
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 1The 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.
@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
Database
Server mysql
Version 8.0.30
Collation utf8mb4_0900_ai_ci
Conn Collation utf8mb4_0900_ai_cijust 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.1I AM running on local development environment….
@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.
https://gokhan.ozar.net/blog/how-to-fix-incorrect-datetime-value-mysql-mariadb/
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.
@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
C:\laragon\www\libraries\vendor\joomla\database\src\Mysqli\MysqliStatement.php:435Call 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@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!
@Crazy5650. Ok. Let’s leave it at that for now. If anything else pops up, just let me know. Best Regards.
- You must be logged in to reply to this topic.