Support » Plugin: Relevanssi - A Better Search » Not working in WP 3.7

Viewing 15 replies - 1 through 15 (of 23 total)
  • same here, worked fine in 3.6, no results for any search in 3.7

    I confirm no serach results

    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

    no search results since update 3.6 to 3.7

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

    I hope the author will fix this soon…

    same sql error

    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)

    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.

    yeah, 3.7 broke the plugin.

    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.

    Plugin Author Mikko Saari


    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.

    Plugin Author Mikko Saari


    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.

    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

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

Viewing 15 replies - 1 through 15 (of 23 total)
  • The topic ‘Not working in WP 3.7’ is closed to new replies.