Skip to content

'field_list_items' doesn't have a default value #20

@tyssen

Description

@tyssen

I've been trying to use the recent fork of this and have run into an issue. The fork doesn't have an issues page so posting here in the hope that someone can help.

The error I'm getting is:

SQLSTATE[HY000]: General error: 1364 Field 'field_list_items' doesn't have a default value:
INSERT INTO exp_channel_fields (site_id, field_name, field_type, field_label, field_instructions, field_required, field_search, field_order, field_settings) VALUES …

I encountered something similar recently on a different old EE site where I was unable to create new channel entries. In that case, it was the exp_channel_data table and I was able to fix it by updating the is_nullable column to Yes (column_default was set to NULL) for the affected rows.

I've tried doing the same here but I still get the same result.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions