Prestashop 1.7.6.0 to the newest one, giver me error i db

[spc]

Hello
I have now tried many times to update PS from 1.7.6.0 to the latest, and I always get errors with the update for the database.
I have searched everywhere, but can not find a solution.

The error i get is:

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.
Error during database upgrade. You may need to restore your database.
Error upgrading Doctrine schema

 

[ComGrafPL]

Try this solution:

 

[spc]

Thanks, i manage to remove this 7 error, now i have a new one

Updating database schema...
Executing: ALTER TABLE ps_admin_filter CHANGE filter_id filter_id VARCHAR(191) NOT NULL
Executing: ALTER TABLE ps_attribute_group_lang CHANGE id_attribute_group id_attribute_group INT NOT NULL, CHANGE id_lang id_lang INT NOT NULL, ADD PRIMARY KEY (id_attribute_group, id_lang)
23:27:25 ERROR [console] Error thrown while running command "prestashop:schema:update-without-foreign --env=prod". Message: "An exception occurred while executing 'ALTER TABLE ps_attribute_group_lang CHANGE id_attribute_group id_attribute_group INT NOT NULL, CHANGE id_lang id_lang INT NOT NULL, ADD PRIMARY KEY (id_attribute_group, id_lang)':
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '4-2' for key 'PRIMARY'" ["exception" => Doctrine\DBAL\Exception\UniqueConstraintViolationException { …},"command" => "prestashop:schema:update-without-foreign --env=prod","message" => """ An exception occurred while executing 'ALTER TABLE ps_attribute_group_lang CHANGE id_attribute_group id_attribute_group INT NOT NULL, CHANGE id_lang id_lang INT NOT NULL, ADD PRIMARY KEY (id_attribute_group, id_lang)':\n \n SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '4-2' for key 'PRIMARY' """]
In AbstractMySQLDriver.php line 55:
An exception occurred while executing 'ALTER TABLE ps_attribute_group_lang CHANGE id_attribute_group id_attribute_g
roup INT NOT NULL, CHANGE id_lang id_lang INT NOT NULL, ADD PRIMARY KEY (id_attribute_group, id_lang)':
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '4-2' for key 'PRIMARY'
In PDOConnection.php line 90:
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '4-2' for key 'PRIMARY'
In PDOConnection.php line 88:
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '4-2' for key 'PRIMARY'
prestashop:schema:update-without-foreign [-h|--help] [-q|--quiet] [-v|vv|vvv|--verbose] [-V|--version] [--ansi] [--no-ansi] [-n|--no-interaction] [-e|--env ENV] [--no-debug] [--id_shop [ID_SHOP]] [--id_shop_group [ID_SHOP_GROUP]] [--]