[Crazy5650]

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]

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:435

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

[Crazy5650]

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

[Crazy5650]

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]

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.

[Crazy5650]

Yes the default value for both is NULL

[Crazy5650]

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….

[Crazy5650]

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_ci

[Crazy5650]

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.

[Author]

Posts