Octopoos / SEBLOD

Build high-end websites with SEBLOD®, a CCK for Joomla!
https://www.seblod.com
GNU General Public License v2.0
129 stars 55 forks source link

Set default value to NULL and authorize column to be NULL for DATE & DATETIME column types #773

Open olivier-nolbert opened 1 year ago

olivier-nolbert commented 1 year ago

This code fixes the error on saving fields on J4.x/S4.1.1 with storage column type set as DATE or DATETIME. It sets default value to NULL instead of 0 and conditionally removes the 'NOT NULL' option in the SQL Query.

olivier-nolbert commented 1 year ago

Error mentioned on SEBLOD forum here : https://www.seblod.com/community/forums/fields-plug-ins/jform-calendar-field-has-more-than-one-problem