shopware/production

Upgrade from v6.3.1.0 fails

zaifastafa opened this issue · 1 comments

Using the production template when upgrading from 6.3.1.0 to the 6.3.4.1 using composer install and also through the browser, I get the following error in both ways -

ERROR     [app] Migration: "Shopware\Core\Migration\Migration1595422169AddProductSorting" failed: "An exception occurred while executing 'INSERT INTO product_sorting (id, url_key, priority, active, locked, fields, created_at) VALUES (?, ?, ?, ?, ?, ?, ?)' with params ["\xf3\xc5\x0c\x47\x10\x31\x49\x9d\xb6\xde\xf6\x69\x73\x4f\x0d\xa4", "score", 0, 1, 1, "[{\"field\":\"_score\",\"order\":\"desc\",\"priority\":1,\"naturalSorting\":0}]", "2021-01-15 12:53:17.445"]:

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'score' for key 'product_sorting.uniq.product_sorting.url_key'"

The issue was with the client shop. The version was 6.3.1.0 but it already had the product sorting migrations applied to it.