MySQL/MariaDB users can not upgrade to the latest version 4.12
weberhofer opened this issue · 0 comments
weberhofer commented
The database update 20170626074649_add_note_annotations_index.rb tries to execute
CREATE INDEX `index_note_annotations_on_value` ON `note_annotations` (`value`)
on my MySQL database. This fails as as for InnoDB tables there is a maximum key length of 767 bytes. This means, indexed fields consisting of UTF8 columns must not exceed a length of 191 bytes (767/4).
I didn't see any content longer than 24 characters in my existing DB, so I resized the column prior to run the upgrade scripts.