5.0.6 data migrated to 5.0.7 Can't delete user [SOLVED]

oktay · **Joined:** Thu Jan 21, 2010 1:24 pm **Posts:** 28

Code:

Integrity Error

null value in column "act_to" violates not-null constraint
CONTEXT:  SQL statement "UPDATE ONLY "public"."res_request" SET "act_to" = NULL WHERE $1 OPERATOR(pg_catalog.=) "act_to""

I am getting the above error when trying to delete a particular user. It looks identical to some other users that I CAN delete. Is there a query to satisfy the above condition. I don't have any cases associated with this user, so I can manually remove this user too.

Stephane Wirtel · **Posted:** Mon Mar 08, 2010 4:03 pm

the issue is in the res.request object, and not in the res.partner object.

1. Check your requests, because I think you have a old referenced object.

oktay · **Joined:** Thu Jan 21, 2010 1:24 pm **Posts:** 28

Thanks. I just came back to report the same. I had 3 requests in res_request . I deleted them all since they were test data and then proceeded to delete the user without a problem.