wp_relevanssi_stopwords doesn’t exist for query

  • Hello,

    After a fresh install of relevanssi, I started getting this errors on my log

    WordPress database error Table ‘blog.wp_relevanssi_stopwords’ doesn’t exist for query INSERT IGNORE INTO wp_relevanssi_stopwords (stopword) VALUES (‘the’) made by activate_plugin, do_action(‘activate_relevanssi/relevanssi.php’), call_user_func_array, relevanssi_install, _relevanssi_install, relevanssi_create_database_tables, relevanssi_populate_stopwords

    I’ve replicated this, on install but also when a user makes a search query in the search page.
    I have another blog throwing the same errors. I manually updated the plugin and de-activated/activated in the backend in that case and the error persists.

    Current plugin version is the latest

    • This topic was modified 7 years, 12 months ago by fantasma98.
Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Mikko Saari

    (@msaari)

    Well, do you have the wp_relevanssi_stopwords table in your database? If not, your installation is broken somehow. The easiest solution for this would be to create the table manually.

    Thread Starter fantasma98

    (@fantasma98)

    Hi Mikko,

    In fact I haven’t. But I tried to re-install the plugin (mannually. strict company rules prevent me from doing so in the admin tool), and the tables aren’t created.

    Could you provide me with the table signature so I can manually create it?

    Plugin Author Mikko Saari

    (@msaari)

    It has exactly one column, stopword, which is a varchar(50) NOT NULL, and a UNIQUE KEY index called stopword on the stopword column.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘wp_relevanssi_stopwords doesn’t exist for query’ is closed to new replies.