WordPress.org

Ready to get started?Download WordPress

Forums

Relevanssi - A Better Search
[resolved] Not working in WP 3.7 (24 posts)

  1. aljuk
    Member
    Posted 10 months ago #

    No search results from Relevanssi returned in WordPress 3.7

    http://wordpress.org/plugins/relevanssi/

  2. foxystoatypig
    Member
    Posted 10 months ago #

    same here, worked fine in 3.6, no results for any search in 3.7

  3. webmestreglenat
    Member
    Posted 10 months ago #

    I confirm no serach results

  4. ShokAIM
    Member
    Posted 10 months ago #

    it generates entries in error_log like
    WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')) ORDER BY tf DESC LIMIT 60' at line 3 for query SELECT *, title * 5 + content + comment * 0 + tag * 2 + link * 0 + author + category * 2 + excerpt + taxonomy + customfield + mysqlcolumn AS tf FROM wp_relevanssi WHERE term = 'small' AND doc IN (SELECT DISTINCT(ID) FROM wp_posts

    doesn't work

  5. lkycy
    Member
    Posted 10 months ago #

    no search results since update 3.6 to 3.7

  6. solagirl
    Member
    Posted 10 months ago #

    Same here, every search generates a sql error loged in error_log, no search results.

  7. Bruz
    Member
    Posted 10 months ago #

    I hope the author will fix this soon...

  8. sosukeinu
    Member
    Posted 10 months ago #

    same sql error

  9. erryn
    Member
    Posted 10 months ago #

    Same issue as well, SQL syntax, line 3 (I think I'm going to cry, lol! Just knocked out quite a few of our shops)

  10. Steve Moss
    Member
    Posted 10 months ago #

    No search results for my site. Re-installed the backup. Will this be fixed, so I can update to 3.7 ??

    It would be a catastrophe if the new version updated automatically and I had not backed up the site.
    How do I turn off the the automatic update feature that comes with the new version?

    Thanks, for a reply.

  11. BAC
    Member
    Posted 10 months ago #

    yeah, 3.7 broke the plugin.

  12. wordpresswebjunkie
    Member
    Posted 10 months ago #

    Confirming what everyone else knows....same MySQL error on my sites as well. It is interesting the compatibility for Relevanssi shows 3.7. This is a great plugin, hopefully we will get an update to address the issue soon.

  13. Mikko Saari
    Member
    Plugin Author

    Posted 10 months ago #

    Looks like Relevanssi is incompatible with the new WordPress 3.7. Attempt to search ends up in an error message. So, if Relevanssi functionality is important to you, please hold on with the WordPress update. I'll try to get a compatible Relevanssi version out as soon as possible, hopefully during the weekend.

    I'll have to pass some of the updates planned for the next version in order to get this fix out as soon as possible, so don't expect the next version to actually include any fixes I've promised for the next version. Their time will come in the next next version.

  14. Mikko Saari
    Member
    Plugin Author

    Posted 10 months ago #

    Ok, this was a quick fix. I just uploaded 3.1.9, please let me know if you find other problems - this version will at least fix the obvious MySQL error.

  15. hereswhatidid
    Member
    Posted 10 months ago #

    I was able to do a quick fix to get mine working again in 3.7. Here is the code I updated in the /lib/search.php file:

    if (count($author_in) > 0) {
    			$authors = implode(',', $author_in);
    			if ( $authors !== '' ) {
    				$query_restrictions .= " AND doc IN (SELECT DISTINCT(ID) FROM $wpdb->posts
    				    WHERE post_author IN ($authors))";
    
    			}
    		}

    Basically I had to add in a check to see if $authors was an empty string. Looks like it is being set to an array of just a single empty string in 3.7 which makes the count validation true but then breaks the SQL query.

    EDIT: Forgot to mention it's on line 390 in that file

  16. hereswhatidid
    Member
    Posted 10 months ago #

    Assuming that is the correct fix it may need to be added elsewhere such as for the $author_not_in section as well.

  17. ShokAIM
    Member
    Posted 10 months ago #

    WOW that was fast :D and efficient ! no more errors and it display's search results, THANK YOU !

  18. Bruz
    Member
    Posted 10 months ago #

    It works! Thank you! :)

  19. solagirl
    Member
    Posted 10 months ago #

    The new update fixed the problem. Love this plugin!

  20. aljuk
    Member
    Posted 10 months ago #

    Brilliant guys, many thanks!

  21. foxystoatypig
    Member
    Posted 10 months ago #

    sorted for me - many thanks

  22. Steven Gliebe
    Member
    Posted 10 months ago #

    Thank you for fixing this so quickly. Fantastic plugin.

  23. Christie Witt
    Member
    Posted 10 months ago #

    No Search results in WP 3.7. Is there any fix?

  24. Mikko Saari
    Member
    Plugin Author

    Posted 10 months ago #

    Yes, version 3.1.9.

Reply

You must log in to post.

About this Plugin

About this Topic

Tags

No tags yet.