Magento 2.4.5-p1
I have some bad data in the database which I imported from Magento 1.9 via System -> Data Transfer -> Import
What happens is – when I go into:
- Catalog - Products
It gives the following Error:
X Something went wrong with processing the default view and we have
restored the filter to its original state.
I’ve been through and around trying to identify which products are causing the problem but I can’t get that done so I’ve decided to delete several pages of products and add them in manually.
When I set the filter to 20 per page – I am able to go through all pages one by one all the way up to page 115 out of 119 (that’s where the Error starts).
I’ve tried truncating via:
TRUNCATE importexport_importdata;
but even this no longer works.
How would I delete all products from pages 115, 116, 117, 118 and 119 when I can’t actually load those pages in Catalog – Products?
The last product on page 114 has an ID of 2282. I have access to phpMyAdmin.