When i run php bin/magento setup:upgrade in cmd, then i'm getting this error. anyone can help me, why this error is showing ? website is working fine but i want to fix this error. Plz help if someone know about this. Thanks

enter image description here

1 Answer 1


Open the Database

Go to the Table Catalog_category_entity_text and go to Indexes option and remove the Index from Value Id.

Hope This will help you!!

  • I'm running query but getting this error #1091 - Can't DROP INDEX value_id; check that it exists Sep 30, 2019 at 8:34
  • drop all other indexes and set indexes for value_id as primary Sep 30, 2019 at 8:36

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.