Erro a instalar

[Tiago Nunes]

Boa tarde,
Eu vou usar o PrestaShop pela primeira vez e ao estar a instalar (depois de configurar tudo) aparece a barra de estar a configurar e chega ao 12% e dá erro ao criar tabelas da base de dados.
Já mudei para inglês e continua a dar erro

Este é o erro:

An error occurred during installation...

You can use the links on the left column to go back to the previous steps, or restart the installation process by clicking here.

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:

[neogest.com.br]

 

Boa tarde,

Eu vou usar o PrestaShop pela primeira vez e ao estar a instalar (depois de configurar tudo) aparece a barra de estar a configurar e chega ao 12% e dá erro ao criar tabelas da base de dados.

Já mudei para inglês e continua a dar erro

Este é o erro:

An error occurred during installation...

You can use the links on the left column to go back to the previous steps, or restart the installation process by clicking here.

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:

 

 

Vá até o suporte da sua hospedagem, e peça a eles para aumentar o limite desse parâmetro: max key length para 3072 bytes.

 

Para fazer isso eles vão precisar usar esse comando na configuração do banco: 

innodb_large_prefix = 1;