Ahmed Osama
12/23/2021, 9:23 AMError validating: A self-relation must have `onDelete` and `onUpdate` referential actions set to `NoAction` in one of the @relation attributes. (Implicit default `onDelete`: `SetNull`, and `onUpdate`: `Cascade`) Read more at <https://pris.ly/d/cyclic-referential-actions>
I am using mysql with planetscale
datasource db {
provider = "mysql"
url = env("DATABASE_URL")
referentialIntegrity = "prisma"
}
generator client {
provider = "prisma-client-js"
previewFeatures = ["referentialIntegrity"]
}
I am receiving the error on all relations (not only self-relations) which is weird. Also, the link given doesn't mention mysql (only mongodb and sql server)
The error was not there before, It showed up out of nowhere.Joël