CiviCRM Community Forums (archive)

I'm working on making auto-complete fields work for anonymous users.

I've used hook_civicrm_xmlMenu() to modify the permission for civicrm/ajax/contactlist, and I've created an ACL to allow anonymous users to view the contacts that should be permitted.

But it still doesn't work, and when I view /civicrm/ajax/contactlist?reset=1&context=customfield&id=26 I see:

Sorry. A non-recoverable error has occurred.
DB Error: constraint violation

Database Error Code: Cannot add or update a child row: a foreign key constraint fails (`dev_civicrm/civicrm_acl_contact_cache`, CONSTRAINT `FK_civicrm_acl_contact_cache_user_id` FOREIGN KEY (`user_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE), 1452

Return to home page.

Error Details:

Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -3
    [message] => DB Error: constraint violation
    [mode] => 16
    [debug_info] => REPLACE INTO civicrm_acl_contact_cache ( user_id, contact_id, operation ) VALUES ( 0, 5, 'View' ),( 0, 8, 'View' ),( 0, 10, 'View' ),( 0, 12, 'View' ),( 0, 14, 'View' ),( 0, 16, 'View' ),( 0, 18, 'View' ),( 0, 20, 'View' ),( 0, 22, 'View' ),( 0, 24, 'View' ),( 0, 26, 'View' ),( 0, 28, 'View' ),( 0, 31, 'View' ),( 0, 33, 'View' ),( 0, 35, 'View' ),( 0, 37, 'View' ),( 0, 43, 'View' ),( 0, 45, 'View' ),( 0, 46, 'View' ),( 0, 48, 'View' ),( 0, 51, 'View' ),( 0, 53, 'View' ),( 0, 55, 'View' ),( 0, 58, 'View' ),( 0, 75, 'View' ),( 0, 76, 'View' ),( 0, 77, 'View' ),( 0, 78, 'View' ),( 0, 79, 'View' ),( 0, 80, 'View' ),( 0, 81, 'View' ); [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`dev_civicrm/civicrm_acl_contact_cache`, CONSTRAINT `FK_civicrm_acl_contact_cache_user_id` FOREIGN KEY (`user_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE)]
    [type] => DB_Error
    [user_info] => REPLACE INTO civicrm_acl_contact_cache ( user_id, contact_id, operation ) VALUES ( 0, 5, 'View' ),( 0, 8, 'View' ),( 0, 10, 'View' ),( 0, 12, 'View' ),( 0, 14, 'View' ),( 0, 16, 'View' ),( 0, 18, 'View' ),( 0, 20, 'View' ),( 0, 22, 'View' ),( 0, 24, 'View' ),( 0, 26, 'View' ),( 0, 28, 'View' ),( 0, 31, 'View' ),( 0, 33, 'View' ),( 0, 35, 'View' ),( 0, 37, 'View' ),( 0, 43, 'View' ),( 0, 45, 'View' ),( 0, 46, 'View' ),( 0, 48, 'View' ),( 0, 51, 'View' ),( 0, 53, 'View' ),( 0, 55, 'View' ),( 0, 58, 'View' ),( 0, 75, 'View' ),( 0, 76, 'View' ),( 0, 77, 'View' ),( 0, 78, 'View' ),( 0, 79, 'View' ),( 0, 80, 'View' ),( 0, 81, 'View' ); [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`dev_civicrm/civicrm_acl_contact_cache`, CONSTRAINT `FK_civicrm_acl_contact_cache_user_id` FOREIGN KEY (`user_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE)]
    [to_string] => [db_error: message="DB Error: constraint violation" code=-3 mode=callback callback=CRM_Core_Error::handle prefix="" info="REPLACE INTO civicrm_acl_contact_cache ( user_id, contact_id, operation ) VALUES ( 0, 5, 'View' ),( 0, 8, 'View' ),( 0, 10, 'View' ),( 0, 12, 'View' ),( 0, 14, 'View' ),( 0, 16, 'View' ),( 0, 18, 'View' ),( 0, 20, 'View' ),( 0, 22, 'View' ),( 0, 24, 'View' ),( 0, 26, 'View' ),( 0, 28, 'View' ),( 0, 31, 'View' ),( 0, 33, 'View' ),( 0, 35, 'View' ),( 0, 37, 'View' ),( 0, 43, 'View' ),( 0, 45, 'View' ),( 0, 46, 'View' ),( 0, 48, 'View' ),( 0, 51, 'View' ),( 0, 53, 'View' ),( 0, 55, 'View' ),( 0, 58, 'View' ),( 0, 75, 'View' ),( 0, 76, 'View' ),( 0, 77, 'View' ),( 0, 78, 'View' ),( 0, 79, 'View' ),( 0, 80, 'View' ),( 0, 81, 'View' ); [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`dev_civicrm/civicrm_acl_contact_cache`, CONSTRAINT `FK_civicrm_acl_contact_cache_user_id` FOREIGN KEY (`user_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE)]"]
)

Any insight would be much appreciated.[/code]

Currently anonymous user cannot access Contact Reference, hence it might be broken if you try it using hooks etc. It would be good if you can file an issue with proposed solution and if possible patch.

Main reason for not exposing Contact Reference for anonymous user is security, you will be exposing your entire db to anonymous user.

Kurund

What I'm suggesting is that getContactList() could be refactored to allow the developer to decide whether or not to employ ACLs, but that would required fixing this ACL caching bug, and that's the part that's beyond my familiarity with the code.

File an issue for this.

Kurund

Answered own question. For anyone else finding this thread in a search, procedure is as follows (relatively new to Drupal & Civi so let me know if this is not the right way).
Using "churchlookup" as module name - replace as necessary:

- Create module to host hook code:
-- directory [civisite] -> sites -> all -> modules -> churchlookup
-- file churchlookup.info

name = ChurchLookup Module
description = Allows anonymous users to look up Churches in CiviCRM
dependencies[] = civicrm
package = CiviCRM
core = 6.x
version = 1.0

-- file churchlookup.module
<?php
   function churchlookup_civicrm_contactListQuery( &$query, $name, $context, $id ) {
      if ($context == 'customfield' && $id = 7) { // 7 == "Church" field
         $query = "
SELECT c.sort_name as data, c.id
FROM civicrm_contact c, civicrm_group_contact cg
WHERE c.sort_name LIKE '$name%'
AND   cg.group_id IN ( 6 ) /* 6 is the 'Churches' group */
AND   cg.contact_id = c.id
AND   cg.status = 'Added'
ORDER BY c.sort_name;
         ";
      }
   }
?>
Then enable the module in Drupal administration

(apologies for lack of code tagging - the forum kept telling me I "couldn't post external links"...)