SHARE
TWEET

Email search error

andyburns Jun 9th, 2019 382 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Here is the backtrace:
  2.  
  3. #0 www/wp-content/plugins/civicrm/civicrm/CRM/Core/Error.php(192): CRM_Core_Error::backtrace()
  4. #1 www/wp-content/plugins/civicrm/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php(922): CRM_Core_Error::handle(Object(DB_Error))
  5. #2 www/wp-content/plugins/civicrm/civicrm/packages/DB.php(985): PEAR_Error->__construct("DB Error: no such field", -19, 16, (Array:2), "SELECT DISTINCT LEFT(contact_a.sort_name, 1) as sort_name\n       FROM civicr...")
  6. #3 www/wp-content/plugins/civicrm/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php(575): DB_Error->__construct(-19, 16, (Array:2), "SELECT DISTINCT LEFT(contact_a.sort_name, 1) as sort_name\n       FROM civicr...")
  7. #4 www/wp-content/plugins/civicrm/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php(223): PEAR->_raiseError(Object(DB_mysqli), NULL, -19, 16, (Array:2), "SELECT DISTINCT LEFT(contact_a.sort_name, 1) as sort_name\n       FROM civicr...", "DB_Error", TRUE)
  8. #5 www/wp-content/plugins/civicrm/civicrm/packages/DB/common.php(1907): PEAR->__call("raiseError", (Array:7))
  9. #6 www/wp-content/plugins/civicrm/civicrm/packages/DB/mysqli.php(933): DB_common->raiseError(-19, NULL, NULL, "SELECT DISTINCT LEFT(contact_a.sort_name, 1) as sort_name\n       FROM civicr...", "1054 ** Unknown column '1-address.location_type_id' in 'on clause'")
  10. #7 www/wp-content/plugins/civicrm/civicrm/packages/DB/mysqli.php(403): DB_mysqli->mysqliRaiseError()
  11. #8 www/wp-content/plugins/civicrm/civicrm/packages/DB/common.php(1216): DB_mysqli->simpleQuery("SELECT DISTINCT LEFT(contact_a.sort_name, 1) as sort_name\n       FROM civicr...")
  12. #9 www/wp-content/plugins/civicrm/civicrm/packages/DB/DataObject.php(2415): DB_common->query("SELECT DISTINCT LEFT(contact_a.sort_name, 1) as sort_name\n       FROM civicr...")
  13. #10 www/wp-content/plugins/civicrm/civicrm/packages/DB/DataObject.php(1607): DB_DataObject->_query("SELECT DISTINCT LEFT(contact_a.sort_name, 1) as sort_name\n       FROM civicr...")
  14. #11 www/wp-content/plugins/civicrm/civicrm/CRM/Core/DAO.php(439): DB_DataObject->query("SELECT DISTINCT LEFT(contact_a.sort_name, 1) as sort_name\n       FROM civicr...")
  15. #12 www/wp-content/plugins/civicrm/civicrm/CRM/Core/DAO.php(1414): CRM_Core_DAO->query("SELECT DISTINCT LEFT(contact_a.sort_name, 1) as sort_name\n       FROM civicr...", TRUE)
  16. #13 www/wp-content/plugins/civicrm/civicrm/CRM/Contact/BAO/Query.php(4960): CRM_Core_DAO::executeQuery("SELECT DISTINCT LEFT(contact_a.sort_name, 1) as sort_name\n       FROM civicr...")
  17. #14 www/wp-content/plugins/civicrm/civicrm/CRM/Contact/Selector.php(1194): CRM_Contact_BAO_Query->alphabetQuery()
  18. #15 www/wp-content/plugins/civicrm/civicrm/CRM/Utils/PagerAToZ.php(108): CRM_Contact_Selector->alphabetQuery()
  19. #16 www/wp-content/plugins/civicrm/civicrm/CRM/Utils/PagerAToZ.php(136): CRM_Utils_PagerAToZ::getDynamicCharacters(Object(CRM_Contact_Selector), FALSE)
  20. #17 www/wp-content/plugins/civicrm/civicrm/CRM/Utils/PagerAToZ.php(52): CRM_Utils_PagerAToZ::createLinks(Object(CRM_Contact_Selector), NULL, FALSE)
  21. #18 www/wp-content/plugins/civicrm/civicrm/CRM/Contact/Form/Search.php(870): CRM_Utils_PagerAToZ::getAToZBar(Object(CRM_Contact_Selector), NULL)
  22. #19 www/wp-content/plugins/civicrm/civicrm/CRM/Contact/Form/Search/Advanced.php(320): CRM_Contact_Form_Search->postProcess()
  23. #20 www/wp-content/plugins/civicrm/civicrm/CRM/Core/Form.php(490): CRM_Contact_Form_Search_Advanced->postProcess()
  24. #21 www/wp-content/plugins/civicrm/civicrm/CRM/Core/QuickForm/Action/Refresh.php(75): CRM_Core_Form->mainProcess()
  25. #22 www/wp-content/plugins/civicrm/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Refresh->perform(Object(CRM_Contact_Form_Search_Advanced), "refresh")
  26. #23 www/wp-content/plugins/civicrm/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Contact_Form_Search_Advanced), "refresh")
  27. #24 www/wp-content/plugins/civicrm/civicrm/CRM/Core/Controller.php(349): HTML_QuickForm_Page->handle("refresh")
  28. #25 www/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(311): CRM_Core_Controller->run((Array:4), (Array:0))
  29. #26 www/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(85): CRM_Core_Invoke::runItem((Array:13))
  30. #27 www/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:4))
  31. #28 www/wp-content/plugins/civicrm/civicrm.php(1392): CRM_Core_Invoke::invoke((Array:4))
  32. #29 www/wp-includes/class-wp-hook.php(286): CiviCRM_For_WordPress->invoke("")
  33. #30 www/wp-includes/class-wp-hook.php(310): WP_Hook->apply_filters("", (Array:1))
  34. #31 www/wp-includes/plugin.php(465): WP_Hook->do_action((Array:1))
  35. #32 www/wp-admin/admin.php(253): do_action("toplevel_page_CiviCRM")
  36. #33 {main}
  37.  
  38. Error details:
  39. Database Error Code: Unknown column '1-address.location_type_id' in 'on clause', 1054
  40. Additional Details:
  41.  
  42. Array
  43. (
  44.     [callback] => Array
  45.         (
  46.             [0] => CRM_Core_Error
  47.             [1] => handle
  48.         )
  49.  
  50.     [code] => -19
  51.     [message] => DB Error: no such field
  52.     [mode] => 16
  53.     [debug_info] => SELECT DISTINCT LEFT(contact_a.sort_name, 1) as sort_name
  54.        FROM civicrm_contact contact_a
  55. LEFT JOIN civicrm_email `1-email` ON contact_a.id = `1-email`.contact_id AND `1-email`.is_primary = 1  LEFT JOIN civicrm_email ON (contact_a.id = civicrm_email.contact_id AND civicrm_email.is_primary = 1)
  56. LEFT JOIN civicrm_location_type `1-location_type` ON (  ( `1-address`.location_type_id = `1-location_type`.id )  )
  57.       WHERE  ( civicrm_email.email LIKE '%data%' )  AND (contact_a.is_deleted = 0)
  58.      
  59.       GROUP BY sort_name
  60.       ORDER BY sort_name asc [nativecode=1054 ** Unknown column '1-address.location_type_id' in 'on clause']
  61.     [type] => DB_Error
  62.     [user_info] => SELECT DISTINCT LEFT(contact_a.sort_name, 1) as sort_name
  63.        FROM civicrm_contact contact_a
  64. LEFT JOIN civicrm_email `1-email` ON contact_a.id = `1-email`.contact_id AND `1-email`.is_primary = 1  LEFT JOIN civicrm_email ON (contact_a.id = civicrm_email.contact_id AND civicrm_email.is_primary = 1)
  65. LEFT JOIN civicrm_location_type `1-location_type` ON (  ( `1-address`.location_type_id = `1-location_type`.id )  )
  66.       WHERE  ( civicrm_email.email LIKE '%data%' )  AND (contact_a.is_deleted = 0)
  67.      
  68.       GROUP BY sort_name
  69.       ORDER BY sort_name asc [nativecode=1054 ** Unknown column '1-address.location_type_id' in 'on clause']
  70.     [to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT DISTINCT LEFT(contact_a.sort_name, 1) as sort_name
  71.        FROM civicrm_contact contact_a
  72. LEFT JOIN civicrm_email `1-email` ON contact_a.id = `1-email`.contact_id AND `1-email`.is_primary = 1  LEFT JOIN civicrm_email ON (contact_a.id = civicrm_email.contact_id AND civicrm_email.is_primary = 1)
  73. LEFT JOIN civicrm_location_type `1-location_type` ON (  ( `1-address`.location_type_id = `1-location_type`.id )  )
  74.       WHERE  ( civicrm_email.email LIKE '%data%' )  AND (contact_a.is_deleted = 0)
  75.      
  76.       GROUP BY sort_name
  77.       ORDER BY sort_name asc [nativecode=1054 ** Unknown column '1-address.location_type_id' in 'on clause']"]
  78. )
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Top