Can't create elements: "Field 'default' doesn't have a default value" error

Status
Not open for further replies.

Parcs

New Member
Hi, I'm working on a staging site, updating from Joomla3.
Joomla 4.2.9, Fabrik 4.0gamma2, template Cassiopeia.

When I add a new list, the table is correctly created in Joomla database, but when I try to add some elements, most of the times I get the error "Field 'default' doesn't have a default value".

The element is created anyway in database, but it's not shown neither on frontpage form nor in Fabrik backend.
This happens with most of the elements, like button, captcha, checkbox, fileupload, radiobutton, and more.

Other elements like field, cascading dropdown, display, dropdown, textarea, are created with no problems.

So the only workaround I found so far is to create a field element and, once that it's saved, change it to the element I need that I wasn't able to create in first place. If I create a field and then change it to radiobutton then I have no errors, and the radio is shown on frontend and backend.

The internalid element is set as Primary key, and in 'Extra' column of id is shown AUTO_INCREMENT.

Do you have any idea what could be the issue?
Thank you very much
 
What is your database version?
What is the column definition of #_fabrik_elements.default?
 
Hi troester,
database version is MySQL 5.7
in the default column of _fabrik_elements I see:
Type:text
Null: NO
Default: NULL

Thank you
 
It should be ok if you set it to null=yes.
It seems the column definition is changed on a new F4 install but not while updating.
 
I set Null=yes as you suggested and now everything works correctly.
Thank you very much Troester!
 
Status
Not open for further replies.
We are in need of some funding.
More details.

Thank you.

Members online

Back
Top