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

Duplicate entry fatal DB error in civicrm_cache for Renew Membership

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Minor
    • Resolution: Fixed/Completed
    • Affects Version/s: 4.3.0
    • Fix Version/s: 4.3.0
    • Component/s: CiviMember
    • Labels:
      None

      Description

      Memberships -> Dashboard. Click 'more' - Renew Membership. (might need to do this twice).
      =======
      Database Error Code: Duplicate entry 'CiviCRM Session-CiviCRM_CRM_Contribute_Form_Search_a4389cd343079' for key 'UI_group_path_date', 1062

      [message] => DB Error: already existstcrm_43
      [mode] => 16
      [debug_info] => INSERT INTO civicrm_cache (group_name , path , data , created_date ) VALUES ('CiviCRM Session' , 'CiviCRM_CRM_Contribute_Form_Search_a4389cd343079975dfda57c6a59a1bfb_5794' , 'a:18:{s:5:\"force\";i:0;s:3:\"cid\";s:1:\"8\";s:8:\"memberId\";s:1:\"1\";s:7:\"context\";s:12:\"contribution\";s:14:\"searchFormName\";s:6:\"Search\";s:10:\"formValues\";a:3:

      {s:26:\"contribution_membership_id\";s:1:\"1\";s:10:\"contact_id\";s:1:\"8\";s:17:\"contribution_test\";i:0;}

      s:11:\"queryParams\";a:3:{i:0;a:5:

      {i:0;s:26:\"contribution_membership_id\";i:1;s:1:\"=\";i:2;s:1:\"1\";i:3;i:0;i:4;i:0;}

      i:1;a:5:

      {i:0;s:10:\"contact_id\";i:1;s:1:\"=\";i:2;s:1:\"8\";i:3;i:0;i:4;i:0;}

      i:2;a:5:{i:0;s:17:\"contribution_test\";i:1;s:1:\"=\";i:2;i:0;i:3;i:0;i:4;i:0;}}s:7:\"summary\";a:1:{s:5:\"total\";a:3:{s:3:\"avg\";s:8:\"$ 100.00\";s:6:\"amount\";s:8:\"$ 100.00\";s:5:\"count\";i:1;}}s:13:\"columnHeaders\";a:8:{i:0;a:3:

      {s:4:\"name\";s:6:\"Amount\";s:4:\"sort\";s:12:\"total_amount\";s:9:\"direction\";i:4;}

      i:1;a:3:

      {s:4:\"name\";s:4:\"Type\";s:4:\"sort\";s:17:\"financial_type_id\";s:9:\"direction\";i:4;}

      i:2;a:3:

      {s:4:\"name\";s:6:\"Source\";s:4:\"sort\";s:19:\"contribution_source\";s:9:\"direction\";i:4;}

      i:3;a:3:

      {s:4:\"name\";s:8:\"Received\";s:4:\"sort\";s:12:\"receive_date\";s:9:\"direction\";i:2;}

      i:4;a:3:

      {s:4:\"name\";s:14:\"Thank-you Sent\";s:4:\"sort\";s:13:\"thankyou_date\";s:9:\"direction\";i:4;}

      i:5;a:3:

      {s:4:\"name\";s:6:\"Status\";s:4:\"sort\";s:22:\"contribution_status_id\";s:9:\"direction\";i:4;}

      i:6;a:3:

      {s:4:\"name\";s:7:\"Premium\";s:4:\"sort\";s:12:\"product_name\";s:9:\"direction\";i:4;}

      i:7;a:1:{s:4:\"desc\";s:7:\"Actions\";}}s:4:\"rows\";a:1:{i:0;a:24:{s:10:\"contact_id\";s:1:\"8\";s:15:\"contribution_id\";s:2:\"14\";s:12:\"contact_type\";s:151:\"<a href=\"/civicrm/profile/view?reset=1&gid=7&id=8&snippet=4\" class=\"crm-summary-link\"><div class=\"icon crm-icon Individual-icon\"></div></a>\";s:9:\"sort_name\";s:15:\"Roberts, Justin\";s:12:\"amount_level\";N;s:12:\"total_amount\";s:6:\"100.00\";s:14:\"financial_type\";s:11:\"Member Dues\";s:19:\"contribution_source\";s:34:\"General Membership: Offline signup\";s:12:\"receive_date\";s:19:\"2012-11-06 10:25:12\";s:13:\"thankyou_date\";N;s:22:\"contribution_status_id\";s:1:\"1\";s:19:\"contribution_status\";s:9:\"Completed\";s:11:\"cancel_date\";N;s:12:\"product_name\";N;s:7:\"is_test\";s:1:\"0\";s:21:\"contribution_recur_id\";N;s:12:\"receipt_date\";N;s:8:\"currency\";s:3:\"USD\";s:24:\"contribution_campaign_id\";N;s:8:\"campaign\";N;s:11:\"campaign_id\";N;s:24:\"contribution_status_name\";s:9:\"Completed\";s:8:\"checkbox\";s:9:\"mark_x_14\";s:6:\"action\";s:626:\"<span><a href=\"http://civicrm40/civicrm/contact/view/contribution?reset=1&id=14&cid=8&action=view&context=contribution&selectedChild=contribute\" class = \"action-item action-item-first\" title=\"View Contribution\">View</a><a href=\"http://civicrm40/civicrm/contact/view/contribution?reset=1&action=update&id=14&cid=8&context=contribution\" class = \"action-item\" title=\"Edit Contribution\">Edit</a><a href=\"http://civicrm40/civicrm/contact/view/contribution?reset=1&action=delete&id=14&cid=8&context=contribution\" class = \"action-item\" title=\"Delete Contribution\">Delete</a></span>\";}}s:8:\"rowCount\";s:1:\"1\";s:9:\"rowsEmpty\";b:0;s:4:\"qill\";a:1:{i:0;a:0:{}}s:6:\"crmPID\";i:1;s:6:\"crmSID\";i:1;s:16:\"crmSortDirection\";i:2;s:12:\"crmSortOrder\";s:17:\"receive_date desc\";s:11:\"crmRowCount\";i:50;}' , 20121106122536 ) [nativecode=1062 ** Duplicate entry 'CiviCRM Session-CiviCRM_CRM_Contribute_Form_Search_a4389cd343079' for key 'UI_group_path_date']

      backTrace

      #0 /Users/dgg/svn/crm_v4.1/CRM/Core/Error.php(148): CRM_Core_Error::backtrace()
      #1 [internal function](): CRM_Core_Error::handle(Object(DB_Error))
      #2 /Users/dgg/svn/crm_v4.1/packages/PEAR.php(931): call_user_func((Array:2), Object(DB_Error))
      #3 /Users/dgg/svn/crm_v4.1/packages/DB.php(968): PEAR_Error->PEAR_Error("DB Error: already exists", -5, 16, (Array:2), "INSERT INTO civicrm_cache (group_name , path , data , created_date ) VALUES (...")
      #4 /Users/dgg/svn/crm_v4.1/packages/PEAR.php(564): DB_Error->DB_Error(-5, 16, (Array:2), "INSERT INTO civicrm_cache (group_name , path , data , created_date ) VALUES (...")
      #5 /Users/dgg/svn/crm_v4.1/packages/DB/common.php(1903): PEAR->raiseError(NULL, -5, NULL, NULL, "INSERT INTO civicrm_cache (group_name , path , data , created_date ) VALUES (...", "DB_Error", TRUE)
      #6 /Users/dgg/svn/crm_v4.1/packages/DB/mysql.php(898): DB_common->raiseError(-5, NULL, NULL, NULL, "1062 ** Duplicate entry 'CiviCRM Session-CiviCRM_CRM_Contribute_Form_Search_a...")
      #7 /Users/dgg/svn/crm_v4.1/packages/DB/mysql.php(327): DB_mysql->mysqlRaiseError()
      #8 /Users/dgg/svn/crm_v4.1/packages/DB/common.php(1216): DB_mysql->simpleQuery("INSERT INTO civicrm_cache (group_name , path , data , created_date ) VALUES (...")
      #9 /Users/dgg/svn/crm_v4.1/packages/DB/DataObject.php(2421): DB_common->query("INSERT INTO civicrm_cache (group_name , path , data , created_date ) VALUES (...")
      #10 /Users/dgg/svn/crm_v4.1/packages/DB/DataObject.php(1055): DB_DataObject->_query("INSERT INTO civicrm_cache (group_name , path , data , created_date ) VALUES (...")
      #11 /Users/dgg/svn/crm_v4.1/CRM/Core/DAO.php(287): DB_DataObject->insert()
      #12 /Users/dgg/svn/crm_v4.1/CRM/Core/BAO/Cache.php(123): CRM_Core_DAO->save()
      #13 /Users/dgg/svn/crm_v4.1/CRM/Core/BAO/Cache.php(189): CRM_Core_BAO_Cache::setItem((Array:18), "CiviCRM Session", "CiviCRM_CRM_Contribute_Form_Search_a4389cd343079975dfda57c6a59a1bfb_5794")
      #14 /Users/dgg/svn/crm_v4.1/CRM/Core/Session.php(495): CRM_Core_BAO_Cache::storeSessionToCache((Array:3), TRUE)
      #15 /Users/dgg/svn/crm_v4.1/CRM/Utils/System.php(1212): CRM_Core_Session::storeSessionObjects()
      #16 /Users/dgg/svn/crm_v4.1/CRM/Core/Page.php(189): CRM_Utils_System::civiExit()
      #17 /Users/dgg/svn/crm_v4.1/CRM/Member/Page/Tab.php(296): CRM_Core_Page->run()
      #18 /Users/dgg/svn/crm_v4.1/CRM/Core/Invoke.php(276): CRM_Member_Page_Tab->run((Array:4), NULL)
      #19 /Users/dgg/svn/crm_v4.1/CRM/Core/Invoke.php(60): CRM_Core_Invoke::runItem((Array:14))
      #20 /Users/dgg/svn/crm_v4.1/drupal/civicrm.module(461): CRM_Core_Invoke::invoke((Array:4))
      #21 [internal function](): civicrm_invoke("contact", "view", "membership")
      #22 /Users/dgg/htdocs/drupal7/includes/menu.inc(516): call_user_func_array("civicrm_invoke", (Array:3))
      #23 /Users/dgg/htdocs/drupal7/index.php(21): menu_execute_active_handler()
      #24

      {main}

        Attachments

          Activity

            People

            • Assignee:
              lobo Donald A. Lobo
              Reporter:
              dgg David Greenberg
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: