Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Here is the backtrace:
- #0 www/wp-content/plugins/civicrm/civicrm/CRM/Core/Error.php(192): CRM_Core_Error::backtrace()
- #1 www/wp-content/plugins/civicrm/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php(922): CRM_Core_Error::handle(Object(DB_Error))
- #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...")
- #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...")
- #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)
- #5 www/wp-content/plugins/civicrm/civicrm/packages/DB/common.php(1907): PEAR->__call("raiseError", (Array:7))
- #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'")
- #7 www/wp-content/plugins/civicrm/civicrm/packages/DB/mysqli.php(403): DB_mysqli->mysqliRaiseError()
- #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...")
- #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...")
- #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...")
- #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...")
- #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)
- #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...")
- #14 www/wp-content/plugins/civicrm/civicrm/CRM/Contact/Selector.php(1194): CRM_Contact_BAO_Query->alphabetQuery()
- #15 www/wp-content/plugins/civicrm/civicrm/CRM/Utils/PagerAToZ.php(108): CRM_Contact_Selector->alphabetQuery()
- #16 www/wp-content/plugins/civicrm/civicrm/CRM/Utils/PagerAToZ.php(136): CRM_Utils_PagerAToZ::getDynamicCharacters(Object(CRM_Contact_Selector), FALSE)
- #17 www/wp-content/plugins/civicrm/civicrm/CRM/Utils/PagerAToZ.php(52): CRM_Utils_PagerAToZ::createLinks(Object(CRM_Contact_Selector), NULL, FALSE)
- #18 www/wp-content/plugins/civicrm/civicrm/CRM/Contact/Form/Search.php(870): CRM_Utils_PagerAToZ::getAToZBar(Object(CRM_Contact_Selector), NULL)
- #19 www/wp-content/plugins/civicrm/civicrm/CRM/Contact/Form/Search/Advanced.php(320): CRM_Contact_Form_Search->postProcess()
- #20 www/wp-content/plugins/civicrm/civicrm/CRM/Core/Form.php(490): CRM_Contact_Form_Search_Advanced->postProcess()
- #21 www/wp-content/plugins/civicrm/civicrm/CRM/Core/QuickForm/Action/Refresh.php(75): CRM_Core_Form->mainProcess()
- #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")
- #23 www/wp-content/plugins/civicrm/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Contact_Form_Search_Advanced), "refresh")
- #24 www/wp-content/plugins/civicrm/civicrm/CRM/Core/Controller.php(349): HTML_QuickForm_Page->handle("refresh")
- #25 www/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(311): CRM_Core_Controller->run((Array:4), (Array:0))
- #26 www/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(85): CRM_Core_Invoke::runItem((Array:13))
- #27 www/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:4))
- #28 www/wp-content/plugins/civicrm/civicrm.php(1392): CRM_Core_Invoke::invoke((Array:4))
- #29 www/wp-includes/class-wp-hook.php(286): CiviCRM_For_WordPress->invoke("")
- #30 www/wp-includes/class-wp-hook.php(310): WP_Hook->apply_filters("", (Array:1))
- #31 www/wp-includes/plugin.php(465): WP_Hook->do_action((Array:1))
- #32 www/wp-admin/admin.php(253): do_action("toplevel_page_CiviCRM")
- #33 {main}
- Error details:
- Database Error Code: Unknown column '1-address.location_type_id' in 'on clause', 1054
- Additional Details:
- Array
- (
- [callback] => Array
- (
- [0] => CRM_Core_Error
- [1] => handle
- )
- [code] => -19
- [message] => DB Error: no such field
- [mode] => 16
- [debug_info] => SELECT DISTINCT LEFT(contact_a.sort_name, 1) as sort_name
- FROM civicrm_contact contact_a
- 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)
- LEFT JOIN civicrm_location_type `1-location_type` ON ( ( `1-address`.location_type_id = `1-location_type`.id ) )
- WHERE ( civicrm_email.email LIKE '%data%' ) AND (contact_a.is_deleted = 0)
- GROUP BY sort_name
- ORDER BY sort_name asc [nativecode=1054 ** Unknown column '1-address.location_type_id' in 'on clause']
- [type] => DB_Error
- [user_info] => SELECT DISTINCT LEFT(contact_a.sort_name, 1) as sort_name
- FROM civicrm_contact contact_a
- 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)
- LEFT JOIN civicrm_location_type `1-location_type` ON ( ( `1-address`.location_type_id = `1-location_type`.id ) )
- WHERE ( civicrm_email.email LIKE '%data%' ) AND (contact_a.is_deleted = 0)
- GROUP BY sort_name
- ORDER BY sort_name asc [nativecode=1054 ** Unknown column '1-address.location_type_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="SELECT DISTINCT LEFT(contact_a.sort_name, 1) as sort_name
- FROM civicrm_contact contact_a
- 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)
- LEFT JOIN civicrm_location_type `1-location_type` ON ( ( `1-address`.location_type_id = `1-location_type`.id ) )
- WHERE ( civicrm_email.email LIKE '%data%' ) AND (contact_a.is_deleted = 0)
- GROUP BY sort_name
- ORDER BY sort_name asc [nativecode=1054 ** Unknown column '1-address.location_type_id' in 'on clause']"]
- )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement