I’ve done a Migration from Magento 126.96.36.199 to 2.4.1. There is a total of 1750 products.
I went to:
- Catalog –) Products, select 200 per page and was browsing by using the right arrow. It takes longer than expected for the next page of products to load and then when going from page 6 to page 7 of products (out of 9 total) – out of nowhere – there is a pop-up which says:
Attention Something went wrong.
If you click OK – you get the following Error on the page itself:
Something went wrong with processing the default view and we have
restored the filter to its original state.
When this happens, that specific user is corrupted somehow and you always get this Error when going into products.
I tried deleting all Cache and re-indexing but it doesn’t help nor does logging out and logging back in.
I found articles where they suspect not having SKUs on products may cause this and adding SKUs to those products might fix it. When searching for products with NO SKUs via SQL however, I always get the following Error:
#1146 – Table ‘database_name741.catalog_product_entity’ does not exist.
I am not that good with running SQL queries so I was just copying and pasting some from this article here:
Any idea what I can do to identify products with no SKU or how else to fix this problem?