when i adding the background table this happened.

[FARMAN9]

Privileged issue

• I'm @tiangolo or he asked me directly to create an issue here.

Issue Content

sqlalchemy.exc.IntegrityError: (psycopg.errors.NotNullViolation) null value in column "id" violates not-null constraint
backend-1 | DETAIL: Failing row contains ([email protected], t, t, null, $2b$12$O1FGCpDKGwyy6wH6CEA0lOpBAxETlYbAg.ib9av622HcJ/YB1AY1C, null).
backend-1 | [SQL: INSERT INTO "user" (email, is_active, is_superuser, full_name, hashed_password) VALUES (%(email)s::VARCHAR, %(is_active)s, %(is_superuser)s, %(full_name)s::VARCHAR, %(hashed_password)s::VARCHAR) RETURNING "user".id]
backend-1 | [parameters: {'email': '[email protected]', 'is_active': True, 'is_superuser': True, 'full_name': None, 'hashed_password': '$2b$12$O1FGCpDKGwyy6wH6CEA0lOpBAxETlYbAg.ib9av622HcJ/YB1AY1C'}]
backend-1 | (Background on this error at: https://sqlalche.me/e/20/gkpj)

[bereydev]

Base on your provided information it seems like you are facing a migration issue. If you added a new table did you make sure to run a migration on your database ?

Also could you please add some steps to reproduce. A generic SQL log trace seems a bit light to work with.

Thanks!

[vedantulhe12]

The problem appears to be that the user table's id column isn't receiving a value during the INSERT, according to the information you provided. This occurs as a result of the column not being configured to automatically generate values (for example, by using autoincrement=True or a UUID). Make sure the ID is set up to generate itself by double-checking your model and database schema. Make sure this configuration is reflected in your migrations as well. I hope this will work.