This website uses cookies to personalize your experience. By using this website you agree to our cookie policy.

Reply To: Search not working for long consecutive terms (more than 50 characters)

Home Forums Product Support Forums Ajax Search Pro for WordPress Support Search not working for long consecutive terms (more than 50 characters) Reply To: Search not working for long consecutive terms (more than 50 characters)

#28411
Ernest MarcinkoErnest Marcinko
Keymaster

Hi,

I assume you are using the index table engine? The table structure has a 50 character limit on single words for performance reasons.
In this case, I would recommend switching back to the regular engine, or you can perhaps do an alter table query on the search database table, to allow longer words.
For that, you will have to access the database via a tool, like PHPMyAdmin or similar, and run the following queries:

ALTER TABLE wp_asp_index MODIFY COLUMN term VARCHAR(150) NOT NULL

..and

ALTER TABLE wp_asp_index MODIFY COLUMN term_reverse VARCHAR(150) NOT NULL

After the modification, you will have to re-create the index, so the data is populated again.