# Tables not available to edit? \[Apr 13\]

**URL:** <https://community.nocodb.com/t/tables-not-available-to-edit-apr-13/361>\
**Category:** Discord-Discussions\
**Created:** [November 3, 2022, 8:56am UTC](https://community.nocodb.com/t/tables-not-available-to-edit-apr-13/361 "2022-11-03T08:56:12Z")\
**Posts on this page:** 15\
**Page:** 1

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 8:56am UTC](https://community.nocodb.com/t/tables-not-available-to-edit-apr-13/361/1 "2022-11-03T08:56:12Z")

</div>

[dummy title body text appended to avoid empty title body]

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 8:56am UTC](https://community.nocodb.com/t/tables-not-available-to-edit-apr-13/361/2 "2022-11-03T08:56:13Z")

</div>

> 🙋‍♂️ **scottrepreneur** _replied_

#### I’ve got a kinda funky issue where I can’t see 2/7 of my tables that are freshly created and fairly simple.

#### 

#### I’m seeing them here in the metadata but not sure why they aren’t showing in UI Access Control, et al.

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 8:56am UTC](https://community.nocodb.com/t/tables-not-available-to-edit-apr-13/361/3 "2022-11-03T08:56:14Z")

</div>

> 🙋‍♂️ **scottrepreneur** _replied_

#### Comments is one of the two tables that aren’t showing up.

 ![image0](https://canada1.discourse-cdn.com/flex011/uploads/nocodb/original/1X/44dd870251a8cccc3cf002f5ffd3824e6b6f90d1.png)

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 8:56am UTC](https://community.nocodb.com/t/tables-not-available-to-edit-apr-13/361/4 "2022-11-03T08:56:16Z")

</div>

> 🙋‍♂️ **scottrepreneur** _replied_

#### However doesn’t appear in UI Access Control form

 ![image0](https://canada1.discourse-cdn.com/flex011/uploads/nocodb/original/1X/d920f0390ab52ef30a415ab8c07975371d590a71.png)

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 8:56am UTC](https://community.nocodb.com/t/tables-not-available-to-edit-apr-13/361/5 "2022-11-03T08:56:17Z")

</div>

> 🙋‍♂️ **scottrepreneur** _replied_

#### Comments is a small table with a varchar column and two foreign keys relating to raids & members. The other missing table is also a couple foreign keys.

#### 

#### Is there a next step I can look at to debug here? Something awry with the table set up?

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 8:56am UTC](https://community.nocodb.com/t/tables-not-available-to-edit-apr-13/361/6 "2022-11-03T08:56:18Z")

</div>

> 🙋‍♂️ **scottrepreneur** _replied_

#### Attempting to create the comments table in Noco gives a `relation "comments" already exists` error which makes sense.

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 8:56am UTC](https://community.nocodb.com/t/tables-not-available-to-edit-apr-13/361/7 "2022-11-03T08:56:19Z")

</div>

> 💁 **o1lab** _replied_

#### [https://docs.nocodb.com/setup-and-usages/sync-schema](https://docs.nocodb.com/setup-and-usages/sync-schema)

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 8:56am UTC](https://community.nocodb.com/t/tables-not-available-to-edit-apr-13/361/8 "2022-11-03T08:56:20Z")

</div>

> 🙋‍♂️ **scottrepreneur** _replied_

#### Thanks! I have run sync and it’s showing me tables are synced currently

 ![image0](https://canada1.discourse-cdn.com/flex011/uploads/nocodb/original/1X/c089c5239b6235aa316d6cfefa4a3cbf209b79ff.png)

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 8:56am UTC](https://community.nocodb.com/t/tables-not-available-to-edit-apr-13/361/9 "2022-11-03T08:56:21Z")

</div>

> 🙋‍♂️ **scottrepreneur** _replied_

#### Sorry I feel like I’m not able to give very good data here to help. I’m not seeing any errors in the console.

#### I exported the nc metadata and pulled out the missing models here. Not sure if this is helpful. Enabled looks good and the other.

#### 

#### The current schema was created via SQL outside noco before initial setup & project connection.

[nc\_models\_missing.json](https://cdn.discordapp.com/attachments/962731112679997512/963179077588635788/nc_models_missing.json)

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 8:56am UTC](https://community.nocodb.com/t/tables-not-available-to-edit-apr-13/361/10 "2022-11-03T08:56:23Z")

</div>

> 💁 **o1lab** _replied_

#### It’s a bit surprising to see ncacl and ncapitokens from the image

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 8:56am UTC](https://community.nocodb.com/t/tables-not-available-to-edit-apr-13/361/11 "2022-11-03T08:56:24Z")

</div>

> 💁 **o1lab** _replied_

#### Something is off with setup

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 8:56am UTC](https://community.nocodb.com/t/tables-not-available-to-edit-apr-13/361/12 "2022-11-03T08:56:25Z")

</div>

> 💁 **o1lab** _replied_

#### Would you like to recreate the project connecting to your database?

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 8:56am UTC](https://community.nocodb.com/t/tables-not-available-to-edit-apr-13/361/13 "2022-11-03T08:56:26Z")

</div>

> 🙋‍♂️ **scottrepreneur** _replied_

#### yeah i’ve tried recreating. I’m using docker so I dumped the whole system previously also. When I spin up a fresh project and check out the metadata this is what I’m seeing.

 ![image0](https://canada1.discourse-cdn.com/flex011/uploads/nocodb/original/1X/b2e146d2555111a7365cc6ab98b8e88155fa7eff.png)

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 8:56am UTC](https://community.nocodb.com/t/tables-not-available-to-edit-apr-13/361/14 "2022-11-03T08:56:28Z")

</div>

> 🙋‍♂️ **scottrepreneur** _replied_

#### Ah. I am seeing this error after creating the new project

#### ```

#### dm\_noco | POST /dashboard/?q=sqlOp\_testConnection&skipProjectHasDb=1 200 33 - 11.677 ms

#### dm\_noco | select “roles” from “nc\_projects\_users” where “user\_id” = 1 and ((“roles” like ‘%creator%’) or (“roles” like ‘%owner%’))

#### dm\_noco | Creating GraphQL APIs pg - \> dungeon-master

#### dm\_noco | select \* from “nc\_models” where “project\_id” = ‘dm\_2\_pjz8’ and “db\_alias” = ‘db’

#### dm\_noco | select “ur”, “tn”, “\_tn”, “cn”, “\_cn”, “rtn”, “rcn”, “\_rcn”, “\_rtn”, “type”, “db\_type”, “dr”, “fkn” from “nc\_relations” where “project\_id” = ‘dm\_2\_pjz8’ and “db\_alias” = ‘db’

#### dm\_noco | select \* from “nc\_relations” where “project\_id” = ‘dm\_2\_pjz8’ and “db\_alias” = ‘db’

#### dm\_noco | select \* from “nc\_hooks” where “project\_id” = ‘dm\_2\_pjz8’ and “db\_alias” = ‘db’

#### dm\_noco | select \* from “nc\_models” where “project\_id” = ‘dm\_2\_pjz8’ and “db\_alias” = ‘db’ and “show\_as” = ‘form’

#### dm\_noco | Error: Field “Members.RaidsMMList” can only be defined once.

#### dm\_noco |

#### dm\_noco | Field “Raids.MembersMMList” can only be defined once.

#### dm\_noco | at assertValidSDL (/usr/src/app/node\_modules/graphql/validation/validate.js:107:11)

#### dm\_noco | at buildASTSchema (/usr/src/app/node\_modules/graphql/utilities/buildASTSchema.js:45:34)

#### dm\_noco | at buildSchema (/usr/src/app/node\_modules/graphql/utilities/buildASTSchema.js:112:10)

#### dm\_noco | at GqlApiBuilder.initGraphqlRoute (/usr/src/app/docker/main.js:2:207302)

#### dm\_noco | at processTicksAndRejections (internal/process/task\_queues.js:97:5)

#### dm\_noco | at async GqlApiBuilder.loadResolvers (/usr/src/app/docker/main.js:2:173014)

#### dm\_noco | at async GqlApiBuilder.init (/usr/src/app/docker/main.js:2:170590)

#### dm\_noco | at async s.init (/usr/src/app/docker/main.js:2:150944)

#### dm\_noco | at async o.listener (/usr/src/app/docker/main.js:2:33987)

#### dm\_noco | at async o.handleRequest (/usr/src/app/docker/main.js:2:92391)

#### dm\_noco | select \* from “nc\_cron” where “project\_id” = ‘’ and “db\_alias” = ‘db’

#### dm\_noco | POST /dashboard/?q=sqlOp\_projectCreateByWeb&skipProjectHasDb=1 200 1261 - 667.786 ms

#### dm\_noco | GET /dashboard/auth/type 304 - - 2.972 ms

#### dm\_noco | GET /nc/dm\_2\_pjz8/projectApiInfo 200 502 - 6.013 ms

#### ```

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 8:56am UTC](https://community.nocodb.com/t/tables-not-available-to-edit-apr-13/361/15 "2022-11-03T08:56:29Z")

</div>

[Autogenerated from discord](https://discord.com/channels/661905455894888490/962731112679997512)

* * *

#### Join [NocoDB’s](http://www.nocodb.com/) community

[Discord](https://discord.gg/5RgZmkW) • [Twitter](https://twitter.com/nocodb) • [Reddit](https://www.reddit.com/r/NocoDB/) • [Docs](https://docs.nocodb.com/)
