# Table 'nc\_roles' already exists error \[May 20\]

**URL:** <https://community.nocodb.com/t/table-nc-roles-already-exists-error-may-20/471>\
**Category:** Discord-Discussions\
**Created:** [November 3, 2022, 9:50am UTC](https://community.nocodb.com/t/table-nc-roles-already-exists-error-may-20/471 "2022-11-03T09:50:08Z")\
**Posts on this page:** 17\
**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, 9:50am UTC](https://community.nocodb.com/t/table-nc-roles-already-exists-error-may-20/471/1 "2022-11-03T09:50:08Z")

</div>

> 🙋‍♂️ **Alsu** _asked_

## Hello everyone, I am trying to update an image, but I keep getting this error: e[2Je[0fmigration file “project” failed. My RDS is in AWS, and I am using MySQL. Before that final message, I also get migration failed with error: create table `nc_roles` (`id` int unsigned not null auto\_increment primary key, `project_id` varchar(255), `db_alias` varchar(255) default ‘db’, `title` varchar(255), `type` varchar(255) default ‘CUSTOM’, `description` varchar(255), `created_at` datetime, `updated_at` datetime) - Table ‘nc\_roles’ already exists. I tried several times, dropped tables before updating, still gave me the same error with different tables.

---

<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, 9:50am UTC](https://community.nocodb.com/t/table-nc-roles-already-exists-error-may-20/471/2 "2022-11-03T09:50:09Z")

</div>

> 💁 **o1lab** _replied_

#### from what version are you migrating and what is the your NC\_DB variable ?

#

---

<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, 9:50am UTC](https://community.nocodb.com/t/table-nc-roles-already-exists-error-may-20/471/3 "2022-11-03T09:50:10Z")

</div>

> 🙋‍♂️ **Alsu** _replied_

#### I am going from v 0.84.16 to 0.90.11. I am just passing my database name variable.

#

---

<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, 9:50am UTC](https://community.nocodb.com/t/table-nc-roles-already-exists-error-may-20/471/4 "2022-11-03T09:50:11Z")

</div>

> 🙋‍♂️ **Alsu** _replied_

#### on my docker file I put latest, I did not specify numbers, and it went to

#### PackageVersion: **0.84.15**

#

---

<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, 9:50am UTC](https://community.nocodb.com/t/table-nc-roles-already-exists-error-may-20/471/5 "2022-11-03T09:50:13Z")

</div>

> 💁 **o1lab** _replied_

#### may be you have to remove the image from your machine

#

---

<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, 9:50am UTC](https://community.nocodb.com/t/table-nc-roles-already-exists-error-may-20/471/6 "2022-11-03T09:50:14Z")

</div>

> 💁 **o1lab** _replied_

#### it should have picked the latest otherwise

#

---

<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, 9:50am UTC](https://community.nocodb.com/t/table-nc-roles-already-exists-error-may-20/471/7 "2022-11-03T09:50:15Z")

</div>

> 🙋‍♂️ **Alsu** _replied_

#### I am building it with jenkins, and I am cleaning before building it. When I specify which version to update to, it gives me correct one

#

---

<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, 9:50am UTC](https://community.nocodb.com/t/table-nc-roles-already-exists-error-may-20/471/8 "2022-11-03T09:50:16Z")

</div>

> 🙋‍♂️ **Alsu** _replied_

#### removing all system tables (nc\_\*) worked, I was able to pull the latest version

#

---

<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, 9:50am UTC](https://community.nocodb.com/t/table-nc-roles-already-exists-error-may-20/471/9 "2022-11-03T09:50:17Z")

</div>

> 💁 **o1lab** _replied_

#### (deleted it.. since its not advisable to show the NC\_DB 🙂 - I understand some credentialas was redacted .. but yet)

#

---

<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, 9:50am UTC](https://community.nocodb.com/t/table-nc-roles-already-exists-error-may-20/471/10 "2022-11-03T09:50:18Z")

</div>

> 💁 **o1lab** _replied_

#### \> removing all system tables (nc\_\*) worked, I was able to pull the latest version

#### great

#

---

<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, 9:50am UTC](https://community.nocodb.com/t/table-nc-roles-already-exists-error-may-20/471/11 "2022-11-03T09:50:19Z")

</div>

> 🙋‍♂️ **Alsu** _replied_

#### It is still not ideal, because users and projects are gone, but workaround, which requires to insert that data into the new tables manually

#

---

<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, 9:50am UTC](https://community.nocodb.com/t/table-nc-roles-already-exists-error-may-20/471/12 "2022-11-03T09:50:21Z")

</div>

> 💁 **o1lab** _replied_

#### Did you happen to manually fiddle with NC\_DB database (like removing or adding tables or data within) when error happened

#

---

<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, 9:50am UTC](https://community.nocodb.com/t/table-nc-roles-already-exists-error-may-20/471/13 "2022-11-03T09:50:22Z")

</div>

> 💁 **o1lab** _replied_

#### it should automatically role up to the latest version

#

---

<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, 9:50am UTC](https://community.nocodb.com/t/table-nc-roles-already-exists-error-may-20/471/14 "2022-11-03T09:50:23Z")

</div>

> 💁 **o1lab** _replied_

#### the err mentioned was the first time I have seen

#

---

<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, 9:50am UTC](https://community.nocodb.com/t/table-nc-roles-already-exists-error-may-20/471/15 "2022-11-03T09:50:24Z")

</div>

> 🙋‍♂️ **Alsu** _replied_

#### to recap, I faced several issues: 1. pulling latest – pulled v 0.84.15, when I was already in 0.84.16. 2. first time trying to update gave me issue with nc\_projects table – i deleted it, tried again, gave me error in nc\_roles. I deleted all system tables, and pull the latest, it worked, but updated to 0.84.15 version, but specifying which version to update to, creates tables with \_v2 and no more issues.

#

---

<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, 9:50am UTC](https://community.nocodb.com/t/table-nc-roles-already-exists-error-may-20/471/16 "2022-11-03T09:50:25Z")

</div>

> 🙋‍♂️ **Alsu** _replied_

#### thank you for looking into my issues with me!

#

---

<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, 9:50am UTC](https://community.nocodb.com/t/table-nc-roles-already-exists-error-may-20/471/17 "2022-11-03T09:50:26Z")

</div>

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

* * *

#### 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/)