# Dubbele data explorer sleutel blokkeert rebuild

**URL:** https://meta.discourse.org/t/duplicate-data-explorer-key-blocking-rebuild/162375
**Category:** Support
**Created:** [28 augustus 2020 om 18:38 UTC](https://meta.discourse.org/t/duplicate-data-explorer-key-blocking-rebuild/162375 "2020-08-28T18:38:50Z")
**Posts on this page:** 1
**Showing post:** 4

<div class="post-metadata">

### Author: ![merefield](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/merefield/32/176214_2.png) [@merefield](https://meta.discourse.org/u/merefield)
#### Post date: [28 augustus 2020 om 19:04 UTC](https://meta.discourse.org/t/duplicate-data-explorer-key-blocking-rebuild/162375/4 "2020-08-28T19:04:52Z")

</div>

OK if I simplify this to:

`select * from plugin_store_rows WHERE plugin_name = 'discourse-data-explorer' AND type_name = 'JSON' AND (replace(key, 'q:',''))::integer < 0;`

That brings back 2 identical rows (bar ‘id’).

I guess I should be brave and delete one!

PS Done, deleted the newer record - rebuilding

(Used `DELETE from plugin_store_rows WHERE id = $$$the duplicate records id$$$;`)

MIGRATION NOW WORKED!

Thanks for push @Falco

---

_[View the full topic](https://meta.discourse.org/t/duplicate-data-explorer-key-blocking-rebuild/162375)._