1364 Field 'form_id' doesn't have a default value

[be_smarten]

Hi Community,

i am using Fabrik with Joomla version, 3.9.2. with Fabrik 3.9.

When I try to add a new list I get the following error when selecting the content type:
"This content type was exported from Fabrik 3.8, where as your site is using 3.9. Whilst it will probably install without issue, it would be best to update the content type"

When I still hit save, the following error apprears and I cannot save:
1364 Field 'form_id' doesn't have a default value

I think the content type is messed up.

The default.xml looks like this:

<contenttype ignoreacl="true">
<name>Default</name>
<fabrikversion>3.8</fabrikversion>
<group join_id="" is_join="0" id="118" name="{label}" label="{label}" css="" published="1" created="2016-01-10 08:53:39" private="0">
<params repeat_group_button="0" repeat_group_show_first="1"/>
<element label="id" published="1" name="id" id="662" plugin="internalid" created="2016-01-10 08:53:39" width="3" height="0" default="" hidden="1" eval="0" ordering="2" show_in_list_summary="1" filter_type=""filter_exact_match="" link_to_detail="1" primary_key="1" auto_increment="1" access="1" use_in_page_title="0" parent_id="0">
<params edit_access="1" view_access="1" list_view_access="1" filter_access="1" sum_access="1" avg_access="1" median_access="1" count_access="1" custom_calc_access="1"/>
</element>
<element label="date_time" published="1" name="date_time" id="664" plugin="date" created="2016-01-10 08:53:39" width="0" height="0" default="" hidden="1" eval="0" ordering="0" show_in_list_summary="1"filter_type="" filter_exact_match="1" link_to_detail="1" primary_key="0" auto_increment="0" access="1" use_in_page_title="0" parent_id="0">
<params bootstrap_class="input-medium" date_showtime="0" date_time_format="H:i" bootstrap_time_class="input-medium" placeholder="" date_store_as_local="0" date_table_format="Y-m-d H:i:s" date_form_format="Y-m-d H:i:s" date_defaulttotoday="1" date_alwaystoday="0" date_firstday="0" date_allow_typing_in_field="1" date_csv_offset_tz="0" date_advanced="0" date_allow_func="" date_allow_php_func="" date_observe=""show_in_rss_feed="0" show_label_in_rss_feed="0" use_as_rss_enclosure="0" rollover="" tipseval="0" tiplocation="top-left" labelindetails="0" labelinlist="0" comment="" edit_access="1" edit_access_user=""view_access="1" view_access_user="" list_view_access="1" encrypt="0" can_order="0" alt_list_heading="" custom_link="" custom_link_target="" custom_link_indetails="1" use_as_row_class="0"include_in_list_query="1" always_render="0" icon_folder="0" icon_hovertext="1" icon_file="" icon_subdir="" filter_length="20" filter_access="1" full_words_only="0" filter_required="0" filter_build_method="0"filter_groupby="text" inc_in_adv_search="1" filter_class="input-medium" filter_responsive_class="" tablecss_header_class="" tablecss_header="" tablecss_cell_class="" tablecss_cell="" sum_on="0" sum_label="Sum"sum_access="1" sum_split="" avg_on="0" avg_label="Average" avg_access="1" avg_round="0" avg_split="" median_on="0" median_label="Median" median_access="1" median_split="" count_on="0" count_label="Count"count_condition="" count_access="1" count_split="" custom_calc_on="0" custom_calc_label="Custom" custom_calc_query="" custom_calc_access="1" custom_calc_split="" custom_calc_php="" validations="[]"/>
</element>
</group>
<viewlevels>
<viewlevel id="1" title="Public" ordering="0" rules="[1]"/>
<viewlevel id="2" title="Registered" ordering="1" rules="[6,2,8]"/>
<viewlevel id="3" title="Special" ordering="2" rules="[6,3,8]"/>
<viewlevel id="5" title="Guest" ordering="0" rules="[9]"/>
</viewlevels>
</contenttype>


Do you have any idea how I can fix the issue?

Thank you very much.

kind regards,
Marten Lucas

 

[troester]

default.xml looks like it should.
I don't think it's related to the content type (it didn't change at all, only showing the old version no)
You may try one of the other content types.

It seems to be a problem with your MySQL DB.
https://stackoverflow.com/questions/15438840/mysql-error-1364-field-doesnt-have-a-default-values

 

[cheesegrits]

Removing STRICT_TRANS_TABLES should solve it, and will also avoid some other common issues with J! and Fabrik in general.

Are you running on a Windows server? Typically MySQL on Linux installs without that settings, but for a while it was set on some Windows installers.

-- hugh