Errori durante aggiornamento

[Tonj83]

Buonasera,

al termine dell'aggiornamento dalla versione prestashop 1.7.6.8  alla 1.7.7.0 sono stati restituiti i seguenti errori:

Could not extract install/upgrade/classes/ from backup, the destination might not be writable.

SQL 1.7.7.0 1709 in ALTER TABLE `ps_configuration` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci: Index column size too large. The maximum column size is 767 bytes.SQL 1.7.7.0 1709 in ALTER TABLE `ps_connections_source` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci: Index column size too large. The maximum column size is 767 bytes.SQL 1.7.7.0 1709 in ALTER TABLE `ps_customer` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci: Index column size too large. The maximum column size is 767 bytes.SQL 1.7.7.0 1709 in ALTER TABLE `ps_employee` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci: Index column size too large. The maximum column size is 767 bytes.SQL 1.7.7.0 1709 in ALTER TABLE `ps_order_state` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci: Index column size too large. The maximum column size is 767 bytes.SQL 1.7.7.0 1709 in ALTER TABLE `ps_page_type` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci: Index column size too large. The maximum column size is 767 bytes.SQL 1.7.7.0 1709 in ALTER TABLE `ps_smarty_cache` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci: Index column size too large. The maximum column size is 767 bytes.

Posso ritenere che l'aggiornamento sia andato a buon fine? 

Grazie.

Edited December 5, 2020 by Tonj83 (see edit history)

[WEBMADE]

Ciao,

ho avuto un errore simile, solo nella conversione di alcune tabelle utf8mb4_general_ci, non riesco a capire se dipende dal mio database o da prestashop, riporto l'errore:

Quote

SQL 1.7.7.0 1709 in ALTER TABLE `na_configuration` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci: Index column size too large. The maximum column size is 767 bytes.SQL 1.7.7.0 1709 in ALTER TABLE `na_connections_source` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci: Index column size too large. The maximum column size is 767 bytes.SQL 1.7.7.0 1709 in ALTER TABLE `na_customer` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci: Index column size too large. The maximum column size is 767 bytes.SQL 1.7.7.0 1709 in ALTER TABLE `na_employee` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci: Index column size too large. The maximum column size is 767 bytes.SQL 1.7.7.0 1709 in ALTER TABLE `na_order_state` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci: Index column size too large. The maximum column size is 767 bytes.SQL 1.7.7.0 1709 in ALTER TABLE `na_page_type` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci: Index column size too large. The maximum column size is 767 bytes.SQL 1.7.7.0 1709 in ALTER TABLE `na_smarty_cache` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci: Index column size too large. The maximum column size is 767 bytes.

la cosa strana è che alcune di queste tabelle sono vuote, non hanno righe.

Aspettiamo qualche riscontro... grazie.

[zod]

Stesso problema aggiornando da PS 1.7.6.8 a 1.7.7.1

7 tabelle con questo problema

SQL 1.7.7.0 1709 in ALTER TABLE `smb_configuration` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci: Index column size too large. The maximum column size is 767 bytes.
SQL 1.7.7.0 1709 in ALTER TABLE `smb_connections_source` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci: Index column size too large. The maximum column size is 767 bytes.
SQL 1.7.7.0 1709 in ALTER TABLE `smb_customer` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci: Index column size too large. The maximum column size is 767 bytes.
SQL 1.7.7.0 1709 in ALTER TABLE `smb_employee` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci: Index column size too large. The maximum column size is 767 bytes.
SQL 1.7.7.0 1709 in ALTER TABLE `smb_order_state` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci: Index column size too large. The maximum column size is 767 bytes.
SQL 1.7.7.0 1709 in ALTER TABLE `smb_page_type` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci: Index column size too large. The maximum column size is 767 bytes.
SQL 1.7.7.0 1709 in ALTER TABLE `smb_smarty_cache` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci: Index column size too large. The maximum column size is 767 bytes.

Ho provato a fare una installazione nuova, sempre 1.7.7.1, ha dato lo stesso problema, bloccandosi al 13%. Con errore:

Errore SQL nella query Index column size too large. The maximum column size is 767 bytes.

 

Ho risolto seguendo queste istruzioni, è sicuramente un bug che devono risolvere:

 

Edited February 14, 2021 by zod
Solution found (see edit history)