CiviCRM Community Forums (archive)

On a brand new CiviCRM install on Drupal 7. What's the fix?

I'm attempting to link the member role "Member" to the Civicrm role "member".  When I click the submit button,
 
PDOException: SQLSTATE[HY000]: General error: 1364 Field 'rule_id' doesn't have a default value: INSERT INTO{civicrm_member_roles_rules} (rid, type_id, status_codes) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2); Array ( [:db_insert_placeholder_0] => 5 [:db_insert_placeholder_1] => 1 [:db_insert_placeholder_2] => a:4:{i:0;s:7:"current";i:1;s:7:"expired";s:7:"current";a:3:{i:0;s:1:"1";i:1;s:1:"2";i:2;s:1:"3";}s:7:"expired";a:4:{i:0;s:1:"4";i:1;s:1:"5";i:2;s:1:"6";i:3;s:1:"7";}} ) in civicrm_member_roles_add_rule_form_submit() (line 454 of /var/www/ooga-crm/drupal/sites/all/modules/civicrm/drupal/modules/civicrm_member_roles/civicrm_member_roles.module)


Update:  Using Synchronize Users To Contacts produces:

Sorry. A non-recoverable error has occurred.
DB Error: no such table
Error Details
Return to home page.

In Drupal, I created a role called "Members".  I created  a group in CiviCRM called "Members".  I created a membership type called "Member".  Not very imaginative, but there you are.

I'm trying to link the Drupal role "Members" to the CiviCRM membership type "Member".  I'll file a bug report because it appears that the installation does not correctly create tables.