Few things you should try out first
- Disable the third-party modules.
- Make sure elasticsearch is up and running
- Run the below query to see if is there any issue with backend_type in attributes
If still doesn’t work and Check below in database
SELECT *
FROM catalog_eav_attribute cea
JOIN eav_attribute ea
ON ea.attribute_id = cea.attribute_id
AND backend_type IN ('text')
WHERE
cea.is_filterable = 1 OR cea.is_filterable_in_search = 1And if you find any attribute mis configured run below sql
UPDATE catalog_eav_attribute cea
JOIN eav_attribute ea
ON ea.attribute_id = cea.attribute_id
AND backend_type in ('text')
SET
cea.is_filterable = 0, cea.is_filterable_in_search = 0
WHERE
cea.is_filterable = 1 OR cea.is_filterable_in_search = 1And to update on magento do reindexing
magento indexer:reindex magento cache:clean magento cache:flush
