Free 3.1.6

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.

Your account

Not logged in. Log in to see your license details.

Search

Popular Resources

Showing only one recurring event

Some event calendar plugins do recurring events by creating many posts. That’s fine until those cloned posts fill up your…

Simple French plurals

If you have Relevanssi Premium and want to make Relevanssi understand French plurals, you can add this code to your…

Custom weighing with relevanssi_match and relevanssi_results

The relevanssi_match hook lets you modify the matches found for queries. It passes a match object, which has the post id ($match->doc), number of hits found in different parts of the post and the weight assigned to the post ($match->weight). Here’s how Relevanssi calculates the weight: $match->tf = $match->title *……higher the document will appear on the search results list. Weights are calculated for each term in the search query and multiplied to get the final weight for the document. So, now, if you want to say adjust the weights by freshness, you could fetch the post date based on…

Comment Section:

10 Comments. Leave new

Chandler Marrs
July 9, 2013 9:24 pm

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.

Reply
- Mikko Saari
  July 10, 2013 4:39 am
  
  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.
  
  Reply
  - Chandler Marrs
    July 10, 2013 5:48 pm
    
    I did activate, deactivate, reactivate – no change. Not a programmer, how do I rebuild the index.
    
    Reply
    - Mikko Saari
      July 10, 2013 6:36 pm
      
      No programming necessary, just click “Build index” on Relevanssi settings page.
      
      Reply
      - Chandler Marrs
        July 10, 2013 7:30 pm
        
        Worked. Thank you.
        
        c
Will Chapman
June 24, 2013 1:39 am

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

Reply
- Mikko Saari
  June 24, 2013 3:47 am
  
  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?
  
  Reply
solopoli
June 17, 2013 8:48 pm

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

Reply
- Mikko Saari
  June 18, 2013 4:06 am
  
  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.
  
  Reply
  - solopoli_dir
    June 18, 2013 12:49 pm
    
    Thanks, Mikko. That did the trick. Good to know that Relevanssi’s working well again. Looking forward to 3.1.7
    
    Reply