WordPress.org

Ready to get started?Download WordPress

Forums

Relevanssi - A Better Search
[resolved] SQL Error - Quick Editing WooCommerce Products (2 posts)

  1. samueljeden
    Member
    Posted 11 months ago #

    WordPress database error: [Unknown column 'term_reverse' in 'field list']
    INSERT IGNORE INTO 4fi_relevanssi (doc, term, term_reverse, content, title, comment, tag, link, author, category, excerpt, taxonomy, customfield, type, taxonomy_detail, customfield_detail, mysqlcolumn) VALUES (5175, 'simple', REVERSE('simple'), 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 'post', 'a:1:{s:12:\"product_type\";i:1;}', '', 0), (5175, 'toggle', REVERSE('toggle'), 1, 0, 0, 0, 0, 0, 0, 0, 1, 0, 'post', 'a:1:{s:11:\"product_cat\";i:1;}', '', 0), (5175, 'switches', REVERSE('switches'), 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 'post', 'a:1:{s:11:\"product_cat\";i:1;}', '', 0), (5175, '1368800055', REVERSE('1368800055'), 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 'post', '', '', 0), (5175, '5176', REVERSE('5176'), 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 'post', '', '', 0), (5175, 'visible', REVERSE('visible'), 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 'post', '', '', 0), (5175, 'instock', REVERSE('instock'), 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 'post', '', '', 0), (5175, '53', REVERSE('53'), 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 'post', '', '', 0), (5175, 'taxable', REVERSE('taxable'), 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 'post', '', '', 0), (5175, 'g-sw45', REVERSE('g-sw45'), 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 'post', '', '', 0), (5175, 'hidden', REVERSE('hidden'), 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 'post', '', '', 0), (5175, 'keywords', REVERSE('keywords'), 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 'post', '', '', 0), (5175, '036411', REVERSE('036411'), 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 'post', '', '', 0), (5175, '0-364-11', REVERSE('0-364-11'), 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 'post', '', '', 0), (5175, 'sw45', REVERSE('sw45'), 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'post', '', '', 0), (5175, 'lucas', REVERSE('lucas'), 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'post', '', '', 0), (5175, 'type', REVERSE('type'), 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'post', '', '', 0), (5175, 'heavy', REVERSE('heavy'), 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'post', '', '', 0), (5175, 'duty', REVERSE('duty'), 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'post', '', '', 0), (5175, 'switch', REVERSE('switch'), 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'post', '', '', 0), (5175, 'spb200', REVERSE('spb200'), 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'post', '', '', 0), (5175, 'metal', REVERSE('metal'), 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'post', '', '', 0), (5175, 'lucar', REVERSE('lucar'), 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'post', '', '', 0), (5175, 'terminals', REVERSE('terminals'), 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'post', '', '', 0), (5175, 'plastic', REVERSE('plastic'), 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'post', '', '', 0), (5175, 'lever', REVERSE('lever'), 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'post', '', '', 0), (5175, '12', REVERSE('12'), 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'post', '', '', 0), (5175, 'volt', REVERSE('volt'), 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'post', '', '', 0), (5175, 'rated', REVERSE('rated'), 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'post', '', '', 0), (5175, '10', REVERSE('10'), 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'post', '', '', 0), (5175, 'amps', REVERSE('amps'), 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'post', '', '', 0), (5175, '24', REVERSE('24'), 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'post', '', '', 0)

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

  2. samueljeden
    Member
    Posted 11 months ago #

    Needed to deactivate and reactive.
    My Bad!

Reply

You must log in to post.

About this Plugin

About this Topic

Tags

No tags yet.