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.

112 views0 comments

Recent Posts

See All

How to generate bearer token - Magento 2 REST API

We can generate the admin bearer token using the below command. Please run the below command in the terminal to generate a token. curl -XPOST -H 'Content-Type: application/json'

Magento 2 script tag and available options in layout xml

We can add a script via layout XML file in Magento 2. The below format will stop the HTML parse until js downloaded and executed. <script src="Bilal_Usean/js/sample.min.js" /> The below format will st

How to update multiple products using Magento 2 REST API

We can able to update multiple products in the single Magento REST API request using bulk endpoints. Also, before using the Bulk API to process messages, you must install and configure RabbitMQ, which