Reply To: Incorrect datetime value: ” for column ‘c

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

#3331
Michael Gilkes
Keymaster

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