Magento 2 CMS block with the same ID already exists

I have seen the below error when I open cms block grid

something went wrong with processing the default view and we have restored the filter to its original state.

I found the below log in the exception log

[2020-10-29 09:15:59] report.CRITICAL: Item (Magento\Framework\View\Element\UiComponent\DataProvider\Document) with the same ID "29" already exists. {"exception":"[object] (Exception(code: 0): Item (Magento\\Framework\\View\\Element\\UiComponent\\DataProvider\\Document) with the same ID \"29\" already exists. at /app/vendor/magento/framework/Data/Collection.php:405)"} []

I found block_id from 1 to 54 in the cms_block table. I found sequence_value from 1 to 28 in sequence_cms_block. Also, I found two records having the same block_id 29.

I fixed the above issue by insert sequence_value as 55 in sequence_cms_block, then update the one of block_id 29 as 55.

INSERT INTO sequence_cms_block ( sequence_value ) VALUES (55);

update cms_block set block_id = 55 where block_id = 29 and identifier = 'Featured Categories';

It fixed the cms block grid loading issue. I hope it helps.

Recent Posts

See All

Follow Me

  • LinkedIn
  • Twitter
  • Facebook
  • YouTube
  • Instagram

©2020 by Bilal Usean. Proudly created with Wix.com