1. Fabrik 3.9 has been released. If you have updated Joomla to 3.9, this is a required update.
    Dismiss Notice

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

Discussion in 'Community' started by be_smarten, Feb 13, 2019.

  1. be_smarten

    be_smarten New Member

    Level: Community
    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
     
  2. troester

    troester Well-Known Member Staff Member

    Level: Community
  3. cheesegrits

    cheesegrits Support Gopher Staff Member

    Level: Community
    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
     

Share This Page