... And now, it works fine on other entities, without changing anything :s ...
To answer your question: by default yes: name, and then I want to add more fields, like description and more.
I have to dig deeper into how to reproduce this, because now everything seems to be fine.
FULLTEXT search problem
Collapse
X
-
I highly recommend using utf8mb4_unicode_ci for text/varchar fields.
Do you have only one field in text filters?Leave a comment:
-
Rebuild database fault: exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 1283 Column 'description' cannot be part of FULLTEXT index
Basically, if that helps, even when trying to add the index manually within phpMyAdmin interface, it actually replaces the default fulltext index (on "name"), except if I switch back to "utf8_unicode_ci" encoding.Leave a comment:
-
What's in log?
We officially don't support MariaDB, nevertheless we tested fulltext there and it worked.Leave a comment:
-
-
FULLTEXT search problem
Hi,
it seems that there is a bug when adding new fields to the fulltext indexing of an entity.
In fact, I noticed that whenever the field was encoded as "utf8mb4_unicode_ci", EspoCRM failed rebuilding.
However, if everything is "utf8_unicode_ci", then I am able to add as many FULLTEXT indices as I want.
I am using MariaDB 10, php 5.6
Thanks.Tags: None
Leave a comment: