Answers.Body: <p>According to <a href="https://www.drupal.org/node/2802037" rel="nofollow">here</a> this has been fixed with this <a href="https://github.com/eileenmcnaughton/nz.co.fuzion.relatedpermissions/pull/12" rel="nofollow">patch</a></p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-10-16T07:07:02.813Z
Answers.Text: Yes.. we paid for Agileware to develop this patch. However there is still a similar issue when the "Lock Fields" option is selected for the Existing Contact using the webform. Not sure if you can look into that.
Answers.UserDisplayName: Phil Hart
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-10-16T09:12:42.127Z
Answers.Text: "Not sure if you can look into that". me?
Answers.UserDisplayName: petednz - fuzion
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2023-01-16T16:45:26.633Z
Answers.Text: this post helped to discover that the relation permission module is necessary for webform and was uninstalled on our instance. thanks for posting this issue ;-)
Answers.UserDisplayName: Guillaume Sorel
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-10-10T06:26:17.387Z
Answers.LastActivityDate: 2016-10-10T06:26:17.387Z
Answers.UserDisplayName: petednz - fuzion
Body: <p>We are using Webform and the Related Permissions extension to allow parents to register their children for summer camp events. An Existing Contact select widget is included so that parents can select children they have previously registered (which established a permissioned relationship between them).</p>
  
  <p>With "Enforce Permissions" selected on the webform component, the drop down list does not work - no contacts are included in the list, even though the user is logged and has related and permissioned contacts.</p>
  
  <p>When "Enforce Permissions" is de-selected, the drop down list shows the first 500 contacts as expected.</p>
  
  <p>The logs show the following error:</p>
  
  <p><em>The CiviCRM "contact get" API returned the error: "DB Error: unknown error" when called by function "_webform_render_civicrm_contact" on line 387 of contact_component.inc with parameters: "Array ( [is_deleted] => 0 [contact_type] => Individual [check_permissions] => 1 [rowCount] => 500 [sort] => sort_name [version] => 3 ) "</em></p>
  
  <p>Drupal 7.50
  Civi 4.7.11
  Webform 7.x-4.14
  Related Permissions Extension 1.2 (with latest codebase installed a couple of weeks ago)</p>
  
  <p>Any ideas appreciated!</p>
  
Tags: <webform-civicrm><extension>
Title: Related Permissions Extension: Existing Contact widget on Webform not showing related contacts
ThreadText: # Related Permissions Extension: Existing Contact widget on Webform not showing related contacts
  
  (Asked by: username_0 on 2016-09-17)
  
  We are using Webform and the Related Permissions extension to allow parents to register their children for summer camp events. An Existing Contact select widget is included so that parents can select children they have previously registered (which established a permissioned relationship between them).
  
  With "Enforce Permissions" selected on the webform component, the drop down list does not work - no contacts are included in the list, even though the user is logged and has related and permissioned contacts.
  
  When "Enforce Permissions" is de-selected, the drop down list shows the first 500 contacts as expected.
  
  The logs show the following error:
  
  *The CiviCRM "contact get" API returned the error: "DB Error: unknown error" when called by function "\_webform\_render\_civicrm\_contact" on line 387 of contact\_component.inc with parameters: "Array ( [is\_deleted] => 0 [contact\_type] => Individual [check\_permissions] => 1 [rowCount] => 500 [sort] => sort\_name [version] => 3 ) "*
  
  Drupal 7.50
  Civi 4.7.11
  Webform 7.x-4.14
  Related Permissions Extension 1.2 (with latest codebase installed a couple of weeks ago)
  
  Any ideas appreciated!
  
  **Tags:** webform-civicrm, extension
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2016-10-10. Score: 0 | Accepted answer
  
  According to [here](https://www.drupal.org/node/2802037) this has been fixed with this [patch](https://github.com/eileenmcnaughton/nz.co.fuzion.relatedpermissions/pull/12)
  
  > **Comments:**
  > **username_0**: Yes.. we paid for Agileware to develop this patch. However there is still a similar issue when the "Lock Fields" option is selected for the Existing Contact using the webform. Not sure if you can look into that.  
  > **username_1**: "Not sure if you can look into that". me?  
  > **username_2**: this post helped to discover that the relation permission module is necessary for webform and was uninstalled on our instance. thanks for posting this issue ;-)  
  
  ---
  
  