khasta83 Posted March 25, 2021 Share Posted March 25, 2021 Buenos días. Estoy tratando de actualizar la versión de 1.7.6.8 a 1.7.7.2 pero me falla el proceso. He buscado información y encuentro una web de github pero no entiendo la solución. ¿Alguien podría explicarme el proceso para solucionar este problema? El error a la hora de actualizar es este: 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 1146 in ALTER TABLE `ps_connections` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci: Table 'elinker_lcab.ps_connections' doesn't exist SQL 1.7.7.0 1146 in ALTER TABLE `ps_connections_page` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci: Table 'elinker_lcab.ps_connections_page' doesn't exist SQL 1.7.7.0 1146 in ALTER TABLE `ps_connections_source` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci: Table 'elinker_lcab.ps_connections_source' doesn't exist 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 1146 in ALTER TABLE `ps_guest` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci: Table 'elinker_lcab.ps_guest' doesn't exist 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. SQL 1.7.7.0 1146 in ALTER TABLE `ps_statssearch` CHANGE `keywords` `keywords` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL: Table 'elinker_lcab.ps_statssearch' doesn't exist SQL 1.7.7.0 1146 in ALTER TABLE `ps_connections` CHANGE `http_referer` `http_referer` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL: Table 'elinker_lcab.ps_connections' doesn't exist Muchas gracias, Un saludo Link to comment Share on other sites More sharing options...
aixos Posted March 26, 2021 Share Posted March 26, 2021 Que versión tienes de 1-Click Upgrade Link to comment Share on other sites More sharing options...
khasta83 Posted March 26, 2021 Author Share Posted March 26, 2021 Hola. Tengo la v4.12.0 Link to comment Share on other sites More sharing options...
aixos Posted March 26, 2021 Share Posted March 26, 2021 Hola, es la versión correcta no deberías tener ningún problema. Prueba lo siguiente, te haces tus copias de seguridad manualmente, archivos y bse de datos (por si algo falla poder recuperar) Ahiora vas a actulaizar desde el modulo 1-Click Upgrade 1 - Opciones de Copia de seguridad , marcas NO 2 - Opciones de actualización , marcas SI - Desactivar modulos nativos marcas SI - Upgade the default theme marcas NO - Switch the default theme marcas NO - Keep the customized email templates Link to comment Share on other sites More sharing options...
khasta83 Posted March 26, 2021 Author Share Posted March 26, 2021 (edited) Hola. Salvo lo de desactivar la copia de seguridad, el resto está así. Y es como me ha fallado una y otra vez. Además ahora no puedo acceder a la pestaña clientes o a las opciones del modulo del transportista instalado, me arroja error 500. Encontré una posible solución, pero no consigo encontrar el procedimiento a seguir para poder probarlo: https://github.com/PrestaShop/PrestaShop/issues/21948 Edited March 26, 2021 by khasta83 (see edit history) Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now