Keycloak version 23.0.7

  1. I have upgraded keycloak version to 23.0.7
  2. added groups configurations
  3. then tried to register i found this error

Detail: Failing row contains (4649574d-ffe4-4e33-82dd-79280d813c2e, a4769cef-79a7-4442-8a8c-2bb3bc807565, null).] [insert into USER_GROUP_MEMBERSHIP (GROUP_ID,USER_ID) values (?,?)]
2024-12-04 07:51:02,085 WARN [org.keycloak.services] (executor-thread-50) KC-SERVICES0013: Failed authentication: org.keycloak.models.ModelDuplicateException: org.hibernate.exception.ConstraintViolationException: could not execute statement [ERROR: null value in column “membership_type” of relation “user_group_membership” violates not-null constraint
Detail: Failing row contains (4649574d-ffe4-4e33-82dd-79280d813c2e, a4769cef-79a7-4442-8a8c-2bb3bc807565, null).

ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (executor-thread-50) ERROR: null value in column “membership_type” of relation “user_group_membership” violates not-null constraint
2024-12-04 07:51:02,084 WARN [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (executor-thread-50) SQL Error: 0, SQLState: 23502

I’m also getting same issue, if anybody have a fix please let me know