Skip to content
Snippets Groups Projects
New look: Off

"Network Error" when sorting contact search results by City, Postcode or Country

    • Closed Issue created by jern @jern

    If you search for contacts and then try to sort the result list by clicking on City, Postcode or Country, a "Network Error Unable to reach the server. Please refresh this page in your browser and try again." modal window appears. Sorting by Name or Email is fine. This error was found in 5.30.0 (WP), but it's also present in the WP sandbox version 5.32. According to @haystack also in Drupal.

    To upload designs, you'll need to enable LFS and have an admin enable hashed storage. More information

    Child items ...

    • Activity

    • haystack
      haystack @haystack ·
      Developer

      Thanks @jern. The error (in WordPress but replicable in Drupal) is:

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

    [code] => -19
    [message] => DB Error: no such field
    [mode] => 16
    [debug_info] => 
INSERT INTO civicrm_prevnext_cache (cachekey, entity_id1, data)
SELECT DISTINCT 'civicrm search ff6dacd103ff0e7908a99f9e00a86f3a6c536c5fdd5f7a2b83f051e1e7a5a734_3183', contact_a.id, contact_a.sort_name  FROM civicrm_contact contact_a   LEFT JOIN civicrm_country ON civicrm_address.country_id = civicrm_country.id  WHERE (contact_a.is_deleted = 0)    ORDER BY `country` asc, `contact_a`.`id`  LIMIT 0, 500 [nativecode=1054 ** Unknown column 'civicrm_address.country_id' in 'on clause']
    [type] => DB_Error
    [user_info] => 
INSERT INTO civicrm_prevnext_cache (cachekey, entity_id1, data)
SELECT DISTINCT 'civicrm search ff6dacd103ff0e7908a99f9e00a86f3a6c536c5fdd5f7a2b83f051e1e7a5a734_3183', contact_a.id, contact_a.sort_name  FROM civicrm_contact contact_a   LEFT JOIN civicrm_country ON civicrm_address.country_id = civicrm_country.id  WHERE (contact_a.is_deleted = 0)    ORDER BY `country` asc, `contact_a`.`id`  LIMIT 0, 500 [nativecode=1054 ** Unknown column 'civicrm_address.country_id' in 'on clause']
    [to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="
INSERT INTO civicrm_prevnext_cache (cachekey, entity_id1, data)
SELECT DISTINCT 'civicrm search ff6dacd103ff0e7908a99f9e00a86f3a6c536c5fdd5f7a2b83f051e1e7a5a734_3183', contact_a.id, contact_a.sort_name  FROM civicrm_contact contact_a   LEFT JOIN civicrm_country ON civicrm_address.country_id = civicrm_country.id  WHERE (contact_a.is_deleted = 0)    ORDER BY `country` asc, `contact_a`.`id`  LIMIT 0, 500 [nativecode=1054 ** Unknown column 'civicrm_address.country_id' in 'on clause']"]
)


