"" is not a valid DATE for DEFAULT

@alikon So what can we consider or add the default date when we have set the default value as null for it in db

1 thing is to allow NULL, another thing is to set a default value which is not in the constraints of the field type

Sorry, not able to understand can you explain it more

I think allowing null is not possible since it is getting validated in core Joomla, right?

The sql for the database table you are creating is wrong.
This is not a bug in the core of joomla so I am closing this.

The forum is a better place for support https://forum.joomla.org

@madanedeepali Just look at the checked_out_time column in your SQL and you can see how it is done.

@richard67 changed the sql query to nextdate DATE NULL DEFAULT NULL,
but still not able to save the date field facing the same error, Can you please help me can I fix this issue where do I need to update the code

@madanedeepali Just look at the checked_out_time column in your SQL and you can see how it is done.

@richard67 changed the sql query to nextdate DATE NULL DEFAULT NULL,
but still not able to save the date field facing the same error, Can you please help me can I fix this issue where do I need to update the code

@madanedeepali In Joomla we only use DATETIME columns, not DATE columns. Please try again with a DATETIME column.

@richard67 changed the sql query to nextdate DATE NULL DEFAULT NULL,
but still not able to save the date field facing the same error, Can you please help me can I fix this issue where do I need to update the code

@madanedeepali In Joomla we only use DATETIME columns, not DATE columns. Please try again with a DATETIME column.

No, still it does not work when used as DATETIME for the checked_out_time column it saves the current date and time

@madanedeepali How does your form save data in database? Does it use a model, and does this use a table class? If so, this table class needs to support NULL values, i.e. the $_supportNullValue class variable has to be set to true. See here the ContactTable class as an example:

https://github.com/joomla/joomla-cms/blob/4.3-dev/administrator/components/com_contact/src/Table/ContactTable.php#L38-L44

class ContactTable extends Table implements VersionableTableInterface, TaggableTableInterface
{
    use TaggableTableTrait;

    /**
     * Indicates that columns fully support the NULL value in the database
     *
     * @var    boolean
     * @since  4.0.0
     */
    protected $_supportNullValue = true;
...

And the storemethod of that table class should have "true" as default value for the "$updateNulls" parameter, see again example from the ContactTable class:

https://github.com/joomla/joomla-cms/blob/4.3-dev/administrator/components/com_contact/src/Table/ContactTable.php#L79

public function store($updateNulls = true)
...

Does this help?

@madanedeepali How does your form save data in database? Does it use a model, and does this use a table class? If so, this table class needs to support NULL values, i.e. the $_supportNullValue class variable has to be set to true. See here the ContactTable class as an example:

https://github.com/joomla/joomla-cms/blob/4.3-dev/administrator/components/com_contact/src/Table/ContactTable.php#L38-L44

class ContactTable extends Table implements VersionableTableInterface, TaggableTableInterface
{
    use TaggableTableTrait;

    /**
     * Indicates that columns fully support the NULL value in the database
     *
     * @var    boolean
     * @since  4.0.0
     */
    protected $_supportNullValue = true;
...

And the storemethod of that table class should have "true" as default value for the "$updateNulls" parameter, see again example from the ContactTable class:

https://github.com/joomla/joomla-cms/blob/4.3-dev/administrator/components/com_contact/src/Table/ContactTable.php#L79

public function store($updateNulls = true)
...

Does this help?

Done the changes in the table as mentioned above still not working

@richard67 Thank you so much for the help...The above code snippet helped when added below code snippet in the table file store function since as you mentioned above In Joomla we only use DATETIME columns, not DATE columns.

public function store($updateNulls = true)

if(!($this->id)) { if (empty($this->nextdate)) { $this->nextdate = NULL; } }

@richard67 I think that this information (problem & answer) should be in the documentation in Potential_backward_compatibility_issues_in_Joomla_4 as it will help a lot of devs with old components.