Relevanssi: index and imageproblem

I receive a large list that includes string(4) “ID”

For example:

string(4) “3034”

I’m going to dig deeper into the database. We recently brought our live database down to our dev environment so that they were the same. I wonder if there was an issue that occurred in that migration.

It should print out the number of rows affected in each query, and that should be 1 for each query (as they are simple INSERT queries).

Do check that the database tables are intact and correct. The indexing clearly processes the entries, but for some reason the entries don’t go into the database.

You could try enabling MySQL errors by adding $wpdb->show_errors(); to the function.

One thing I should point out is that there are a ton of breaks before each entry, 287 to be exact. Our site has around 400 pages + posts.

Where in your function should I add show_errors?

Anywhere before the INSERT queries.

Nice work msaari, thanks for your help. I’m singning of for this thread.

It turns out it was a database permissions issue. The plugin didn’t have permission to create the table. It’s all fixed now.

Thanks for your help, msaari.

Good, glad you got that sorted out and thanks for giving me material for another Relevanssi Knowledge Base article =)

Msaari, I am having the same problem with it not indexing, so I tried your trick on line 1815 to list the post IDs, but it didn’t return any. The plugin HAS successfully created the Relevanssi database tables. Any thoughts off the top of your head what could be causing that behavior? I’ve done the basic troubleshooting of disabling all other plugins to no avail.

If you have the latest version, the var_dump() needs to be added on line 1876. If you get no results even though the code is in the right place, then… hard to say.