CiviCRM Community Forums (archive)

Here's the scenario. My client is selling group memberships. We apply these group memberships to an Organization and individual's inherit a membership based on the entering their employer in the Employer field.The individual's membership is then created because of the employer/employee relationship.

I have the civicrm_entity drupal module installed. https://drupal.org/sandbox/eileen/1923028

I have created a rule to create a synced Drupal user account triggered by membership creation.

When creating a new individual contact, entering the first name and last name, employer, and email address then hitting save I get the error:
Error: SQLSTATE23000: Integrity constraint violation: 1062 Duplicate entry '' for key 'name'

What seems to be happening is that the inherited membership for the individual is being created BEFORE the email address is being stored in the database. The membership creation triggers the Create Synced Drupal User Rule described here: https://drupal.org/node/2001332
The rule tries to create the user before the email address is available....

This scenario happens when trying to create the contact with employer field filled out either manually via the CiviCRM admin, or if the employer field is used on a Profile being used on a member join contribution form.

Any thoughts on how to make this work right.....Why is the email address being stored AFTER the membership is created?