Jump to content

Installation error: table creation fails


Recommended Posts

Installation fails with the following error:

  1. 1: Updating database schema...
  2. 2:
  3. 3:
  4. 4: [Doctrine\DBAL\Exception\DriverException]
  5. 5: An exception occurred while executing 'CREATE TABLE ps_translation (id_translation INT AUTO_INCREMENT NOT NULL, id_lang INT NOT NULL, `key` VARCHAR(255) NOT NULL, translation LONGTEXT NOT NULL, domain VARCHAR(255) NOT NULL, theme VARCHAR(255) DEFAULT NULL, INDEX IDX_ADEBEB36BA299860 (id_lang), INDEX `key` (domain), UNIQUE INDEX theme (`key`, theme, id_lang, domain), PRIMARY KEY(id_translation)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB':
  6. 6: SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes
  7. 7:
  8. 8:
  9. 9:
  10. 10: [Doctrine\DBAL\Driver\PDOException]
  11. 11: SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes
  12. 12:
  13. 13:
  14. 14:
  15. 15: [PDOException]
  16. 16: SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes
  17. 17:
  18. 18:
  19. 19: doctrine:schema:update [--complete] [--dump-sql] [-f|--force] [--em [EM]] [-h|--help] [-q|--quiet] [-v|vv|vvv|--verbose] [-V|--version] [--ansi] [--no-ansi] [-n|--no-interaction] [-s|--shell] [--process-isolation] [-e|--env ENV] [--no-debug] [--]
  20. 20:
  21. 21:

Any suggestions are highly appreciated

Link to comment
Share on other sites

  • 2 weeks later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...