Support » Plugin: Relevanssi - A Better Search » [Plugin: Relevanssi – A Better Search] No results, even after deactivating/reactivating

  • Resolved Extrafino

    (@extrafino)


    I just noticed Relevanssi stopped returning results. It used to work fine, but seemed to stop working after upgrading wp to version 3.4.1 or 3.4.2
    I tried deactivating Relevanssi and rebuilding the index after reactivating. The index builds, but the search page does not return any results.
    I have a call to query_posts on the search results page, but removing it does not change anything.
    Deactivating Relevanssi shows normal wp search results.
    Any ideas?

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

Viewing 13 replies - 1 through 13 (of 13 total)
  • I have same problem too. Not working anymore.

    Plugin Author Mikko Saari

    (@msaari)

    Hard to say. I can say it’s not the 3.4.2 upgrade, Relevanssi does work with 3.4.2. Have you upgraded something else?

    Same problem here. Index shows terms, but any search returns no results.

    Plugin Author Mikko Saari

    (@msaari)

    Is anybody willing to give me admin access to their site? I’d like to take a look around to see if I can figure out what’s wrong. It’s very hard to fix something I can’t reproduce on any of my sites.

    I works for me again.

    When I only deactivated and activated plugin it didn’t do nothing. So, I deactivated it and deleted it. Then I installed, made my own setups, build the index and continued indexing.

    I tried deleting and reinstallung, still same for me. With Relevanssi activated, I get no search results

    I have the same problem, and it won’t fix by deactivating or deleting.

    If it’s any help, this is the MySQL error showing on the search results page:

    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 '' at line 3]
    SELECT *, title + content + comment + tag + link + author + category + excerpt + taxonomy + customfield + mysqlcolumn AS tf FROM wp_relevanssi WHERE term = 'exhibition' AND ((doc IN (SELECT DISTINCT(ID) FROM wp_posts WHERE post_type IN ('post','page','attachment','exhibition','sponsor'))) OR (doc = -1)) ORDER BY tf DESC LIMIT
    
    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 '' at line 3]
    SELECT *, title + content + comment + tag + link + author + category + excerpt + taxonomy + customfield + mysqlcolumn AS tf FROM wp_relevanssi WHERE (term LIKE '%exhibition' OR term LIKE 'exhibition%') AND ((doc IN (SELECT DISTINCT(ID) FROM wp_posts WHERE post_type IN ('post','page','attachment','exhibition','sponsor'))) OR (doc = -1)) ORDER BY tf DESC LIMIT

    sampe problem here: No post results, but shows amount of search results

    Plugin Author Mikko Saari

    (@msaari)

    Ok, the MySQL code posted by rubious helped me figure this out.

    You probably have “Limit searches” enabled and “Limit” is empty. Put a value in “Limit” (say, 200), and the search works.

    For me, the problem remains. Limit or no limit, still the same with WP 3.4.2 and Relevanssi 3.0.5 gives no search results.

    Plugin Author Mikko Saari

    (@msaari)

    Can you give me admin access so I can take a look at your site? Otherwise, there’s very little I can do to help. My email is mikko @¬†mikkosaari.fi.

    The last update to the RoleScoper-Plugin solved this problem for me.

    Plugin Author Mikko Saari

    (@msaari)

    Ah, had you mentioned you were running Role-Scoper, I’d fixed this a month ago. Glad to hear it works now.

Viewing 13 replies - 1 through 13 (of 13 total)
  • The topic ‘[Plugin: Relevanssi – A Better Search] No results, even after deactivating/reactivating’ is closed to new replies.