This update catches up with Relevanssi Premium 1.10.11. It includes the following fixes:
Fuzzy searches are now a lot more efficient; they were a huge resource hog before.
Fixed a possible MySQL injection attack.
Fixed MySQL errors from empty meta queries.
Sort order (orderby and order variables) are now read from query variables instead of global variables.
Relevanssi will not choke on bad values of orderby anymore.
Limit searches is improved: when using AND search it is less likely to miss results.
Phrase recognition read the whole post content (which it didn’t need) from database, causing memory issues in some cases. Fixed that.
Highlighting was broken, and should work much better now.
After you update the plugin, please deactivate the plugin and activate it again.
WP repository plugin page.
10 Comments. Leave new
My search function does not pick any posts from June 2013 onward. Am currently using 3.1.6, may have had a previous version in June that was also not working b/c I noticed relevant posts were not appearing in search but did not connect the date issue until today. Help.
Might be an indexing issue. Did you deactivate and reactivate the plugin after updating to 3.1.6? If not, do that and then rebuild the index and see if that helps.
I did activate, deactivate, reactivate – no change. Not a programmer, how do I rebuild the index.
No programming necessary, just click “Build index” on Relevanssi settings page.
Worked. Thank you.
c
I’m experiencing a number of errors with Relevanssi 3.1.6:
For example:
Jun 23, 15:19:58 WordPress database error Duplicate key name ‘doctermitem’ for query ALTER TABLE pc_relevanssi ADD UNIQUE KEY doctermitem (doc, term, item) made by activate_plugin, do_action(‘activate_relevanssi/relevanssi.php’), call_user_func_array, relevanssi_install, _relevanssi_install, relevanssi_create_database_tables, dbDeltaJun 23, 15:19:58WordPress database error Duplicate key name ‘terms’ for query CREATE INDEX terms ON pc_relevanssi (term(20)) made by activate_plugin, do_action(‘activate_relevanssi/relevanssi.php’), call_user_func_array, relevanssi_install, _relevanssi_install, relevanssi_create_database_tablesJun 23, 15:19:58WordPress database error Duplicate key name ‘docs’ for query CREATE INDEX docs ON pc_relevanssi (doc) made by activate_plugin, do_action(‘activate_relevanssi/relevanssi.php’), call_user_func_array, relevanssi_install, _relevanssi_install, relevanssi_create_database_tablesJun 23, 15:19:58WordPress database error Duplicate key name ‘typeitem’ for query CREATE INDEX typeitem ON pc_relevanssi (type, item) made by activate_plugin, do_action(‘activate_relevanssi/relevanssi.php’), call_user_func_array, relevanssi_install, _relevanssi_install, relevanssi_create_database_tablesJun 23, 15:19:58WordPress database error Duplicate column name ‘term_reverse’ for query ALTER TABLE pc_relevanssi ADD COLUMN term_reverse VARCHAR(50); made by activate_plugin, do_action(‘activate_relevanssi/relevanssi.php’), call_user_func_array, relevanssi_install, _relevanssi_install, relevanssi_create_database_tablesJun 23, 15:19:58WordPress database error Duplicate key name ‘relevanssi_term_reverse_idx’ for query CREATE INDEX relevanssi_term_reverse_idx ON pc_relevanssi (term_reverse(10)); made by activate_plugin, do_action(‘activate_relevanssi/relevanssi.php’), call_user_func_array, relevanssi_install, _relevanssi_install, relevanssi_create_database_tables
Do these errors happen just once when you install the plugin (in which case I wouldn’t worry about them) or do you get them all the time?
Thanks for the update, Mikko. Unfortunately it didn’t work as usual for me so I had to go back to 3.1.5. Basically, it doesn’t want to generate an excerpt around the searched term but it does show the first words of the main content as excerpt – I did try using relevanssi_the_excerpt() also. So the result doesn’t show the searched for term. And when it does, by coincidence, it doesn’t highlight it. It does in the main content though, when one clicks on a result. Would be great if you could give a thought to what the problem may be.
Thanks
Poli
That’s going to be fixed in 3.1.7, actually. There’s also a quick fix: find the two occurrances of usort() in lib/excerpts-highlights.php and replace usort() with uasort(). That should fix the excerpts.
Thanks, Mikko. That did the trick. Good to know that Relevanssi’s working well again. Looking forward to 3.1.7