Support » Plugin: Relevanssi - A Better Search » Server Error on Some Searches (Limit set at 50 results)

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author Mikko Saari

    (@msaari)

    Is it the numbers? Or just a combination of particular search terms? Is there anything helpful in server error logs?

    Nothing I was able to see earlier. I’ll look again tomorrow, but I suppose I can give you a link to test: http://news.harker.org — feel free to try some combos. That was the first one we were able to trigger it on. Two weeks ago it was random combinations of words that were triggering errors. I fixed it by rebuilding the index.

    Nothing being written in terms of errors because of this today, however, the most recent “relevanssi” errors were thrown a few weeks ago and are pretty much just these:

    [17-May-2013 21:44:19] WordPress database error Unknown column 'term_reverse' in 'field list' for query INSERT IGNORE INTO wp_relevanssi (doc, term, term_reverse, content, title, comment, tag, link, author, category, excerpt, taxonomy, customfield, type, taxonomy_detail, customfield_detail, mysqlcolumn)			VALUES (3284, 'middle', REVERSE('middle'), 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 'post', 'a:1:{s:8:\"category\";i:1;}', '', 0), (3284, 'school', REVERSE('school'), 6, 1, 0, 0, 0, 0, 2, 0, 0, 0, 'post', 'a:1:{s:8:\"category\";i:2;}', '', 0), (3284, 'upper', REVERSE('upper'), 4, 1, 0, 0, 0, 0, 1, 0, 0, 0, 'post', 'a:1:{s:8:\"category\";i:1;}', '', 0), (3284, 'key', REVERSE('key'), 3, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'post', '', '', 0), (3284, 'club', REVERSE('club'), 5, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'post', '', '', 0), (3284, 'collaborating', REVERSE('collaborating'), 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'post', '', '', 0) // ... //. made by require_once('wp-admin/admin.php'), do_action('settings_page_relevanssi-premium/relevanssi'), call_user_func_array, relevanssi_options, relevanssi_build_index, relevanssi_index_doc
    Plugin Author Mikko Saari

    (@msaari)

    Those errors have to do with database upgrade in 3.1.6 and looks they’re gone (if not, deactive-reactivate does the trick).

    Looks like “2013” is the problem there. Don’t know why – it’s probably a really common term, but the limit of 50 should cover that.

    Hard to say, without error messages or closer debugging.

    Well that blows. I’ll go ahead and try an uninstall and reinstall then re-indexing. At least that will get us through a few weeks.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Server Error on Some Searches (Limit set at 50 results)’ is closed to new replies.