Hi all, I am trying to delete category programmatically using spryker category facade. but category

U047BQA5QPL

Alberto Reyer

Don't get me started on this topic 😄

There are several issues in the Spryker core and you might have stumbled upon one of those.

1. There already exists a redirect for this particular url, then the check if the url exists returns false, while in fact the url exists (as a redirect). You can fix it in \Pyz\Zed\Url\Business\Url\UrlUpdater::assertUrlDoesNotExist with

        //case: the url existed before, but was redirected to a new one and now this change is rolled back,
        //meaning the redirect becomes the new url
        if ($existingUrl->getFkResourceRedirect()) {
            $this->urlDeleter->deleteUrlRedirect(
                (new UrlRedirectTransfer())
                    ->setIdUrlRedirect($existingUrl->getFkResourceRedirect()),
            );

            return;
        }

Alberto Reyer

2. The url in the DB is /EN/. The comparison in PHP is case sensitive, while the retrieval from the DB is case insensitive, so it will find /EN/ in the DB, but the check if /en/ (your new url) === /EN/ returns false and the url update tries to insert /en/ into the DB, but fails as the collation is case insensitive, which means /en/ === /EN/

Alberto Reyer

I most likely case 1, took me months to find it and the proposed solution is a workaround you should only use if you now that deleting the redirect is acceptable

sebastian.larisch

thanks for that, guess this can also some of our problems