# The data explorer is only available to admins

**URL:** https://meta.discourse.org/t/the-data-explorer-is-only-available-to-admins/94801
**Category:** Feature
**Tags:** data-explorer
**Created:** [August 15, 2018, 2:59pm UTC](https://meta.discourse.org/t/the-data-explorer-is-only-available-to-admins/94801 "2018-08-15T14:59:03Z")
**Posts on this page:** 11
**Page:** 1

<div class="post-metadata">

### Author: ![alex56](https://avatars.discourse-cdn.com/v4/letter/a/ce73a5/32.png) [@alex56](https://meta.discourse.org/u/alex56)
#### Post date: [August 15, 2018, 2:59pm UTC](https://meta.discourse.org/t/the-data-explorer-is-only-available-to-admins/94801/1 "2018-08-15T14:59:03Z")

</div>

After update our forum we got the following message on the data-explorer plugin

## The [data explorer](https://meta.discourse.org/t/32566?silent=true) is only available to admins.

Could you please help us to fix an issue

---

<div class="post-metadata">

### Author: ![pfaffman](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/pfaffman/32/120154_2.png) [@pfaffman](https://meta.discourse.org/u/pfaffman)
#### Post date: [August 15, 2018, 3:10pm UTC](https://meta.discourse.org/t/the-data-explorer-is-only-available-to-admins/94801/2 "2018-08-15T15:10:02Z")

</div>

I just did an upgrade and don’t have this problem. Are you sure that the user trying to access data-explorer is an admin?

---

<div class="post-metadata">

### Author: ![alex56](https://avatars.discourse-cdn.com/v4/letter/a/ce73a5/32.png) [@alex56](https://meta.discourse.org/u/alex56)
#### Post date: [August 15, 2018, 3:15pm UTC](https://meta.discourse.org/t/the-data-explorer-is-only-available-to-admins/94801/3 "2018-08-15T15:15:37Z")

</div>

Sure. I have admin permission

 ![image](https://global.discourse-cdn.com/meta/original/3X/d/b/dbc340aad3bf537fe770b5e205c7e0f0a17a4460.png)

---

<div class="post-metadata">

### Author: ![sam](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/sam/32/102149_2.png) [@sam](https://meta.discourse.org/u/sam)
#### Post date: [August 16, 2018, 12:46am UTC](https://meta.discourse.org/t/the-data-explorer-is-only-available-to-admins/94801/4 "2018-08-16T00:46:57Z")

</div>

I have seen this bug due to the rate limiter… if you wait 10 seconds and reload the page does [data explorer](https://meta.discourse.org/t/32566?silent=true) show up.

---

<div class="post-metadata">

### Author: ![alex56](https://avatars.discourse-cdn.com/v4/letter/a/ce73a5/32.png) [@alex56](https://meta.discourse.org/u/alex56)
#### Post date: [August 16, 2018, 8:24am UTC](https://meta.discourse.org/t/the-data-explorer-is-only-available-to-admins/94801/5 "2018-08-16T08:24:09Z")

</div>

I did it but not luck

---

<div class="post-metadata">

### Author: ![manuel](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/manuel/32/468169_2.png) [@manuel](https://meta.discourse.org/u/manuel)
#### Post date: [September 25, 2020, 5:44pm UTC](https://meta.discourse.org/t/the-data-explorer-is-only-available-to-admins/94801/19 "2020-09-25T17:44:30Z")

</div>

I’m getting this same error. I’m running 2.6.0.beta2 as development version.

When I enable the plugin and try to access it at /admin/plugins/explorer, I get this console message:

> Warning: no type cast defined for type “name” with oid 19. Please cast this type explicitly to TEXT to be safe for future changes.

---

<div class="post-metadata">

### Author: ![pfaffman](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/pfaffman/32/120154_2.png) [@pfaffman](https://meta.discourse.org/u/pfaffman)
#### Post date: [September 26, 2020, 1:38pm UTC](https://meta.discourse.org/t/the-data-explorer-is-only-available-to-admins/94801/20 "2020-09-26T13:38:59Z")

</div>

Have you upgraded to pg12?

Have you migrated the database?

---

<div class="post-metadata">

### Author: ![manuel](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/manuel/32/468169_2.png) [@manuel](https://meta.discourse.org/u/manuel)
#### Post date: [September 27, 2020, 10:57am UTC](https://meta.discourse.org/t/the-data-explorer-is-only-available-to-admins/94801/21 "2020-09-27T10:57:27Z")

</div>

No, I didn’t change anything.

In fact, I just installed a new instance ( 2.6.0.beta3 / docker 19.03.13 / on Debian bullseye) and get the warning right away when running `d/rake autospec` or trying to access the plugin. I don’t know if it’s related in any way, but that’s the only warning i see.

---

<div class="post-metadata">

### Author: ![riking](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/riking/32/170938_2.png) [@riking](https://meta.discourse.org/u/riking)
#### Post date: [October 29, 2020, 2:16pm UTC](https://meta.discourse.org/t/the-data-explorer-is-only-available-to-admins/94801/23 "2020-10-29T14:16:48Z")

</div>

Taking a look, the “The [data explorer](https://meta.discourse.org/t/32566?silent=true) is only available to admins.” message shows up for _any_ error encountered while loading up the page.

[https://github.com/discourse/discourse-data-explorer/blob/master/assets/javascripts/discourse/routes/admin-plugins-explorer.js.es6#L33-L37](https://github.com/discourse/discourse-data-explorer/blob/master/assets/javascripts/discourse/routes/admin-plugins-explorer.js.es6#L33-L37)

This was sensible when there was a very small list of things that could go wrong, but the fix here is probably better clientside error reporting.

---

<div class="post-metadata">

### Author: ![riking](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/riking/32/170938_2.png) [@riking](https://meta.discourse.org/u/riking)
#### Post date: [December 7, 2020, 10:59pm UTC](https://meta.discourse.org/t/the-data-explorer-is-only-available-to-admins/94801/25 "2020-12-07T22:59:59Z")

</div>

> [@riking](#):
>
> This was sensible when there was a very small list of things that could go wrong, but the fix here is probably better clientside error reporting.

Change is up - the existing text is now triggered by an explicit check of admin permissions, and standard error handling is used for any failed requests.

[https://github.com/discourse/discourse-data-explorer/pull/84/files](https://github.com/discourse/discourse-data-explorer/pull/84/files)

---

<div class="post-metadata">

### Author: ![riking](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/riking/32/170938_2.png) [@riking](https://meta.discourse.org/u/riking)
#### Post date: [December 10, 2020, 8:00am UTC](https://meta.discourse.org/t/the-data-explorer-is-only-available-to-admins/94801/26 "2020-12-10T08:00:13Z")

</div>

This topic was automatically closed after 2 days. New replies are no longer allowed.
