Search code examples
mysqlsqlmybb

SQL Error: 1364 - Field 'description' doesn't have a default value

I am getting this error when attempting to insert into mybb's mybb_settinggroups SQL table:

SQL Error: 1364 - Field 'description' doesn't have a default value Query: INSERT INTO mybb_settinggroups (name,title,disporder,isdefault) VALUES ('lock','Lock Settings',1,0)

How can I resolve this?

Solution

  • The field description would seem to be declared NOT NULL with no default value. So, you need to include it in the INSERT:

    INSERT INTO mybb_settinggroups (name, title, disporder, isdefault, description)
    VALUES ('lock', 'Lock Settings', 1, 0, 'no description available');

    You may have a more reasonable description in mind.