i was facing this challenge and was almost frustrated when i finally got how to fix it. For me I used this
i used the code below to view the table
sql command select *
from catalog_eav_attribute cea
join eav_attribute ea
on ea.attribute_id = cea.attribute_id
and backend_type in ('text', 'varchar')
where
cea.is_filterable = 1
and Set is_filterable to 0 to allow category pages to load.
update catalog_eav_attribute cea
join eav_attribute ea
on ea.attribute_id = cea.attribute_id
and backend_type in ('text', 'varchar')
set cea.is_filterable = 0
where
cea.is_filterable = 1
Reindex/Refresh Cache
magento indexer:reindex
magento cache:clean
magento cache:flush
i got the solution from this link, it was a very helpful solution....thank you doublesharp
best solution ever