Magento 2.0.2 – Backend CMS Pages and Blocks Disappeared

magento2

After deleting a store my cms and static block pages have become unviewable under admin. Instead I'm left with the error below. I tried to reindex and delete any cache files I could find even though I'm sure this is a db problem. Just not sure how to approach it, any help would be appreciated.

Notice: Undefined index: store_id in
/var/www/html/magento2/vendor/magento/module-store/Ui/Component/Listing/Column/Store.php
on line 82

Best Answer

There is a table that match cms_pages and stores (cms_page_store), to find any relation error you can make a Left Join to determine if some page isn't assigned to any store:

SELECT cp.page_id, cp.identifier, cps.store_id FROM cms_page AS cp
LEFT JOIN cms_page_store as cps on cps.page_id = cp.page_id

If you see some page without store like here:

Just add a new record to cms_page_store for that/those page/s. with value = 0 (admin)

Related Solutions

Magento 2 – store_id in UI Listing Component

Finally I have solved this issue. It turned out I was had two collections available for my grid and the one that was loaded did not contain the store_id index. For more information about the double collections see: Magento 2: Why does a UI Listing Component need Two Collections?

To solve this I have edited the Dependency Injection configuration at /app/code/vendor/module/etc/di.xml

Here I replaced this:

<virtualType name="Vendor\Module\Model\ResourceModel\Blog\Grid\Collection" type="Magento\Framework\View\Element\UiComponent\DataProvider\SearchResult">
<arguments>
    <argument name="mainTable" xsi:type="string">vendor_module_blog</argument>
    <argument name="resourceModel" xsi:type="string">Vendor\Module\Model\ResourceModel\Blog</argument>
</arguments>

with this:

<type name="Vendor\Module\Model\ResourceModel\Blog\Grid\Collection">
<arguments>
    <argument name="mainTable" xsi:type="string">vendor_module_blog</argument>
    <argument name="eventPrefix" xsi:type="string">module_blog_grid_collection</argument>
    <argument name="eventObject" xsi:type="string">module_grid_collection</argument>
    <argument name="resourceModel" xsi:type="string">Vendor\Module\Model\ResourceModel\Blog</argument>
</arguments>

This makes sure my collection from app\code\vendor\module\Model\ResourceModel\AbstractCollection.php is used for the grid and now the store_id with the store view works.

Best Answer

Related Solutions

Magento 2 – store_id in UI Listing Component

Related Topic