WordPress.org

Ready to get started?Download WordPress

Forums

Relevanssi - A Better Search
Server Error on Some Searches (Limit set at 50 results) (6 posts)

  1. nickgassmann
    Member
    Posted 10 months ago #

    So a search of "?s=Orchestra+2013" will give us a server error, however, a search of ?s=Lower+School+Orchestra returns results.

    Any idea what may be causing this?

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

  2. Mikko Saari
    Member
    Plugin Author

    Posted 10 months ago #

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

  3. nickgassmann
    Member
    Posted 10 months ago #

    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.

  4. nickgassmann
    Member
    Posted 10 months ago #

    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
  5. Mikko Saari
    Member
    Plugin Author

    Posted 10 months ago #

    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.

  6. nickgassmann
    Member
    Posted 10 months ago #

    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.

Reply

You must log in to post.

About this Plugin

About this Topic

Tags

No tags yet.