Attempt to update field json medium failed: Exception thrown while performing a schema update. SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOT NULL, PRIMARY KEY (`entity_id`, `deleted`, `delta`, `langcode`), INDEX `bu' at line 8: CREATE TABLE {node__field_json_medium} ( `bundle` VARCHAR(128) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance', `deleted` TINYINT NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted', `entity_id` INT unsigned NOT NULL COMMENT 'The entity id this data is attached to', `revision_id` INT unsigned NOT NULL COMMENT 'The entity revision id this data is attached to', `langcode` VARCHAR(32) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '' COMMENT 'The language code for this data item.', `delta` INT unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields', `field_json_medium_value` NOT NULL, PRIMARY KEY (`entity_id`, `deleted`, `delta`, `langcode`), INDEX `bundle` (`bundle`), INDEX `revision_id` (`revision_id`) ) ENGINE = InnoDB DEFAULT CHARACTER SET utf8mb4 COMMENT 'Data storage for node field field_json_medium.'; Array ( ) .
Comment | File | Size | Author |
---|---|---|---|
#5 | field_setting_max_size-2656580-5.patch | 2.54 KB | brianfisher |
#3 | field_setting_max_size-2656580-3.patch | 1.35 KB | brianfisher |
Comments
Comment #2
brianfisher CreditAttribution: brianfisher commented-
Comment #3
brianfisher CreditAttribution: brianfisher commentedactually, changing the default max size to any value other than 255 causes this error
patch:
- fixes exception, allowing setting of max size
- sets max size const's of text column types to actual size (not size-1)
- sets max size label of varchar columns to characters, not Bytes
Comment #4
brianfisher CreditAttribution: brianfisher commentedComment #5
brianfisher CreditAttribution: brianfisher at Chapter Three commentedfix tests
Comment #6
dawehnerI kinda prefered 2^16, 2^24 and 2^32 but nevermind, I don't care much.