Jonny007-MKD

I did more research. This is one $query put into PMA:

INSERT IGNORE INTO wp_relevanssi( doc, term, content, title,
COMMENT , tag, link, author, category, excerpt, taxonomy, customfield,
TYPE , taxonomy_detail, customfield_detail, mysqlcolumn )
VALUES ( 13, ‘image1’, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, ‘attachment’, ”, ”, 0 ) , ( 13, ‘300×262’, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, ‘attachment’, ”, ”, 0 )

MySQL said: Documentation
#1054 – Unknown column ‘content’ in ‘field list’

which is correct because wp_relevanssi only contains the fields:

• id => mediumint(9)
• doc => bigint(20)
• term => varchar(50)
• tf => mediumint(9)
• title => tinyint(1)

Maybe you did not alter the table after an update, because your init.php contains the “CREATE TABLE $relevanssi_table” with all this fields.

Two things to do: Telling the user that an error occured while indexing (also printing the wp_query->error or something), altering the table when the tables are in an old version.

Also two ways for users as solution:

1. I would say that reinstalling the plugin would solve the problem, but I don’t want to loose my config.
2. Another way is to execute the MySQL-Commands as is, for example in PMA or with a PHP-Script which works with wp_query():
   

   RENAME TABLE PREFIX_wp_relevanssi TO PREFIX_wp_relevanssi_backup

   if you think you could need a backup.

   CREATE TABLE PREFIX_wp_relevanssi (doc bigint(20) NOT NULL DEFAULT ‘0’,
   term varchar(50) NOT NULL DEFAULT ‘0’,
   content mediumint(9) NOT NULL DEFAULT ‘0’,
   title mediumint(9) NOT NULL DEFAULT ‘0’,
   comment mediumint(9) NOT NULL DEFAULT ‘0’,
   tag mediumint(9) NOT NULL DEFAULT ‘0’,
   link mediumint(9) NOT NULL DEFAULT ‘0’,
   author mediumint(9) NOT NULL DEFAULT ‘0’,
   category mediumint(9) NOT NULL DEFAULT ‘0’,
   excerpt mediumint(9) NOT NULL DEFAULT ‘0’,
   taxonomy mediumint(9) NOT NULL DEFAULT ‘0’,
   customfield mediumint(9) NOT NULL DEFAULT ‘0’,
   mysqlcolumn mediumint(9) NOT NULL DEFAULT ‘0’,
   taxonomy_detail longtext NOT NULL,
   customfield_detail longtext NOT NULL,
   mysqlcolumn_detail longtext NOT NULL,
   type varchar(210) NOT NULL DEFAULT ‘post’,
   item bigint(20) NOT NULL DEFAULT ‘0’,
   UNIQUE KEY doctermitem (doc, term, item)) COLLATE utf8_general_ci

   Change strong text as applicable (PREFIX most of the times does not exist, collation can be looked up at the old table)

greetz
Jonny007

Hello,
I’ve got the same problem.
$insert_data is not empty and neither is $query at the line you’ve mentioned. (its a lot of data thats coming out)
However there remain 0 entries in the index.

of course i didn’t use “email@domain” in particular but a real and valid mail addresss.

greetz

I now deactivated all plugins and reactivated them again and know it works ??
maybe it was some kind of configuration that did this.

Thanks!

greetz
Jonny007

Yes, searching for themes works.
Also the action of the form element is correct (“”)

greetz
Jonny007

Well,
in fact it definitely looks like this. I haven’t the original source anymore, but it was like
<a href="mailto:<span title=">email(Replace this parenthesis with the @ sign)domian">email@domain</a>