You've hit a bug in user-profiles-create.sql (typo on my part). I fixed this yesterday (see rev 1.4), so update your cvs and reinstall. Note, you may still get an error if you're trying to add your user profile to a group and not an application group (the server log will have a nice message about violating the relationship constraints).