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

I have same problem too. Not working anymore.

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.

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

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.

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.

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