Skip to content

Invalid column data type “” when reindexing catalog_product_flat

I’m using Magento 2.3.3 and when I try to reindex, the category flat was not reindexed and shows an error like this: Invalid column data type “”

enter image description here

Every Answer in here sends me to this
Invalid column data type when reindex Magento 2

but that didn’t fix it for me, I tried adding

            case 'int unsigned':
                $columnType = 'int';
                break;
            case 'smallint unsigned':
                $columnType = 'smallint';
                break;
            case 'bigint unsigned':
                 $columnType = 'bigint';
                 break;

into getDdlTypeByColumnType function of “vendor/magento/module-eav/Model/ResourceModel/Helper.php”
but that didn’t work, any other Solutions?

enter image description here