[Plugin: Relevanssi – A Better Search] Relevanssi 3.0 bug thread

After an upgrade, the plugin doesn’t work. Fix is simple: deactivate the plugin and activate it again. Then it’ll work.

After upgrade to 3.0 on WordPress 3.4.1, Relevanssi stopped working, deactivate and reactivate didn’t fix the problem.

Logging stopped working for me. Unistalled, deleted table and reinstalled and still nothing in the logs. i’m usoing on a mulit-site installation.

Robanna, the free version of Relevanssi is not supposed to work on multi-site installations.

BlynDesigns, if deactivation doesn’t work, the next step to try is a delete and reinstall. Does that help?

Thanks for your quick response. I tried deleting and reinstalling, that didn’t fix the problem. Still not working ??

How does it not work, exactly?

It’s only active on the main site. Does that make a difference? I have it all working now except for the logging.

Ok, in that case it may work.

And sure enough, there’s a bug in the code, messing up the logs. Thanks Robanna, I’ll fix this, I think 3.0.1 will be out soon.

Thank you! I was pulling my hair out thinking I did something wrong. I can test it whenever you have it ready.

Thanks

Two bugs, with fixes. Found by turning on WP_DEBUG in wp-config.php, and some debugging lines in wp-admin/includes/upgrade.php.

1. In relevanssi_update_log() in ‘lib/common.php’, a wpdb error due to undefined $relevanssi_variables[‘relevanssi_log_table’].

2. In relevanssi_create_database_tables() in ‘lib/init.php, a wpdb error due to missing linefeeds passed to dbDelta(), again with the table relevanssi_log_table. The dbDelta() function is very particular about syntax and it’s not well-documented. The errors don’t really appear unless you uncomment some echo lines in upgrade.php (and maybe add more echo lines and exits!).

Both errors can be fixed in init.php. Here is a patched version:
https://pastebin.com/3Vnk47xT

That worked for my logging issues. Thanks!

Thanks, I already knew 1., but not 2., so thanks. 1. is simply a typo, the index is ‘log_table’, not ‘relevanssi_log_table’…

I know dbDelta() is very particular, it has been a source of frustration and annoyance before. I wonder why it cares about linefeeds there, when other tables are just fine without linefeeds.

Thanks, make sure anything you send dbDelta() has linefeeds because it splits on them to examine the fields. If the field description does not match the existing field description, it puts this clause in the new SQL query:

CHANGE COLUMN field full-line-from-passed-query

So if the query you pass it is all one line, that is going to be some bad SQL there!

After upgrade to 3.0 on WordPress 3.4.1, Relevanssi stopped working, deactivate and reactivate didn’t fix the problem.

I have the same issue. Since I upgraded, no search results anymore. Downgraded back to 2.9.14.

Another thing to check: make sure the post types to index are set. In some cases they are blank, which causes an empty index. That setting was changed from previous version, and should upgrade automatically, but for some reason that can sometimes fail.

I’ll probably add an alert about that in the next version to make it easier to spot.