# Many-to-Many relationship creation \[Feb 10\]
**URL:** https://community.nocodb.com/t/many-to-many-relationship-creation-feb-10/228
**Category:** Discord-Discussions
**Created:** [November 3, 2022, 8:06am UTC](https://community.nocodb.com/t/many-to-many-relationship-creation-feb-10/228 "2022-11-03T08:06:00Z")
**Posts on this page:** 19
**Page:** 1
### Author:  [@NocoDB](https://community.nocodb.com/u/NocoDB)
#### Post date: [November 3, 2022, 8:06am UTC](https://community.nocodb.com/t/many-to-many-relationship-creation-feb-10/228/1 "2022-11-03T08:06:00Z")
> πββοΈ **7rozen\_7ear\_** _asked_
## It seems like updates can break many-to-many relationships. At least it one might have become broken last night on Heroku. Is this a known issue?
---
### Author:  [@NocoDB](https://community.nocodb.com/u/NocoDB)
#### Post date: [November 3, 2022, 8:06am UTC](https://community.nocodb.com/t/many-to-many-relationship-creation-feb-10/228/2 "2022-11-03T08:06:01Z")
> π¨βπ» **pranavxc** _replied_
#### hi, does creation of m2m relation caused the problem ?
#
---
### Author:  [@NocoDB](https://community.nocodb.com/u/NocoDB)
#### Post date: [November 3, 2022, 8:06am UTC](https://community.nocodb.com/t/many-to-many-relationship-creation-feb-10/228/3 "2022-11-03T08:06:02Z")
> π¨βπ» **pranavxc** _replied_
#### can you share more details ?
#
---
### Author:  [@NocoDB](https://community.nocodb.com/u/NocoDB)
#### Post date: [November 3, 2022, 8:06am UTC](https://community.nocodb.com/t/many-to-many-relationship-creation-feb-10/228/4 "2022-11-03T08:06:04Z")
> πββοΈ **7rozen\_7ear\_** _replied_
#### Iβd gladly share more details!
####
#### First of all, this is a free deploy on Heroku.
####
#### So: basically this was up and running quite smoothly for a while. But Iβve noticed two things:
#### \* Names of Has Many-columns and M2M-columns donβt persist;
#### \* Some M2M-relationships but not all of them broke after a while. It might have something to do with a NocoDB upgrade on Herokuβs servers. After closer inspection I saw that this M2M-relationship lacks a column, as all columns are visible in the screenshot. As you can see, thereβs only one Has Many-relationship in the auxiliary M2M-table.
#
---
### Author:  [@NocoDB](https://community.nocodb.com/u/NocoDB)
#### Post date: [November 3, 2022, 8:06am UTC](https://community.nocodb.com/t/many-to-many-relationship-creation-feb-10/228/5 "2022-11-03T08:06:05Z")
> πββοΈ **7rozen\_7ear\_** _replied_
#### Iβm going to host a NocoDB-instance on my own using MySQL in order to rule out e.g. issues with SQLite.
#
---
### Author:  [@NocoDB](https://community.nocodb.com/u/NocoDB)
#### Post date: [November 3, 2022, 8:06am UTC](https://community.nocodb.com/t/many-to-many-relationship-creation-feb-10/228/6 "2022-11-03T08:06:06Z")
> πββοΈ **7rozen\_7ear\_** _replied_
#### Any more information youβd like to know?
#
---
### Author:  [@NocoDB](https://community.nocodb.com/u/NocoDB)
#### Post date: [November 3, 2022, 8:06am UTC](https://community.nocodb.com/t/many-to-many-relationship-creation-feb-10/228/7 "2022-11-03T08:06:07Z")
> π¨βπ» **pranavxc** _replied_
#### ok⦠so the problem happened after migration, right ?
#
---
### Author:  [@NocoDB](https://community.nocodb.com/u/NocoDB)
#### Post date: [November 3, 2022, 8:06am UTC](https://community.nocodb.com/t/many-to-many-relationship-creation-feb-10/228/8 "2022-11-03T08:06:08Z")
> π¨βπ» **pranavxc** _replied_
#### Any change did you done after migration ?
#
---
### Author:  [@NocoDB](https://community.nocodb.com/u/NocoDB)
#### Post date: [November 3, 2022, 8:06am UTC](https://community.nocodb.com/t/many-to-many-relationship-creation-feb-10/228/9 "2022-11-03T08:06:09Z")
> π¨βπ» **pranavxc** _replied_
#### And how did you migrated to latest version ?
#
---
### Author:  [@NocoDB](https://community.nocodb.com/u/NocoDB)
#### Post date: [November 3, 2022, 8:06am UTC](https://community.nocodb.com/t/many-to-many-relationship-creation-feb-10/228/10 "2022-11-03T08:06:10Z")
> πββοΈ **7rozen\_7ear\_** _replied_
#### The migration is an assumption, as Heroku gave me a notification of a new release. I actually left this project unattended for a week.
#
---
### Author:  [@NocoDB](https://community.nocodb.com/u/NocoDB)
#### Post date: [November 3, 2022, 8:06am UTC](https://community.nocodb.com/t/many-to-many-relationship-creation-feb-10/228/11 "2022-11-03T08:06:11Z")
> π¨βπ» **pranavxc** _replied_
#### okkk
#
---
### Author:  [@NocoDB](https://community.nocodb.com/u/NocoDB)
#### Post date: [November 3, 2022, 8:06am UTC](https://community.nocodb.com/t/many-to-many-relationship-creation-feb-10/228/12 "2022-11-03T08:06:12Z")
> π¨βπ» **pranavxc** _replied_
#### does anyone manullay deleted one of the relation in that m2m table?
#
---
### Author:  [@NocoDB](https://community.nocodb.com/u/NocoDB)
#### Post date: [November 3, 2022, 8:06am UTC](https://community.nocodb.com/t/many-to-many-relationship-creation-feb-10/228/13 "2022-11-03T08:06:13Z")
> π¨βπ» **pranavxc** _replied_
#### thanks, we will try to reproduce the problem. If you could able reproduce the problem again let us know the steps as well.
#
---
### Author:  [@NocoDB](https://community.nocodb.com/u/NocoDB)
#### Post date: [November 3, 2022, 8:06am UTC](https://community.nocodb.com/t/many-to-many-relationship-creation-feb-10/228/14 "2022-11-03T08:06:15Z")
> π **o1lab** _replied_
#### at the moment its not clear what the issue is from the description.
#
---
### Author:  [@NocoDB](https://community.nocodb.com/u/NocoDB)
#### Post date: [November 3, 2022, 8:06am UTC](https://community.nocodb.com/t/many-to-many-relationship-creation-feb-10/228/15 "2022-11-03T08:06:16Z")
> πββοΈ **7rozen\_7ear\_** _replied_
#### No, I just logged back in and the relation was broken. Iβve literaly not touched it for a week and only opened the M2M-tables for the screenshot.
#
---
### Author:  [@NocoDB](https://community.nocodb.com/u/NocoDB)
#### Post date: [November 3, 2022, 8:06am UTC](https://community.nocodb.com/t/many-to-many-relationship-creation-feb-10/228/16 "2022-11-03T08:06:17Z")
> π¨βπ» **pranavxc** _replied_
#### ok
#
---
### Author:  [@NocoDB](https://community.nocodb.com/u/NocoDB)
#### Post date: [November 3, 2022, 8:06am UTC](https://community.nocodb.com/t/many-to-many-relationship-creation-feb-10/228/17 "2022-11-03T08:06:18Z")
> πββοΈ **7rozen\_7ear\_** _replied_
#### If I find a way to consistently reproduce this, Iβll let you know!
#
---
### Author:  [@NocoDB](https://community.nocodb.com/u/NocoDB)
#### Post date: [November 3, 2022, 8:06am UTC](https://community.nocodb.com/t/many-to-many-relationship-creation-feb-10/228/18 "2022-11-03T08:06:19Z")
> π¨βπ» **pranavxc** _replied_
#### Sure thanks, that will help us to figure out the root cause π
#
---
### Author:  [@NocoDB](https://community.nocodb.com/u/NocoDB)
#### Post date: [November 3, 2022, 8:06am UTC](https://community.nocodb.com/t/many-to-many-relationship-creation-feb-10/228/19 "2022-11-03T08:06:20Z")
[Autogenerated from discord](https://discord.com/channels/661905455894888490/940881553259651112)
* * *
#### 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/)