Comma Separated Values Under Pin This Post

  • So, first off, great plugin. Fantastic. I’ve used it for a couple of years now and it is, without doubt, the best Search Plugin out there and well worth paying for premium. Next up is kind of an ask for assistance because I’m dumb, really dumb. Recently I migrated my site content to a new server, manually. We moved 2000+ posts by hand to a new system and were using the basic version of Relevanssi when we did the move. To do it we cloned each post 2000 times and all was good. Then, today, after completing the move I reconfigured Relevanssi premium and discovered that 2000 posts had the same comma-separated list of values under the pin this post option. So… this presents a wee problem if our users search with one o those keywords we repeated because everything is pinned now. I would prefer not to have to go back to manually remove them 2000 times.

    So I’m wondering if there is a way you can suggest to flush them. Maybe a search and replace query for MySQL (if I can figure out where it is storing that info), or perhaps some sort of another fix. Anyway, I greatly appreciate your time and I should also note, I was unsure how to renew my premium support, but would be happy to if it will help get an answer and save me time. I appreciate the work you put in and will happily pay for your efforts.

    I should add, I have a staging server so I can test any potential solutions there.

    Thanks.

    • This topic was modified 2 years, 10 months ago by pixeo.
    • This topic was modified 2 years, 10 months ago by pixeo.

    The page I need help with: [log in to see the link]

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

    (@msaari)

    When you cloned the posts, you cloned all the Relevanssi metadata stored in the custom fields.

    This will remove all the pinning:

    DELETE FROM wp_postmeta WHERE meta_key='_relevanssi_pin' OR meta_key='_relevanssi_pin_keywords'

    However, you may also have other metadata, so it may be useful to wipe off all Relevanssi meta fields:

    DELETE FROM wp_postmeta WHERE meta_key LIKE '_relevanssi_%'

    This will remove all Relevanssi metadata from all posts.

    For more finesse, you can take a look at the wp_postmeta database table and see what you have there, all Relevanssi meta fields begin with _relevanssi.

    You can renew your Relevanssi Premium license here.

Viewing 1 replies (of 1 total)
  • The topic ‘Comma Separated Values Under Pin This Post’ is closed to new replies.