1. Home
  2. General info
  3. Error while creating the queue table: ALTER TABLE `queue` ADD INDEX `channel` (`channel`)

Error while creating the queue table: ALTER TABLE `queue` ADD INDEX `channel` (`channel`)

If you are getting following error during the install:

SQLSTATE42000: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes The SQL being executed was: ALTER TABLE `queue` ADD INDEX `channel` (`channel`)

Open the fileĀ  /apps/console/migrations/m180206_121141_create_queue_table.php and look for:

'channel'       => $this->string()->notNull(),

and make it

'channel'       => $this->string(150)->notNull(),

Then save the file, remove the /apps/common/config/main-local.php file, drop existing created database tables which the installer managed to create so far, and reload your page in the installer, this time the error should go away.

Updated on July 17, 2018

Was this article helpful?

Related Articles