search

tsurupin / portfolio

A blog and Portfolio CMS built with Rails, React, Redux, Material-UI, CSS Modules.
http://staging.tsurupin.com
MIT License
721 stars 148 forks source link

database migration error #71

Closed Sen-Zhang closed 8 years ago

Sen-Zhang commented 8 years ago

Got an error when running db:migrate

ActiveRecord::StatementInvalid: Mysql2::Error: Specified key was too long;
 max key length is 767 bytes: CREATE  INDEX `index_items_on_target_type_and_target_id` 
USING btree ON `items` (`target_type`, `target_id`)

MySQL Version

5.6.20-debug

tsurupin commented 8 years ago

@Sen-Zhang Thanks! I'll look into the error soon.

tsurupin commented 8 years ago

@Sen-Zhang Thank you for checking. The reason I chose utf8mb4 is because utf8 cannot handle some emojis.

Sen-Zhang commented 8 years ago

@tsurupin I see