Ich versuche aktuell per sync API Seo Urls zu aktualisieren:
{
"sync-seo-urls": {
"entity": "seo_url",
"action": "upsert",
"payload": [
{
"id": "12689155c0044312afe6309f58768e1c",
"seoPathInfo": "AufkleberY\/",
"isCanonical": true,
"pathInfo": "\/navigation\/7ecef9e07d884285b9cbe5758a7d8c2d",
"routeName": "frontend.navigation.page",
"foreignKey": "7ecef9e07d884285b9cbe5758a7d8c2d",
"salesChannelId": "33c3552352fa41589fc9e074bbc41f91"
}
]
}
}
Das führt aber trotz korrekter ID immer zum gleichen Fehler:
An exception occurred while executing 'UPDATE `seo_url` SET `foreign_key` = ?, `sales_channel_id` = ?, `route_name` = ?, `path_info` = ?, `seo_path_info` = ?, `is_canonical` = ?, `updated_at` = ? WHERE id = ?' with params ["\x7e\xce\xf9\xe0\x7d\x88\x42\x85\xb9\xcb\xe5\x75\x8a\x7d\x8c\x2d", "\x33\xc3\x55\x23\x52\xfa\x41\x58\x9f\xc9\xe0\x74\xbb\xc4\x1f\x91", "frontend.navigation.page", "\/navigation\/7ecef9e07d884285b9cbe5758a7d8c2d", "AufkleberY\/", 1, "2021-10-26 14:37:04.092", "\x12\x68\x91\x55\xc0\x04\x43\x12\xaf\xe6\x30\x9f\x58\x76\x8e\x1c"]:
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '/\xBB_\xE2\xE2\x9AMp\xAAXT\xCE|\xE3\xE2\x0B-3\xC3U#R\xFAAX\x9F\x' for key 'uniq.seo_url.foreign_key'
Hat das bereits jemand hinbekommen? Muss ich wirklich immer erst die alte SEO Url invalidieren und eine neue erzeugen?