DB import fails with “Duplicate entry for key ‘doctermitem'”

  • Hi,

    I exported a copy of a site’s db using wp-cli that is using Relevanssi so I could work on a feature change in my local dev environment. When I tried to import the db export, it failed with this message:

    ERROR 1062 (23000) at line 637; Duplicate entry '6459-???????-0' for key 'doctermitem'

    I’ve identified this as a key in the wp_relevanssi table. What might be causing this db corruption? Do you have suggestions for fixing?

    Thanks,

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

    (@msaari)

    That’s not corruption; that’s just text in a character set your database doesn’t understand. Make sure both databases are using the same character set and collation.

    In any case, there’s really no need to migrate the wp_relevanssi table, as it’s big and the contents are easy to generate on the dev site.

Viewing 1 replies (of 1 total)
  • The topic ‘DB import fails with “Duplicate entry for key ‘doctermitem'”’ is closed to new replies.