Hi friends,
I'm working with latest J4 and Seblod 4 on a complex content type, like many others that I have already created, but I have found a problem that I am surprised that no one is having, or at least I have not been able to find it either on github or here.
Very simple to reproduce:
Go to Fields, new field, put title, name, and type JForm - Calendar. At this point it depends if you want a date or a datetime.
In my case is Show Time -> Hide because I just need a date field. Storage format raw according to this issue in order to prevent to lose one day every time we edit the form.
And then the storage, I use Standard -> Free -> mydb_column -> mycolumn_name -> Alter table -> Add Column -> DATE (or DATETIME if you need time also)
And after saving it throw the error:
Save failed with the following error: Invalid default value for 'mycolumn_name'
If I create the mysql column by hand, that also causes an error when filling out the form and leaving the date field empty. The form cannot be saved due to the same error.
Any help or fix will be appreciated
Best regards.
Adonay