Remove from groups is action is broken when searching of contacts within a group
When you get a list of contacts within a group by going to contacts -> manage groups -> contacts and then go and select a contact and then select contacts - remove from groups it fails on a DB syntax error. However doing a similar thing via advanced search works. It looks like the prevNextCache is not getting populated sensibly
Error and backtrace
[to_string] => [db_error: message="DB Error: syntax error" code=-2 mode=callback callback=CRM_Core_Error::exceptionHandler prefix="" info="SELECT *
FROM civicrm_contact
WHERE (id IN ())
[nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '))' at line 3]"]
)
Jun 26 08:02:55 [info] $backTrace = #0 /home/seamus/buildkit/build/47-test/sites/all/modules/civicrm/CRM/Core/Error.php(952): CRM_Core_Error::backtrace("backTrace", TRUE)
#1 /home/seamus/buildkit/build/47-test/sites/all/modules/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php(922): CRM_Core_Error::exceptionHandler(Object(DB_Error))
#2 /home/seamus/buildkit/build/47-test/sites/all/modules/civicrm/packages/DB.php(985): PEAR_Error->__construct("DB Error: syntax error", -2, 16, (Array:2), "SELECT *\nFROM civicrm_contact\nWHERE (id IN ())\n [nativecode=1064 ** You ha...")
#3 /home/seamus/buildkit/build/47-test/sites/all/modules/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php(575): DB_Error->__construct(-2, 16, (Array:2), "SELECT *\nFROM civicrm_contact\nWHERE (id IN ())\n [nativecode=1064 ** You ha...")
#4 /home/seamus/buildkit/build/47-test/sites/all/modules/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php(223): PEAR->_raiseError(Object(DB_mysqli), NULL, -2, 16, (Array:2), "SELECT *\nFROM civicrm_contact\nWHERE (id IN ())\n [nativecode=1064 ** You ha...", "DB_Error", TRUE)
#5 /home/seamus/buildkit/build/47-test/sites/all/modules/civicrm/packages/DB/common.php(1907): PEAR->__call("raiseError", (Array:7))
#6 /home/seamus/buildkit/build/47-test/sites/all/modules/civicrm/packages/DB/mysqli.php(933): DB_common->raiseError(-2, NULL, NULL, "SELECT *\nFROM civicrm_contact\nWHERE (id IN ())\n [nativecode=1064 ** You ha...", "1064 ** You have an error in your SQL syntax; check the manual that correspon...")
#7 /home/seamus/buildkit/build/47-test/sites/all/modules/civicrm/packages/DB/mysqli.php(403): DB_mysqli->mysqliRaiseError()
#8 /home/seamus/buildkit/build/47-test/sites/all/modules/civicrm/packages/DB/common.php(1216): DB_mysqli->simpleQuery("SELECT *\nFROM civicrm_contact\nWHERE (id IN ())\n")
#9 /home/seamus/buildkit/build/47-test/sites/all/modules/civicrm/packages/DB/DataObject.php(2415): DB_common->query("SELECT *\nFROM civicrm_contact\nWHERE (id IN ())\n")
#10 /home/seamus/buildkit/build/47-test/sites/all/modules/civicrm/packages/DB/DataObject.php(1607): DB_DataObject->_query("SELECT *\nFROM civicrm_contact\nWHERE (id IN ())\n")
#11 /home/seamus/buildkit/build/47-test/sites/all/modules/civicrm/CRM/Core/DAO.php(439): DB_DataObject->query("SELECT *\nFROM civicrm_contact\nWHERE (id IN ())\n")
#12 /home/seamus/buildkit/build/47-test/sites/all/modules/civicrm/CRM/Core/DAO.php(1414): CRM_Core_DAO->query("SELECT *\nFROM civicrm_contact\nWHERE (id IN ())\n", TRUE)
#13 /home/seamus/buildkit/build/47-test/sites/all/modules/civicrm/CRM/Utils/SQL/Select.php(517): CRM_Core_DAO::executeQuery("SELECT *\nFROM civicrm_contact\nWHERE (id IN ())\n", (Array:0), TRUE, NULL, FALSE, TRUE, FALSE)
#14 /home/seamus/buildkit/build/47-test/sites/all/modules/civicrm/CRM/Contact/Form/Task.php(491): CRM_Utils_SQL_Select->execute()
#15 /home/seamus/buildkit/build/47-test/sites/all/modules/civicrm/CRM/Contact/Form/Task.php(272): CRM_Contact_Form_Task::getSelectedContactNames()
#16 /home/seamus/buildkit/build/47-test/sites/all/modules/civicrm/CRM/Contact/Form/Task.php(91): CRM_Contact_Form_Task::preProcessCommon(Object(CRM_Contact_Form_Task_RemoveFromGroup))
#17 /home/seamus/buildkit/build/47-test/sites/all/modules/civicrm/CRM/Core/Form.php(590): CRM_Contact_Form_Task->preProcess()
#18 /home/seamus/buildkit/build/47-test/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Display.php(92): CRM_Core_Form->buildForm()
#19 /home/seamus/buildkit/build/47-test/sites/all/modules/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Display->perform(Object(CRM_Contact_Form_Task_RemoveFromGroup), "display")
#20 /home/seamus/buildkit/build/47-test/sites/all/modules/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Contact_Form_Task_RemoveFromGroup), "display")
#21 /home/seamus/buildkit/build/47-test/sites/all/modules/civicrm/CRM/Core/Controller.php(351): HTML_QuickForm_Page->handle("display")
#22 /home/seamus/buildkit/build/47-test/sites/all/modules/civicrm/CRM/Core/Invoke.php(311): CRM_Core_Controller->run((Array:3), (Array:0))
#23 /home/seamus/buildkit/build/47-test/sites/all/modules/civicrm/CRM/Core/Invoke.php(85): CRM_Core_Invoke::runItem((Array:14))
#24 /home/seamus/buildkit/build/47-test/sites/all/modules/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:3))
#25 /home/seamus/buildkit/build/47-test/sites/all/modules/civicrm/drupal/civicrm.module(444): CRM_Core_Invoke::invoke((Array:3))
#26 /home/seamus/buildkit/build/47-test/includes/menu.inc(527): civicrm_invoke("group", "search")
#27 /home/seamus/buildkit/build/47-test/index.php(21): menu_execute_active_handler()