CiviCRM Community Forums (archive)

We are experiencing problems with our instance of CiviCRM. Initially I suspected it was caused by our overly complicated ACL, but after removing all ACL's and simplifying the permissions structure we are still having problems.

Whenever an administrator attempts to edit a group to remove it's group parent we get an error saying "Sorry but we are not able to provide this at the moment.  is not of the type Integer".

Checking the logs I have found the following in the backtrace:
#0 /home/www/mysite.com/sites/all/modules/civicrm/CRM/Core/Error.php(315): CRM_Core_Error::backtrace()
#1 /home/www/mysite.com/sites/all/modules/civicrm/CRM/Utils/Type.php(229): CRM_Core_Error::fatal(" is not of the type Integer")
#2 /home/www/mysite.com/sites/all/modules/civicrm/CRM/Contact/BAO/Query.php(4932): CRM_Utils_Type::escape(NULL, "Integer")
#3 /home/www/mysite.com/sites/all/modules/civicrm/CRM/Contact/BAO/Query.php(3482): CRM_Contact_BAO_Query::buildClause("civicrm_address.country_id", "LIKE", NULL, "Integer")
#4 /home/www/mysite.com/sites/all/modules/civicrm/CRM/Contact/BAO/Query.php(1636): CRM_Contact_BAO_Query->country((Array:5), FALSE)
#5 /home/www/mysite.com/sites/all/modules/civicrm/CRM/Contact/BAO/Query.php(1784): CRM_Contact_BAO_Query->whereClauseSingle((Array:5))
#6 /home/www/mysite.com/sites/all/modules/civicrm/CRM/Contact/BAO/Query.php(505): CRM_Contact_BAO_Query->whereClause()
#7 /home/www/mysite.com/sites/all/modules/civicrm/CRM/Contact/BAO/Query.php(466): CRM_Contact_BAO_Query->initialize()
#8 /home/www/mysite.com/sites/all/modules/civicrm/CRM/Contact/BAO/GroupContactCache.php(449): CRM_Contact_BAO_Query->__construct((Array:6), (Array:6), NULL, FALSE, FALSE, 1, TRUE, TRUE, FALSE, NULL, (Array:2))
#9 /home/www/mysite.com/sites/all/modules/civicrm/CRM/Contact/BAO/Query.php(2763): CRM_Contact_BAO_GroupContactCache::load(Object(CRM_Core_DAO))
#10 /home/www/mysite.com/sites/all/modules/civicrm/CRM/Contact/BAO/Query.php(2729): CRM_Contact_BAO_Query->addGroupContactCache((Array:1))
#11 /home/www/mysite.com/sites/all/modules/civicrm/CRM/Contact/BAO/Query.php(2695): CRM_Contact_BAO_Query->savedSearch((Array:5))
#12 /home/www/mysite.com/sites/all/modules/civicrm/CRM/Contact/BAO/Query.php(1556): CRM_Contact_BAO_Query->group((Array:5))
#13 /home/www/mysite.com/sites/all/modules/civicrm/CRM/Contact/BAO/Query.php(1784): CRM_Contact_BAO_Query->whereClauseSingle((Array:5))
#14 /home/www/mysite.com/sites/all/modules/civicrm/CRM/Contact/BAO/Query.php(505): CRM_Contact_BAO_Query->whereClause()
#15 /home/www/mysite.com/sites/all/modules/civicrm/CRM/Contact/BAO/Query.php(466): CRM_Contact_BAO_Query->initialize()
#16 /home/www/mysite.com/sites/all/modules/civicrm/CRM/Contact/BAO/Query.php(4180): CRM_Contact_BAO_Query->__construct((Array:1), (Array:1), NULL, TRUE, FALSE, 1, TRUE, TRUE, FALSE)
#17 /home/www/mysite.com/sites/all/modules/civicrm/CRM/Contact/BAO/Group.php(211): CRM_Contact_BAO_Query::apiQuery((Array:1), (Array:1), NULL, NULL, 0, 0, FALSE)
#18 /home/www/mysite.com/sites/all/modules/civicrm/CRM/Contact/BAO/GroupContactCache.php(517): CRM_Contact_BAO_Group::getMember("211", FALSE)
#19 /home/www/mysite.com/sites/all/modules/civicrm/CRM/Contact/BAO/Query.php(2763): CRM_Contact_BAO_GroupContactCache::load(Object(CRM_Core_DAO))
#20 /home/www/mysite.com/sites/all/modules/civicrm/CRM/Contact/BAO/Query.php(2729): CRM_Contact_BAO_Query->addGroupContactCache((Array:1))
#21 /home/www/mysite.com/sites/all/modules/civicrm/CRM/Contact/BAO/Query.php(2695): CRM_Contact_BAO_Query->savedSearch((Array:5))
#22 /home/www/mysite.com/sites/all/modules/civicrm/CRM/Contact/BAO/Query.php(1556): CRM_Contact_BAO_Query->group((Array:5))
#23 /home/www/mysite.com/sites/all/modules/civicrm/CRM/Contact/BAO/Query.php(1784): CRM_Contact_BAO_Query->whereClauseSingle((Array:5))
#24 /home/www/mysite.com/sites/all/modules/civicrm/CRM/Contact/BAO/Query.php(505): CRM_Contact_BAO_Query->whereClause()
#25 /home/www/mysite.com/sites/all/modules/civicrm/CRM/Contact/BAO/Query.php(466): CRM_Contact_BAO_Query->initialize()
#26 /home/www/mysite.com/sites/all/modules/civicrm/CRM/Contact/BAO/Query.php(4180): CRM_Contact_BAO_Query->__construct((Array:1), (Array:1), NULL, TRUE, FALSE, 1, TRUE, TRUE, FALSE)
#27 /home/www/mysite.com/sites/all/modules/civicrm/CRM/Contact/BAO/GroupContactCache.php(202): CRM_Contact_BAO_Query::apiQuery((Array:1), (Array:1), NULL, NULL, 0, 0, FALSE)
#28 /home/www/mysite.com/sites/all/modules/civicrm/CRM/Contact/BAO/Group.php(454): CRM_Contact_BAO_GroupContactCache::add("95")
#29 /home/www/mysite.com/sites/all/modules/civicrm/CRM/Group/Form/Edit.php(454): CRM_Contact_BAO_Group::create((Array:16))
#30 /home/www/mysite.com/sites/all/modules/civicrm/CRM/Core/Form.php(261): CRM_Group_Form_Edit->postProcess()
#31 /home/www/mysite.com/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Upload.php(151): CRM_Core_Form->mainProcess()
#32 /home/www/mysite.com/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Upload.php(128): CRM_Core_QuickForm_Action_Upload->realPerform(Object(CRM_Group_Form_Edit), "upload")
#33 /home/www/mysite.com/sites/all/modules/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Upload->perform(Object(CRM_Group_Form_Edit), "upload")
#34 /home/www/mysite.com/sites/all/modules/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Group_Form_Edit), "upload")
#35 /home/www/mysite.com/sites/all/modules/civicrm/CRM/Core/Controller.php(339): HTML_QuickForm_Page->handle("upload")
#36 /home/www/mysite.com/sites/all/modules/civicrm/CRM/Core/Page/Basic.php(381): CRM_Core_Controller->run()
#37 /home/www/mysite.com/sites/all/modules/civicrm/CRM/Core/Page/Basic.php(178): CRM_Core_Page_Basic->edit(2, "183")
#38 /home/www/mysite.com/sites/all/modules/civicrm/CRM/Core/Invoke.php(323): CRM_Core_Page_Basic->run((Array:2), NULL)
#39 /home/www/mysite.com/sites/all/modules/civicrm/CRM/Core/Invoke.php(72): CRM_Core_Invoke::runItem((Array:13))
#40 /home/www/mysite.com/sites/all/modules/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:2))
#41 /home/www/mysite.com/sites/all/modules/civicrm/drupal/civicrm.module(457): CRM_Core_Invoke::invoke((Array:2))
#42 [internal function](): civicrm_invoke("group")
#43 /home/www/mysite.com/includes/menu.inc(517): call_user_func_array("civicrm_invoke", (Array:1))
#44 /home/www/mysite.com/index.php(21): menu_execute_active_handler()
#45 {main}
I've been poking around in the source but can't really find a cause for this.

I've tried duplicating the same error on a backup host with the exact same codebase but was unable to do so. I then tried copying the DB from the original to the backup host and the issue arose again. So it does seem to be something in my DB.

We are running 4.4.11 with Drupal 7 and all updates/patches applied. Has anyone else seen anything like this?

Cheers,

Conor