Home / Magento / Error when reindexing Catalog URL Rewrites in magento admin

Error when reindexing Catalog URL Rewrites in magento admin

Error when reindexing Catalog URL Rewrites in magento admin.
Follow the following steps for the reindexing Catalog URL Rewrites in magento.

Open CMD or Xampp Shell Command window.

see image given below[/accordion][accordion title=” Connect with database phpmyadmin MySQL.”]

command is:

mysql -u root -p

pres enter after asked password then enter password(if you have set password )

if you have not set password for phpmyadmin mysql then press enter again its automatically connect with the database

if you have set the password then type this command like this :

mysql -u root -p

pres enter button after you will get the message please enter your password:

*******

press enter it will be connected ok

Select Databases 

type query

show databases;

after you will see multiple database

next command is

use databasename(grocery) ; [/accordion]

Run final Query for reindex url indexing solutions.

type query

truncate core_url_rewrite;

after you will see result in images

truncate

next command is run

select count<*> from core_url_rewrite;

after you will see result in images

select-count

 

An error occurred while saving the URL rewrite magento

 

About Sushil_kumar

Check Also

How to add new search engine like Solr or Elasticsearch in Magento2

Magento 2 Community Edition comes with support for only MySQL search engine, but some projects …

Leave a Reply

Your email address will not be published. Required fields are marked *