It is currently Sat Feb 11, 2012 8:54 pm

All times are UTC + 2 hours




Post new topic Reply to topic  [ 3 posts ] 
Author Message
 Post subject: 5.0.6 data migrated to 5.0.7 Can't delete user [SOLVED]
PostPosted: Mon Mar 08, 2010 4:00 pm 
Offline

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.


Last edited by oktay on Mon Mar 08, 2010 4:47 pm, edited 1 time in total.

Top
 Profile  
 
 Post subject:
PostPosted: Mon Mar 08, 2010 4:03 pm 
Offline
OpenERP Developer

Joined: Sun Mar 23, 2008 12:41 pm
Posts: 138
Location: Grand-Rosiere
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.

_________________
OpenERP Developer


Top
 Profile  
 
 Post subject: [SOLVED]
PostPosted: Mon Mar 08, 2010 4:46 pm 
Offline

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.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 3 posts ] 

All times are UTC + 2 hours


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:

Protected by Anti-Spam ACP