Formalicious Error Creating Forms

Support Extras
1

Is anyone else having issues with Formalicious? It does install and lets me start to create a form, however… this is the error I get when installing the package:
Console running…

Attempting to install package with signature: formalicious-3.0.0-pl
Package found…now preparing to install.
Grabbing package workspace…
Workspace environment initiated, now installing package…
Could not load package metadata for package Sterc\Formalicious\Model. Upgrade your model.
Could not create table modx_formalicious_forms SQL: CREATE TABLE modx_formalicious_forms (id INTEGER unsigned NOT NULL AUTO_INCREMENT, category_id INT(10) NOT NULL DEFAULT ‘0’, name VARCHAR(255) NOT NULL DEFAULT ‘’, published TINYINT(1) unsigned NOT NULL DEFAULT ‘0’, published_from TIMESTAMP(1) NOT NULL DEFAULT ‘0000-00-00 00:00:00’, published_till TIMESTAMP(1) 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 published (published), INDEX saveform (saveform), INDEX email (email), INDEX fiaremail (fiaremail)) ENGINE=InnoDB ERROR: Array ( [0] => 42000 [1] => 1067 [2] => Invalid default value for ‘published_from’ )

and then this is the error once I try and Save a new form:
formalicious.form_err_save

any help would be appreciated! Thanks everyone!

2

Like the error messages says: 0000-00-00 00:00:00 is not a valid default value for the columns “published_from” and “published_till”.

If you have access to the MySQL config file, you could try to remove NO_ZERO_DATE and/or NO_ZERO_IN_DATE from the sql-mode.

Otherwise run the SQL query manually (for example in phpMyAdmin) and change the default value to a valid date.

CREATE TABLE modx_formalicious_forms (
	id INTEGER unsigned NOT NULL AUTO_INCREMENT, 
	category_id INT(10) NOT NULL DEFAULT '0', 
	name VARCHAR(255) NOT NULL DEFAULT '', 
	published TINYINT(1) unsigned NOT NULL DEFAULT '0', 
	published_from TIMESTAMP(1) NOT NULL DEFAULT '1970-01-01 02:00:00', 
	published_till TIMESTAMP(1) NOT NULL DEFAULT '1970-01-01 02: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 published (published), 
	INDEX saveform (saveform), 
	INDEX email (email), 
	INDEX fiaremail (fiaremail)
) ENGINE=InnoDB

(Maybe you have to add a few hours depending on your timezone.)

3

Looking at the code, it’s maybe a better idea to just allow null values in the database columns:

...
published_from TIMESTAMP(1), 
published_till TIMESTAMP(1), 
...

And in your forms you probably have to always explicitly set the 2 dates to avoid errors. (If you don’t want to change the code.)

4

Thank you much! Removing it worked like a charm. Now the problem is I cannot get it to show on the page. TV is selected, no errors, it just will not come up. Have you had any success?