Symphony Fatal Database Error: Specified key was too long; max key length is 1000 bytes

[wdebusschere]

Symphony 2.7.7
multilingual_field: 3.5.18
Textbox: 2.7.3 (not latest because of issue symphonists/textboxfield#10)

An error occurred while attempting to execute the following query

CREATE TABLE IF NOT EXISTS `sym_entries_data_578` ( `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, `entry_id` INT(11) UNSIGNED NOT NULL, `handle` VARCHAR(1024) DEFAULT NULL, `value` TEXT DEFAULT NULL, `value_formatted` TEXT DEFAULT NULL, `word_count` INT(11) UNSIGNED DEFAULT NULL,`handle-en` VARCHAR(1024) DEFAULT NULL,`value-en` TEXT DEFAULT NULL,`value_formatted-en` TEXT DEFAULT NULL,`word_count-en` INT(11) UNSIGNED DEFAULT NULL,`handle-pt` VARCHAR(1024) DEFAULT NULL,`value-pt` TEXT DEFAULT NULL,`value_formatted-pt` TEXT DEFAULT NULL,`word_count-pt` INT(11) UNSIGNED DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `entry_id` (`entry_id`),KEY `handle-en` (`handle-en`),FULLTEXT KEY `value-en` (`value-en`),FULLTEXT KEY `value_formatted-en` (`value_formatted-en`),KEY `handle-pt` (`handle-pt`),FULLTEXT KEY `value-pt` (`value-pt`),FULLTEXT KEY `value_formatted-pt` (`value_formatted-pt`), KEY `handle` (`handle`), FULLTEXT KEY `value` (`value`), FULLTEXT KEY `value_formatted` (`value_formatted`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

[nitriques]

This is when creating a new field ?

[nitriques]

I am not able to reproduce with textbox field 2.8.2

[wdebusschere]

Fixed with textbox field 2.8.2

[wdebusschere]

Got it again when adding a new multilanguage field to a section
PhP 7.1
Mysql Server version: 5.7.23
symphony 2.7.7
textbox field 2.8.2
multilingual_field: 3.5.19

Symphony Fatal Database Error: Specified key was too long; max key length is 1000 bytes
An error occurred while attempting to execute the following query

CREATE TABLE IF NOT EXISTS sym_entries_data_621 ( id INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, entry_id INT(11) UNSIGNED NOT NULL, handle VARCHAR(1024) DEFAULT NULL, value TEXT DEFAULT NULL, value_formatted TEXT DEFAULT NULL, word_count INT(11) UNSIGNED DEFAULT NULL,handle-en VARCHAR(1024) DEFAULT NULL,value-en TEXT DEFAULT NULL,value_formatted-en TEXT DEFAULT NULL,word_count-en INT(11) UNSIGNED DEFAULT NULL,handle-pt VARCHAR(1024) DEFAULT NULL,value-pt TEXT DEFAULT NULL,value_formatted-pt TEXT DEFAULT NULL,word_count-pt INT(11) UNSIGNED DEFAULT NULL, PRIMARY KEY (id), UNIQUE KEY entry_id (entry_id),KEY handle-en (handle-en),FULLTEXT KEY value-en (value-en),FULLTEXT KEY value_formatted-en (value_formatted-en),KEY handle-pt (handle-pt),FULLTEXT KEY value-pt (value-pt),FULLTEXT KEY value_formatted-pt (value_formatted-pt), KEY handle (handle), FULLTEXT KEY value (value), FULLTEXT KEY value_formatted (value_formatted) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

[wdebusschere]

Update: this must be MySQL related.. works on another setup.. must be my default Mamp database configuration that is too strict..

[wdebusschere]

Update: setting SQL mode to nothing resolved it: sql_mode = ''
Must be less strict now.. so no error.