• I mistakenly posted this to the wrong place (general forum). Moving here for specific attention:

    After updating to Relevanssi 3.1.6 (not sure from which version, we skipped a few minor ones), our site has the error “Unknown column ‘term_reverse’ in ‘field list'”

    That missing column name is traceable to the Relevanssi plugin. In the case of the error it’s called in our AJAX’d search results via ‘relevanssi_insert_edit()’. I don’t have specific line numbers and haven’t dug into the code yet. But if it helps, here’s the stack trace of the error:

    in mysql_query called at /usr/share/nginx/www/wp-includes/wp-db.php (1200)
    … called at /usr/share/nginx/www/wp-content/plugins/relevanssi/lib/indexing.php (397)
    … called at /usr/share/nginx/www/wp-content/plugins/relevanssi/lib/indexing.php (537)
    … called at /usr/share/nginx/www/wp-content/plugins/relevanssi/lib/indexing.php (561)
    in relevanssi_insert_edit called at ? (?)
    in call_user_func_array called at /usr/share/nginx/www/wp-includes/plugin.php (406)
    in do_action called at /usr/share/nginx/www/wp-includes/post.php (2948)
    in wp_insert_post called at /usr/share/nginx/www/wp-includes/post.php (3003)
    in wp_update_post called at /usr/share/nginx/www/wp-admin/includes/post.php (257)
    in edit_post called at /usr/share/nginx/www/wp-admin/includes/ajax-actions.php (1080)
    in wp_ajax_autosave called at ? (?)
    in call_user_func_array called at /usr/share/nginx/www/wp-includes/plugin.php (406)
    in do_action called at /usr/share/nginx/www/wp-admin/admin-ajax.php (72)

    This error appears to be causing a memory leak and some minor performance issues on our servers. Any chance you can patch it up? I’d be happy to help with additional debugging info or even get into the code if you take code submissions (Github maybe?).`

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

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

    (@msaari)

    Do a deactivate-reactivate for the plugin, and it should work just fine. The latest update added a new database column.

Viewing 1 replies (of 1 total)
  • The topic ‘PHP errors from plugin, looking for non-existent DB column’ is closed to new replies.