TiagoSilvaPereira / vemto-issues

Repository to track Vemto Issues
30 stars 0 forks source link

multiLineString not supported as searcheable fields #460

Open art35rennes opened 9 months ago

art35rennes commented 9 months ago

if a model include a multiLineString it must be exclude of searcheable fields to avoid following error on model index page. "adresse" is the multiLineString field.

SQLSTATE[HY000]: General error: 1210 Mauvais arguments à like
SELECT
  count(*) AS aggregate
FROM
  `senders`
WHERE
  (
    `id` LIKE % %
    OR `name` LIKE % %
    OR `mail` LIKE % %
    OR `phone` LIKE % %
    OR `adresse` LIKE % %
    OR `zip_code` LIKE % %
    OR `city` LIKE % %
    OR `logo` LIKE % %
    OR `company_logo` LIKE % %
    OR `sender_media_id` LIKE % %
    OR `created_at` LIKE % %
    OR `updated_at` LIKE % %
  )

And yes, i do a mistake, i want a text column, not a multiLineString :)