• Fabrik V4.4.1 is now available.

    This version corrects the Admin issue introduced by V4.4. V4.4.1 is available through the Joomla Updater or for download through your My Downloads area of our website.

    Turns out a code change intended for our 5.0dev branch inadvertantly got pushed to the 4.x branch (by me, duh!). The javascript structure in 5.0 will change considerably and part of that change took effect with the inadvertant code change.

    We have reverted the code change and released 4.4.1. V4.4 has been retracted.

    Sorry for any inconvenience.

  • A new version of Full Calendar is now available.

    See the details here

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.
Back
Top