-
Notifications
You must be signed in to change notification settings - Fork 627
Closed
Labels
Milestone
Description
I try to use --log-in-db option in migration, but when run the migration, I got the error:
ERROR: SQLSTATE[HY000]: General error: 1709 Index column size too large. The maximum column size is 767 bytes.
I think it is because I use utf8mb4
for my database. Maybe reduce the version
column size? Now it is 255. And it will exceed max limit for indexing.
new Index('idx_' . self::MIGRATION_LOG_TABLE . '_version', ['version']) |
Here is a related question on SO: How to fix MySql: index column size too large (Laravel migrate)
Environment:
OS: Linux de4c926a06e4 4.9.60-linuxkit-aufs #1 SMP Mon Nov 6 16:00:12 UTC 2017 x86_64
PHP Version: 7.1.9
PHP SAPI: cli
PHP Bin: /usr/bin/php7
PHP Extension Dir: /usr/lib/php7/modules
PHP Bin Dir: /usr/bin
Loaded PHP config: /etc/php7/php.ini
Versions:
Phalcon DevTools Version: 3.2.8
Phalcon Version: 3.3.1
AdminLTE Version: 2.3.6