innoq / iqvoc

iQvoc - A SKOS(-XL) Vocabulary Management System for the Semantic Web
http://iqvoc.net/
Other
117 stars 44 forks source link

MySQL/MariaDB users can not upgrade to the latest version 4.12 #389

Closed weberhofer closed 6 years ago

weberhofer commented 6 years ago

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.