Jump to content

Recommended Posts

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:
  • Like 1

Share this post


Link to post
Share on other sites

 

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;

Share this post


Link to post
Share on other sites

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...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More