I import users from active directory using ldap. I do this because users
are not populated in reviewboard from AD. We add and remove many users from
our system, so it is easier if this process was linked via a sync method.
So if users are deleted, added or have a name change reviewboard can
Currently users are added into reviewboard but we manually delete them. I
am able to SET FOREIGN_KEY_CHECKS=0 and then delete, then set it back to 1,
however this is a shortcut?
I'm not familiar with django management commands. Can you control users
On Thursday, 25 October 2012 21:28:40 UTC+1, David Trowbridge wrote:
> Can you clarify why you want to do this? As you've noted, review board
> really isn't designed to have users be deleted entirely.
> As an aside, it's going to be much, much easier to write these sorts
> of scripts as django management commands than to try to do it
> operating directly on the database.
> On Thu, Oct 25, 2012 at 2:41 AM, Ben Copeland
> > Hello all,
> > I am writing a custom script so users can be added and deleted from
> > reviewboard. However how can I delete a user from auth_user, because I
> > problems with the foreign key constraint.
> > I am writing the script in php/mysql.
> > Cannot delete or update a parent row: a foreign key constraint fails
> > (`reviewboard`.`accounts_profile`, CONSTRAINT `user_id_refs_id_46e869e2`
> > FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`))
> > What sql code would I need to delete, or make sure the user and history
> > deleted properly?
> > --
> > Want to help the Review Board project? Donate today at
> > http://www.reviewboard.org/donate/
> > Happy user? Let us know at http://www.reviewboard.org/users/
> > -~----------~----~----~----~------~----~------~--~---
> > To unsubscribe from this group, send email to
> > For more options, visit this group at
> > http://groups.google.com/group/reviewboard?hl=en
Want to help the Review Board project? Donate today at
Happy user? Let us know at http://www.reviewboard.org/users/
To unsubscribe from this group, send email to
For more options, visit this group at