Uploaded image for project: 'CiviCRM'
  1. CiviCRM
  2. CRM-6313

Creating a contact via profile having current employer as one of the field, is broken for anonymous user

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Blocker
    • Resolution: Fixed/Completed
    • Affects Version/s: 3.1.5
    • Fix Version/s: 3.1.6
    • Component/s: CiviCRM Profile
    • Labels:
      None

      Description

      Create a profile with first name, last name, email and current employer. Checked update on duplicate in Profile advanced settings.

      Then using profile create mode try to create a contact as anonymous user. IT gives following error:

      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 (`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, 3, 'View' ),( 0, 13, 'View' ),( 0, 15, 'View' ),( 0, 17, 'View' ),( 0, 33, 'View' ),( 0, 37, 'View' ),( 0, 71, 'View' ),( 0, 91, 'View' ),( 0, 125, 'View' ),( 0, 131, 'View' ),( 0, 147, 'View' ),( 0, 149, 'View' ),( 0, 209, 'View' ),( 0, 229, 'View' ),( 0, 235, 'View' ),( 0, 255, 'View' ),( 0, 263, 'View' ),( 0, 267, 'View' ),( 0, 269, 'View' ),( 0, 273, 'View' ),( 0, 277, 'View' ),( 0, 289, 'View' ),( 0, 313, 'View' ),( 0, 329, 'View' ),( 0, 369, 'View' ),( 0, 413, 'View' ),( 0, 435, 'View' ),( 0, 437, 'View' ),( 0, 485, 'View' ),( 0, 501, 'View' ),( 0, 545, 'View' ),( 0, 565, 'View' ),( 0, 581, 'View' ),( 0, 587, 'View' ),( 0, 589, 'View' ),( 0, 605, 'View' ),( 0, 639, 'View' ),( 0, 659, 'View' ),( 0, 671, 'View' ),( 0, 677, 'View' ),( 0, 703, 'View' ),( 0, 707, 'View' ),( 0, 725, 'View' ),( 0, 735, 'View' ),( 0, 759, 'View' ),( 0, 763, 'View' ),( 0, 775, 'View' ),( 0, 781, 'View' ),( 0, 892, 'View' ),( 0, 914, 'View' ),( 0, 952, 'View' ),( 0, 990, 'View' ),( 0, 1020, 'View' ),( 0, 1024, 'View' ),( 0, 1040, 'View' ),( 0, 1048, 'View' ),( 0, 1056, 'View' ),( 0, 1072, 'View' ),( 0, 1080, 'View' ),( 0, 1132, 'View' ),( 0, 1140, 'View' ),( 0, 1142, 'View' ),( 0, 1146, 'View' ),( 0, 1190, 'View' ),( 0, 1212, 'View' ),( 0, 1224, 'View' ),( 0, 1256, 'View' ),( 0, 1260, 'View' ),( 0, 1288, 'View' ),( 0, 1370, 'View' ),( 0, 1388, 'View' ),( 0, 1400, 'View' ),( 0, 1428, 'View' ),( 0, 1450, 'View' ),( 0, 1466, 'View' ),( 0, 1474, 'View' ),( 0, 1484, 'View' ),( 0, 1500, 'View' ),( 0, 1540, 'View' ),( 0, 1550, 'View' ),( 0, 1552, 'View' ),( 0, 1568, 'View' ),( 0, 1590, 'View' ),( 0, 1592, 'View' ),( 0, 1598, 'View' ),( 0, 1604, 'View' ),( 0, 1606, 'View' ),( 0, 1612, 'View' ),( 0, 1614, 'View' ),( 0, 1618, 'View' ),( 0, 1620, 'View' ),( 0, 1622, 'View' ),( 0, 1624, 'View' ),( 0, 1626, 'View' ),( 0, 1628, 'View' ),( 0, 1630, 'View' ),( 0, 1640, 'View' ),( 0, 1644, 'View' ),( 0, 1658, 'View' ),( 0, 1694, 'View' ),( 0, 1698, 'View' ),( 0, 1700, 'View' ),( 0, 1706, 'View' ),( 0, 1722, 'View' ),( 0, 1730, 'View' ),( 0, 1794, 'View' ),( 0, 1814, 'View' ),( 0, 1832, 'View' ),( 0, 1870, 'View' ),( 0, 1918, 'View' ),( 0, 1920, 'View' ),( 0, 2044, 'View' ),( 0, 2048, 'View' ),( 0, 2060, 'View' ),( 0, 2064, 'View' ),( 0, 2074, 'View' ),( 0, 2128, 'View' ),( 0, 2154, 'View' ),( 0, 2160, 'View' ),( 0, 2186, 'View' ),( 0, 2192, 'View' ),( 0, 2236, 'View' ),( 0, 2238, 'View' ),( 0, 2242, 'View' ),( 0, 2370, 'View' ),( 0, 2392, 'View' ),( 0, 2398, 'View' ),( 0, 2402, 'View' ),( 0, 2448, 'View' ),( 0, 2472, 'View' ),( 0, 2484, 'View' ),( 0, 2522, 'View' ),( 0, 2750, 'View' ),( 0, 3020, 'View' ),( 0, 3026, 'View' ),( 0, 3028, 'View' ),( 0, 3044, 'View' ),( 0, 3050, 'View' ),( 0, 3124, 'View' ),( 0, 3142, 'View' ),( 0, 3174, 'View' ),( 0, 3196, 'View' ),( 0, 3212, 'View' ),( 0, 3296, 'View' ),( 0, 3366, 'View' ),( 0, 3570, 'View' ),( 0, 3592, 'View' ),( 0, 3598, 'View' ),( 0, 3608, 'View' ),( 0, 3618, 'View' ),( 0, 3632, 'View' ),( 0, 3643, 'View' ),( 0, 3648, 'View' ),( 0, 3658, 'View' ),( 0, 3660, 'View' ),( 0, 3670, 'View' ),( 0, 3680, 'View' ),( 0, 3710, 'View' ),( 0, 3730, 'View' ),( 0, 3754, 'View' ),( 0, 3786, 'View' ),( 0, 3890, 'View' ),( 0, 3912, 'View' ),( 0, 3968, 'View' ),( 0, 3980, 'View' ),( 0, 4006, 'View' ),( 0, 4044, 'View' ),( 0, 4198, 'View' ),( 0, 4564, 'View' ),( 0, 4570, 'View' ),( 0, 4596, 'View' ),( 0, 4632, 'View' ),( 0, 4730, 'View' ),( 0, 4744, 'View' ),( 0, 4938, 'View' ),( 0, 5004, 'View' ),( 0, 5356, 'View' ),( 0, 5534, 'View' ),( 0, 5648, 'View' ),( 0, 5704, 'View' ),( 0, 5988, 'View' ),( 0, 6094, 'View' ),( 0, 6116, 'View' ),( 0, 6184, 'View' ),( 0, 6202, 'View' ),( 0, 6230, 'View' ),( 0, 6236, 'View' ),( 0, 6246, 'View' ),( 0, 6318, 'View' ),( 0, 6366, 'View' ),( 0, 6380, 'View' ),( 0, 6404, 'View' ),( 0, 6566, 'View' ),( 0, 6572, 'View' ),( 0, 6588, 'View' ),( 0, 6610, 'View' ),( 0, 6614, 'View' ),( 0, 6618, 'View' ),( 0, 6626, 'View' ),( 0, 6666, 'View' ); [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`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, 3, 'View' ),( 0, 13, 'View' ),( 0, 15, 'View' ),( 0, 17, 'View' ),( 0, 33, 'View' ),( 0, 37, 'View' ),( 0, 71, 'View' ),( 0, 91, 'View' ),( 0, 125, 'View' ),( 0, 131, 'View' ),( 0, 147, 'View' ),( 0, 149, 'View' ),( 0, 209, 'View' ),( 0, 229, 'View' ),( 0, 235, 'View' ),( 0, 255, 'View' ),( 0, 263, 'View' ),( 0, 267, 'View' ),( 0, 269, 'View' ),( 0, 273, 'View' ),( 0, 277, 'View' ),( 0, 289, 'View' ),( 0, 313, 'View' ),( 0, 329, 'View' ),( 0, 369, 'View' ),( 0, 413, 'View' ),( 0, 435, 'View' ),( 0, 437, 'View' ),( 0, 485, 'View' ),( 0, 501, 'View' ),( 0, 545, 'View' ),( 0, 565, 'View' ),( 0, 581, 'View' ),( 0, 587, 'View' ),( 0, 589, 'View' ),( 0, 605, 'View' ),( 0, 639, 'View' ),( 0, 659, 'View' ),( 0, 671, 'View' ),( 0, 677, 'View' ),( 0, 703, 'View' ),( 0, 707, 'View' ),( 0, 725, 'View' ),( 0, 735, 'View' ),( 0, 759, 'View' ),( 0, 763, 'View' ),( 0, 775, 'View' ),( 0, 781, 'View' ),( 0, 892, 'View' ),( 0, 914, 'View' ),( 0, 952, 'View' ),( 0, 990, 'View' ),( 0, 1020, 'View' ),( 0, 1024, 'View' ),( 0, 1040, 'View' ),( 0, 1048, 'View' ),( 0, 1056, 'View' ),( 0, 1072, 'View' ),( 0, 1080, 'View' ),( 0, 1132, 'View' ),( 0, 1140, 'View' ),( 0, 1142, 'View' ),( 0, 1146, 'View' ),( 0, 1190, 'View' ),( 0, 1212, 'View' ),( 0, 1224, 'View' ),( 0, 1256, 'View' ),( 0, 1260, 'View' ),( 0, 1288, 'View' ),( 0, 1370, 'View' ),( 0, 1388, 'View' ),( 0, 1400, 'View' ),( 0, 1428, 'View' ),( 0, 1450, 'View' ),( 0, 1466, 'View' ),( 0, 1474, 'View' ),( 0, 1484, 'View' ),( 0, 1500, 'View' ),( 0, 1540, 'View' ),( 0, 1550, 'View' ),( 0, 1552, 'View' ),( 0, 1568, 'View' ),( 0, 1590, 'View' ),( 0, 1592, 'View' ),( 0, 1598, 'View' ),( 0, 1604, 'View' ),( 0, 1606, 'View' ),( 0, 1612, 'View' ),( 0, 1614, 'View' ),( 0, 1618, 'View' ),( 0, 1620, 'View' ),( 0, 1622, 'View' ),( 0, 1624, 'View' ),( 0, 1626, 'View' ),( 0, 1628, 'View' ),( 0, 1630, 'View' ),( 0, 1640, 'View' ),( 0, 1644, 'View' ),( 0, 1658, 'View' ),( 0, 1694, 'View' ),( 0, 1698, 'View' ),( 0, 1700, 'View' ),( 0, 1706, 'View' ),( 0, 1722, 'View' ),( 0, 1730, 'View' ),( 0, 1794, 'View' ),( 0, 1814, 'View' ),( 0, 1832, 'View' ),( 0, 1870, 'View' ),( 0, 1918, 'View' ),( 0, 1920, 'View' ),( 0, 2044, 'View' ),( 0, 2048, 'View' ),( 0, 2060, 'View' ),( 0, 2064, 'View' ),( 0, 2074, 'View' ),( 0, 2128, 'View' ),( 0, 2154, 'View' ),( 0, 2160, 'View' ),( 0, 2186, 'View' ),( 0, 2192, 'View' ),( 0, 2236, 'View' ),( 0, 2238, 'View' ),( 0, 2242, 'View' ),( 0, 2370, 'View' ),( 0, 2392, 'View' ),( 0, 2398, 'View' ),( 0, 2402, 'View' ),( 0, 2448, 'View' ),( 0, 2472, 'View' ),( 0, 2484, 'View' ),( 0, 2522, 'View' ),( 0, 2750, 'View' ),( 0, 3020, 'View' ),( 0, 3026, 'View' ),( 0, 3028, 'View' ),( 0, 3044, 'View' ),( 0, 3050, 'View' ),( 0, 3124, 'View' ),( 0, 3142, 'View' ),( 0, 3174, 'View' ),( 0, 3196, 'View' ),( 0, 3212, 'View' ),( 0, 3296, 'View' ),( 0, 3366, 'View' ),( 0, 3570, 'View' ),( 0, 3592, 'View' ),( 0, 3598, 'View' ),( 0, 3608, 'View' ),( 0, 3618, 'View' ),( 0, 3632, 'View' ),( 0, 3643, 'View' ),( 0, 3648, 'View' ),( 0, 3658, 'View' ),( 0, 3660, 'View' ),( 0, 3670, 'View' ),( 0, 3680, 'View' ),( 0, 3710, 'View' ),( 0, 3730, 'View' ),( 0, 3754, 'View' ),( 0, 3786, 'View' ),( 0, 3890, 'View' ),( 0, 3912, 'View' ),( 0, 3968, 'View' ),( 0, 3980, 'View' ),( 0, 4006, 'View' ),( 0, 4044, 'View' ),( 0, 4198, 'View' ),( 0, 4564, 'View' ),( 0, 4570, 'View' ),( 0, 4596, 'View' ),( 0, 4632, 'View' ),( 0, 4730, 'View' ),( 0, 4744, 'View' ),( 0, 4938, 'View' ),( 0, 5004, 'View' ),( 0, 5356, 'View' ),( 0, 5534, 'View' ),( 0, 5648, 'View' ),( 0, 5704, 'View' ),( 0, 5988, 'View' ),( 0, 6094, 'View' ),( 0, 6116, 'View' ),( 0, 6184, 'View' ),( 0, 6202, 'View' ),( 0, 6230, 'View' ),( 0, 6236, 'View' ),( 0, 6246, 'View' ),( 0, 6318, 'View' ),( 0, 6366, 'View' ),( 0, 6380, 'View' ),( 0, 6404, 'View' ),( 0, 6566, 'View' ),( 0, 6572, 'View' ),( 0, 6588, 'View' ),( 0, 6610, 'View' ),( 0, 6614, 'View' ),( 0, 6618, 'View' ),( 0, 6626, 'View' ),( 0, 6666, 'View' ); [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`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, 3, 'View' ),( 0, 13, 'View' ),( 0, 15, 'View' ),( 0, 17, 'View' ),( 0, 33, 'View' ),( 0, 37, 'View' ),( 0, 71, 'View' ),( 0, 91, 'View' ),( 0, 125, 'View' ),( 0, 131, 'View' ),( 0, 147, 'View' ),( 0, 149, 'View' ),( 0, 209, 'View' ),( 0, 229, 'View' ),( 0, 235, 'View' ),( 0, 255, 'View' ),( 0, 263, 'View' ),( 0, 267, 'View' ),( 0, 269, 'View' ),( 0, 273, 'View' ),( 0, 277, 'View' ),( 0, 289, 'View' ),( 0, 313, 'View' ),( 0, 329, 'View' ),( 0, 369, 'View' ),( 0, 413, 'View' ),( 0, 435, 'View' ),( 0, 437, 'View' ),( 0, 485, 'View' ),( 0, 501, 'View' ),( 0, 545, 'View' ),( 0, 565, 'View' ),( 0, 581, 'View' ),( 0, 587, 'View' ),( 0, 589, 'View' ),( 0, 605, 'View' ),( 0, 639, 'View' ),( 0, 659, 'View' ),( 0, 671, 'View' ),( 0, 677, 'View' ),( 0, 703, 'View' ),( 0, 707, 'View' ),( 0, 725, 'View' ),( 0, 735, 'View' ),( 0, 759, 'View' ),( 0, 763, 'View' ),( 0, 775, 'View' ),( 0, 781, 'View' ),( 0, 892, 'View' ),( 0, 914, 'View' ),( 0, 952, 'View' ),( 0, 990, 'View' ),( 0, 1020, 'View' ),( 0, 1024, 'View' ),( 0, 1040, 'View' ),( 0, 1048, 'View' ),( 0, 1056, 'View' ),( 0, 1072, 'View' ),( 0, 1080, 'View' ),( 0, 1132, 'View' ),( 0, 1140, 'View' ),( 0, 1142, 'View' ),( 0, 1146, 'View' ),( 0, 1190, 'View' ),( 0, 1212, 'View' ),( 0, 1224, 'View' ),( 0, 1256, 'View' ),( 0, 1260, 'View' ),( 0, 1288, 'View' ),( 0, 1370, 'View' ),( 0, 1388, 'View' ),( 0, 1400, 'View' ),( 0, 1428, 'View' ),( 0, 1450, 'View' ),( 0, 1466, 'View' ),( 0, 1474, 'View' ),( 0, 1484, 'View' ),( 0, 1500, 'View' ),( 0, 1540, 'View' ),( 0, 1550, 'View' ),( 0, 1552, 'View' ),( 0, 1568, 'View' ),( 0, 1590, 'View' ),( 0, 1592, 'View' ),( 0, 1598, 'View' ),( 0, 1604, 'View' ),( 0, 1606, 'View' ),( 0, 1612, 'View' ),( 0, 1614, 'View' ),( 0, 1618, 'View' ),( 0, 1620, 'View' ),( 0, 1622, 'View' ),( 0, 1624, 'View' ),( 0, 1626, 'View' ),( 0, 1628, 'View' ),( 0, 1630, 'View' ),( 0, 1640, 'View' ),( 0, 1644, 'View' ),( 0, 1658, 'View' ),( 0, 1694, 'View' ),( 0, 1698, 'View' ),( 0, 1700, 'View' ),( 0, 1706, 'View' ),( 0, 1722, 'View' ),( 0, 1730, 'View' ),( 0, 1794, 'View' ),( 0, 1814, 'View' ),( 0, 1832, 'View' ),( 0, 1870, 'View' ),( 0, 1918, 'View' ),( 0, 1920, 'View' ),( 0, 2044, 'View' ),( 0, 2048, 'View' ),( 0, 2060, 'View' ),( 0, 2064, 'View' ),( 0, 2074, 'View' ),( 0, 2128, 'View' ),( 0, 2154, 'View' ),( 0, 2160, 'View' ),( 0, 2186, 'View' ),( 0, 2192, 'View' ),( 0, 2236, 'View' ),( 0, 2238, 'View' ),( 0, 2242, 'View' ),( 0, 2370, 'View' ),( 0, 2392, 'View' ),( 0, 2398, 'View' ),( 0, 2402, 'View' ),( 0, 2448, 'View' ),( 0, 2472, 'View' ),( 0, 2484, 'View' ),( 0, 2522, 'View' ),( 0, 2750, 'View' ),( 0, 3020, 'View' ),( 0, 3026, 'View' ),( 0, 3028, 'View' ),( 0, 3044, 'View' ),( 0, 3050, 'View' ),( 0, 3124, 'View' ),( 0, 3142, 'View' ),( 0, 3174, 'View' ),( 0, 3196, 'View' ),( 0, 3212, 'View' ),( 0, 3296, 'View' ),( 0, 3366, 'View' ),( 0, 3570, 'View' ),( 0, 3592, 'View' ),( 0, 3598, 'View' ),( 0, 3608, 'View' ),( 0, 3618, 'View' ),( 0, 3632, 'View' ),( 0, 3643, 'View' ),( 0, 3648, 'View' ),( 0, 3658, 'View' ),( 0, 3660, 'View' ),( 0, 3670, 'View' ),( 0, 3680, 'View' ),( 0, 3710, 'View' ),( 0, 3730, 'View' ),( 0, 3754, 'View' ),( 0, 3786, 'View' ),( 0, 3890, 'View' ),( 0, 3912, 'View' ),( 0, 3968, 'View' ),( 0, 3980, 'View' ),( 0, 4006, 'View' ),( 0, 4044, 'View' ),( 0, 4198, 'View' ),( 0, 4564, 'View' ),( 0, 4570, 'View' ),( 0, 4596, 'View' ),( 0, 4632, 'View' ),( 0, 4730, 'View' ),( 0, 4744, 'View' ),( 0, 4938, 'View' ),( 0, 5004, 'View' ),( 0, 5356, 'View' ),( 0, 5534, 'View' ),( 0, 5648, 'View' ),( 0, 5704, 'View' ),( 0, 5988, 'View' ),( 0, 6094, 'View' ),( 0, 6116, 'View' ),( 0, 6184, 'View' ),( 0, 6202, 'View' ),( 0, 6230, 'View' ),( 0, 6236, 'View' ),( 0, 6246, 'View' ),( 0, 6318, 'View' ),( 0, 6366, 'View' ),( 0, 6380, 'View' ),( 0, 6404, 'View' ),( 0, 6566, 'View' ),( 0, 6572, 'View' ),( 0, 6588, 'View' ),( 0, 6610, 'View' ),( 0, 6614, 'View' ),( 0, 6618, 'View' ),( 0, 6626, 'View' ),( 0, 6666, 'View' ); [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`civicrm`.`civicrm_acl_contact_cache`, CONSTRAINT `FK_civicrm_acl_contact_cache_user_id` FOREIGN KEY (`user_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE)]"]
      )

        Attachments

          Activity

            People

            • Assignee:
              kurund Kurund Jalmi
              Reporter:
              kurund Kurund Jalmi
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: