I can contact his to K2 but they can't help me to much... My problem Drop-down Selection of K2, I created them. 5 Years Old 6 Years Old 7 Years Old 8 Years Old 9 Years Old

If I search "5 Ye", No results found! because K2 Search module can't read from 5. If I search " Yea", the result will show any item has " Yea". (They can read space, word, and Unicode but can't read number).....//

I asked K2 and they said..

This is not a K2 issue actually. It's a setting in the database which by default does not search for anything less than 3 characters. "5 Ye" is 2 words with less than 3 characters length each.

So unless you can modify your database's configuration, you can't do much about this.

But do try searching for "5 Ye" using the double quotes and it'll probably work, as K2 will use the entire string to search in the database (including the space).

If you don't explicitly use double quotes in your search, any spaces in between words are evaluated as OR statements and any spaces before/after what you type are trimmed.

"yea" is also searched because it's 3 characters.

Like I said, it's a database configuration thing.

For InnoDB it's this: dev.mysql.com/doc/refman/5.7/en/innodb-parameters.html#sysvar_innodb_ft_min_token_size For MyISAM it's this: dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_ft_min_word_len

Pass these on to your server host - they may have no issue adjusting their database config (but I highly doubt they will do so).

I hope someone can help me to modify database table that allows K2 Search Module can read the number.

thank u...

Here is my Table: jos3y_k2_extra_fields. Is there I need to change here that allows K2 module can search a number value. enter image description here

enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.