Oct 19 12:05:03  [debug] $backTrace = #0 /path/to/httpdocs/wp-content/plugins/civicrm/civicrm/CRM/Core/Error.php(205): CRM_Core_Error::backtrace("backTrace", TRUE)
#1 /path/to/httpdocs/wp-content/plugins/civicrm/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php(922): CRM_Core_Error::handle(Object(DB_Error))
#2 /path/to/httpdocs/wp-content/plugins/civicrm/civicrm/vendor/pear/db/DB.php(997): PEAR_Error->__construct("DB Error: no such field", -19, 16, (Array:2), "\nINSERT INTO civicrm_prevnext_cache (cachekey, entity_id1, data)\nSELECT DIS...")
#3 /path/to/httpdocs/wp-content/plugins/civicrm/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php(575): DB_Error->__construct(-19, 16, (Array:2), "\nINSERT INTO civicrm_prevnext_cache (cachekey, entity_id1, data)\nSELECT DIS...")
#4 /path/to/httpdocs/wp-content/plugins/civicrm/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php(223): PEAR->_raiseError(Object(DB_mysqli), NULL, -19, 16, (Array:2), "\nINSERT INTO civicrm_prevnext_cache (cachekey, entity_id1, data)\nSELECT DIS...", "DB_Error", TRUE)
#5 /path/to/httpdocs/wp-content/plugins/civicrm/civicrm/vendor/pear/db/DB/common.php(1928): PEAR->__call("raiseError", (Array:7))
#6 /path/to/httpdocs/wp-content/plugins/civicrm/civicrm/vendor/pear/db/DB/mysqli.php(936): DB_common->raiseError(-19, NULL, NULL, "\nINSERT INTO civicrm_prevnext_cache (cachekey, entity_id1, data)\nSELECT DIS...", "1054 ** Unknown column 'civicrm_address.country_id' in 'on clause'")
#7 /path/to/httpdocs/wp-content/plugins/civicrm/civicrm/vendor/pear/db/DB/mysqli.php(406): DB_mysqli->mysqliRaiseError()
#8 /path/to/httpdocs/wp-content/plugins/civicrm/civicrm/vendor/pear/db/DB/common.php(1234): DB_mysqli->simpleQuery("\nINSERT INTO civicrm_prevnext_cache (cachekey, entity_id1, data)\nSELECT DIS...")
#9 /path/to/httpdocs/wp-content/plugins/civicrm/civicrm/packages/DB/DataObject.php(2696): DB_common->query("\nINSERT INTO civicrm_prevnext_cache (cachekey, entity_id1, data)\nSELECT DIS...")
#10 /path/to/httpdocs/wp-content/plugins/civicrm/civicrm/packages/DB/DataObject.php(1829): DB_DataObject->_query("\nINSERT INTO civicrm_prevnext_cache (cachekey, entity_id1, data)\nSELECT DIS...")
#11 /path/to/httpdocs/wp-content/plugins/civicrm/civicrm/CRM/Core/DAO.php(457): DB_DataObject->query("\nINSERT INTO civicrm_prevnext_cache (cachekey, entity_id1, data)\nSELECT DIS...")
#12 /path/to/httpdocs/wp-content/plugins/civicrm/civicrm/CRM/Core/DAO.php(1563): CRM_Core_DAO->query("\nINSERT INTO civicrm_prevnext_cache (cachekey, entity_id1, data)\nSELECT DIS...", TRUE)
#13 /path/to/httpdocs/wp-content/plugins/civicrm/civicrm/CRM/Core/PrevNextCache/Sql.php(43): CRM_Core_DAO::executeQuery("\nINSERT INTO civicrm_prevnext_cache (cachekey, entity_id1, data)\nSELECT DIS...", (Array:0), FALSE)
#14 /path/to/httpdocs/wp-content/plugins/civicrm/civicrm/CRM/Contact/Selector.php(1047): CRM_Core_PrevNextCache_Sql->fillWithSql("civicrm search ff6dacd103ff0e7908a99f9e00a86f3a6c536c5fdd5f7a2b83f051e1e7a5a7...", "SELECT DISTINCT 'civicrm search ff6dacd103ff0e7908a99f9e00a86f3a6c536c5fdd5f7...")
#15 /path/to/httpdocs/wp-content/plugins/civicrm/civicrm/CRM/Contact/Selector.php(909): CRM_Contact_Selector->fillupPrevNextCache(Object(CRM_Utils_Sort), "civicrm search ff6dacd103ff0e7908a99f9e00a86f3a6c536c5fdd5f7a2b83f051e1e7a5a7...", 0, 500)
#16 /path/to/httpdocs/wp-content/plugins/civicrm/civicrm/CRM/Contact/Selector.php(574): CRM_Contact_Selector->buildPrevNextCache(Object(CRM_Utils_Sort))
#17 /path/to/httpdocs/wp-content/plugins/civicrm/civicrm/CRM/Core/Selector/Controller.php(402): CRM_Contact_Selector->getRows(4, 0, 50, Object(CRM_Utils_Sort), 1, NULL)
#18 /path/to/httpdocs/wp-content/plugins/civicrm/civicrm/CRM/Core/Selector/Controller.php(324): CRM_Core_Selector_Controller->getRows(Object(CRM_Contact_Selector_Controller))
#19 /path/to/httpdocs/wp-content/plugins/civicrm/civicrm/CRM/Contact/Form/Search.php(867): CRM_Core_Selector_Controller->run()
#20 /path/to/httpdocs/wp-content/plugins/civicrm/civicrm/CRM/Contact/Form/Search/Basic.php(179): CRM_Contact_Form_Search->postProcess()
#21 /path/to/httpdocs/wp-content/plugins/civicrm/civicrm/CRM/Contact/Form/Search.php(729): CRM_Contact_Form_Search_Basic->postProcess()
#22 /path/to/httpdocs/wp-content/plugins/civicrm/civicrm/CRM/Contact/Form/Search/Basic.php(125): CRM_Contact_Form_Search->preProcess()
#23 /path/to/httpdocs/wp-content/plugins/civicrm/civicrm/CRM/Core/Form.php(609): CRM_Contact_Form_Search_Basic->preProcess()
#24 /path/to/httpdocs/wp-content/plugins/civicrm/civicrm/CRM/Core/QuickForm/Action/Display.php(76): CRM_Core_Form->buildForm()
#25 /path/to/httpdocs/wp-content/plugins/civicrm/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Display->perform(Object(CRM_Contact_Form_Search_Basic), "display")
#26 /path/to/httpdocs/wp-content/plugins/civicrm/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Contact_Form_Search_Basic), "display")
#27 /path/to/httpdocs/wp-content/plugins/civicrm/civicrm/CRM/Core/Controller.php(347): HTML_QuickForm_Page->handle("display")
#28 /path/to/httpdocs/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(312): CRM_Core_Controller->run((Array:3), (Array:0))
#29 /path/to/httpdocs/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(68): CRM_Core_Invoke::runItem((Array:13))
#30 /path/to/httpdocs/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(36): CRM_Core_Invoke::_invoke((Array:3))
#31 /path/to/httpdocs/wp-content/plugins/civicrm/civicrm.php(1669): CRM_Core_Invoke::invoke((Array:3))
#32 /path/to/httpdocs/wp-includes/class-wp-hook.php(287): CiviCRM_For_WordPress->invoke("")
#33 /path/to/httpdocs/wp-includes/class-wp-hook.php(311): WP_Hook->apply_filters("", (Array:1))
#34 /path/to/httpdocs/wp-includes/plugin.php(478): WP_Hook->do_action((Array:1))
#35 /path/to/httpdocs/wp-admin/admin.php(259): do_action("toplevel_page_CiviCRM")
#36 {main}
    • haystack added regression label

      added regression label

    • eileen
      eileen @eileen ·
      Owner

      It looks like it's not joining in address table

    • eileen
      eileen @eileen ·
      Owner

      @jern @haystack I can reproduce the error - but I haven't found relevant recent changes - any idea when it last worked?

      I think I can see a fix but am not decided on whether to target the patch at the 5.31 rc (as we would for a recent regression) or master (which we would do for one that was 6 months old or so).

    • jern
      jern @jern ·
      Author

      @eileen I have a joomla installation of 5.29.0, and the error isn't there.

    • jern
      jern @jern ·
      Author

      5.29.1 is also OK - no error.

    • eileen
      eileen @eileen ·
      Owner

      this should fix it https://github.com/civicrm/civicrm-core/pull/18824

    • totten mentioned in commit 6dc40f32

      mentioned in commit 6dc40f32

    • totten mentioned in commit 5ee21cd1

      mentioned in commit 5ee21cd1

    • eileen closed

      closed

    Please register or sign in to reply