Magento – Getting “url key for specified store already exists” error in magento2

magento-2.1multistoreurl-key

I have installed magento2.1 and it was working properly with multi-store.

When I have disabled some categories from a "sub" store, and try to add any product (already assigned to "sub" store) to that category (which is edited in "sub" store) system returns error url key for specified store already exists.

If I removed "sub" store from "product in website" and try to assign that category again it saved successfully.

That's mean it is the issue with categories which has different value of any attribute in multi-store view.

I found so many post regarding this, but unable to fix this issue.

How to solve this issue in magento2?

Best Answer

I did following changes and it is working.

Magento\UrlRewrite\Model\Storage\DbStorage.php file

protected function insertMultiple($data)
    {
        try {
            $keys=array();
            foreach($data as $current=>$_data)
            {
                $key = $_data['request_path'];
                if(in_array($key,$keys))
                {
                    unset($data[$current]);
                }else
                {
                    $keys[]=$key;
                }
            }

            $this->connection->insertMultiple($this->resource->getTableName(self::TABLE_NAME), $data);
        } catch (\Exception $e) {
            if ($e->getCode() === self::ERROR_CODE_DUPLICATE_ENTRY
                && preg_match('#SQLSTATE\[23000\]: [^:]+: 1062[^\d]#', $e->getMessage())
            ) {
                throw new \Magento\Framework\Exception\AlreadyExistsException(
                    __('URL key for specified store already exists.')
                );
            }
            throw $e;
        }
    }

Reference :

https://community.magento.com/t5/Technical-Issues/quot-URL-key-for-specified-store-already-exists-quot-cannot-save/td-p/67837

Related Solutions

Magento – Error, “URL key for specified store already exists” When I’m Adding Products or Moving a Category

We had a similar issue where we couldn't save categories and after much database searching and debugging I found the issue was when it updated the product url's for the category. We'd imported and deleted products previously but found out they still had entries in the url_rewrite table. So the request_path already existed.

To clear it out I had to run the query

delete from url_rewrite where entity_type='product' and entity_id NOT IN (Select entity_id from catalog_product_entity);

To check if you do have ghost records you can run

select count(*) from url_rewrite where entity_type='product' and entity_id NOT IN (Select entity_id from catalog_product_entity);

Good luck

Magento 2 Category URL – Fixing ‘URL Key for Specified Store Already Exists’ Error

I've fixed this issue. And I have 2 solutions for that.

The first one: Clean up your database in table url_rewrite (Change the url_key of all category). You can write UpgradeData script for this solution.

The second one: Remove the duplication data when saving category. This data is throw in method doReplace($urls) in \vendor\magento\module-url-rewrite\Model\Storage\DbStorage.php file.

protected function doReplace($urls)
    {
        foreach ($this->createFilterDataBasedOnUrls($urls) as $type => $urlData) {
            $urlData[UrlRewrite::ENTITY_TYPE] = $type;
            $this->deleteByData($urlData);
        }
        $data = [];
        foreach ($urls as $url) {
            $data[] = $url->toArray();
        }
        $this->insertMultiple($data);
    }

After debugging, I found out $data variable has a duplicate record. If you want this method to work without any errors. Rewrite this method above to:

protected function doReplace($urls)
{
    foreach ($this->createFilterDataBasedOnUrls($urls) as $type => $urlData) {
        $urlData[UrlRewrite::ENTITY_TYPE] = $type;
        $this->deleteByData($urlData);
    }
    $data = [];
    $storeId_requestPaths = [];
    foreach ($urls as $url) {
        $storeId = $url->getStoreId();
        $requestPath = $url->getRequestPath();
        // Skip if is exist in the database
        $sql = "SELECT * FROM url_rewrite where store_id = $storeId and request_path = '$requestPath'";
        $exists = $this->connection->fetchOne($sql);

        if ($exists) continue;

        $storeId_requestPaths[] = $storeId . '-' . $requestPath;
        $data[] = $url->toArray();
    }

    // Remove duplication data;
    $n = count($storeId_requestPaths);
    for ($i = 0; $i < $n - 1; $i++) {
        for ($j = $i + 1; $j < $n; $j++) {
            if ($storeId_requestPaths[$i] == $storeId_requestPaths[$j]) {
                unset($data[$j]);
            }
        }
    }
    $this->insertMultiple($data);
}

If you want to get more details. Please, read my comment in

https://github.com/magento/magento2/issues/7298

Hope this will help you.

Best Answer

Related Solutions

Magento – Error, “URL key for specified store already exists” When I’m Adding Products or Moving a Category

Magento 2 Category URL – Fixing ‘URL Key for Specified Store Already Exists’ Error

Related Topic