Error saving form in 2.0.3

Open Source Formalicious
#1

Hi, when i save a form i get an err.save popup.

The publisheduntil seems to be mandatory for some reason. If i put in a date there i still get an err.save
the log tells me:

[2019-09-27 15:52:24] (ERROR @ /home/user/domains/domainname.nl/public_html/modx/core/xpdo/om/xpdoobject.class.php : 1452) Error 22007 executing statement:

UPDATE modx_formalicious_forms SET redirectto = 1,published_from = ‘2019-09-26 00:00:00’,published_till = ‘2040-09-27 00:00:00’,email = 1,emailsubject = ‘Formulier aanmelden patient’ WHERE id = 1
Array
(
[0] => 22007
[1] => 1292
[2] => Incorrect datetime value: ‘2040-09-27 00:00:00’ for column modx_dbname.modx_formalicious_forms.published_till at row 1
)

I also do not get to see the form fields? Is this because the error?

Hope to get a solution soon, thanx

#2

The “seeing” the form had to do with the upgrade of 1.4.4 to 2.0.3 and the use of a different snippet.
The upgrade probably also has to do with the SQL errors?

#3

Since 2.0.3 i also cannot save options:
ie values on a radio button will not save

#4

Maybe its the same like this: Formalicious.field_value_err_save

#5

For a new install, I am seeing the following error during installation:

Workspace environment initiated, now installing package…
Could not create table modx_formalicious_forms SQL: CREATE TABLE modx_formalicious_forms (id INT(11) NOT NULL AUTO_INCREMENT, category_id INT(10) NOT NULL DEFAULT ‘0’, name VARCHAR(255) NOT NULL DEFAULT ‘’, published TINYINT(1) NOT NULL DEFAULT ‘0’, published_from TIMESTAMP NOT NULL DEFAULT ‘0000-00-00 00:00:00’, published_till TIMESTAMP NOT NULL DEFAULT ‘0000-00-00 00:00:00’, saveform TINYINT(1) unsigned NOT NULL DEFAULT ‘0’, redirectto INT(10) unsigned NOT NULL DEFAULT ‘0’, email TINYINT(1) unsigned NOT NULL DEFAULT ‘0’, emailto TEXT NOT NULL, emailsubject VARCHAR(255) NOT NULL DEFAULT ‘’, emailcontent TEXT NOT NULL, fiaremail TINYINT(1) unsigned NOT NULL DEFAULT ‘0’, fiaremailto INT(11) unsigned NOT NULL DEFAULT ‘0’, fiaremailfrom TEXT NOT NULL, fiaremailsubject VARCHAR(255) NOT NULL DEFAULT ‘’, fiaremailcontent TEXT NOT NULL, fiaremailattachment TEXT NOT NULL, prehooks VARCHAR(255) NOT NULL DEFAULT ‘’, posthooks VARCHAR(255) NOT NULL DEFAULT ‘’, parameters TEXT NOT NULL, PRIMARY KEY (id), INDEX category_id (category_id), INDEX saveform (saveform), INDEX email (email), INDEX fiaremail (fiaremail)) ENGINE=MyISAM ERROR: Array ( [0] => 42000 [1] => 1067 [2] => Invalid default value for ‘published_from’ )
Successfully installed package formalicious-2.0.4-pl