Error: The field could not be added.

  • Resolved robertiulian

    (@robertiulian)


    4 years, 11 months ago

    Hi again.

    So, I had to add a few extra fields to certain groups. For some reason, after I add the new field I see

    “The field could not be added.”

    The strange thing is that the field actually is added to the right group and everything seems to be working fine. So I carried on and added all the extra fields I needed.

    Now when I try to add values in the newly created fields or to edit old fields I get an error: Database Error: Unknown column ‘associate_1_notes’ in ‘field list’

    ‘associate_1_notes’ – is the first new extra field that I added, on which I had the error:

    “The field could not be added.”

    , but was added anyway.

    So, now I assume that I have to remove all the extra fields that I added with the error: “The field could not be added.” and re-add them but without getting the error.

    I upgraded MySQL to 5.7 but that did nothing for me.

    I am completely clueless on what to do next. Should I try to export and re-import values? Why the error in the first place?

    I have increased post_size to 400MB, I read somewhere on the forum that too many fields could break it. And that we should break it down in groups. I did this as well, maybe too many groups now.

Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter robertiulian

    (@robertiulian)

    Ok, to anyone that may run in a similar issue. there is a fix.

    First, increase your ;php_admin_value[max_input_vars] = 40000 if you get max_input_vars error in phpmyadmin when you try to add the field manually.

    Then you may get `Row size too large (> 8126). Changing some columns to
    TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored
    inline.` Add the following into your my.cnf, most probably you have to get in touch with your hosting provider to do the change for you.
    ‘innodb_strict_mode = 0’
    ‘innodb_log_file_size = 2G’
    ‘innodb_buffer_pool_size=512M’
    ‘key_buffer_size=100M’
    ‘max_allowed_packet = 1G’
    ‘innodb_log_buffer_size = 256M’

    This should fix it.

    Plugin Author xnau webdesign

    (@xnau)

    This can happen if you have too many fields in a field group. Another way to avoid this is to break your fields up into more, smaller groups of fields.

    oh! is there a recommended max number of fields per field group (i.e. db table row columns)

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Error: The field could not be added.’ is closed to new replies.