🐛 | Facets | Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column
🇮🇱Israel susanb
Possible Workaround:
I have the same error. I get this when trying to update product attributes. I haven't managed to find a fix yet, but I found that by changing the name of my path for the search_api view product_catalog to anything except what it is supposed to be (i.e, change /products to /productstempname and save the view, I am able to update the attributes. Afterwards, need to change view path back to /products and save view, clear cache and all is OK.
I've tried different versions of facets with varying versions of Drupal core and I still get this error.
Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'route_param_key' at row 1: UPDATE "menu_tree" etc