Error FieldError Value
TypeDB_Error
Code-1
MessageDB Error: unknown error
Mode16
UserInfoSELECT contact_a.id as contact_id, contact_a.contact_type as contact_type, contact_a.contact_sub_type as contact_sub_type, contact_a.sort_name as sort_name, contact_a.last_name as `last_name`, contact_a.first_name as `first_name`, IF ( contact_a.contact_type = 'Individual', contact_a.organization_name, NULL ) as current_employer, civicrm_address.id as address_id, civicrm_address.state_province_id as state_province_id, `1-location_type`.id as `1-location_type_id`, `1-location_type`.name as `1-location_type`, `1-address`.id as `1-address_id`, `1-address`.city as `1-city`, `1-address`.state_province_id as `1-state_province_id`, `1-address`.country_id as `1-country_id`, `1-address`.postal_code as `1-postal_code`, civicrm_value_interests_15.id as civicrm_value_interests_15_id, civicrm_value_interests_15.interests_62 as custom_62, civicrm_state_province.name as `state_province-Primary`, `1-state_province`.abbreviation as `1-state_province` FROM civicrm_contact contact_a LEFT JOIN civicrm_address `1-address` ON (`1-address`.contact_id = contact_a.id AND `1-address`.is_primary = 1) LEFT JOIN civicrm_address ON ( contact_a.id = civicrm_address.contact_id AND civicrm_address.is_primary = 1 ) LEFT JOIN civicrm_state_province ON ( civicrm_address.state_province_id = civicrm_state_province.id ) LEFT JOIN civicrm_location_type `1-location_type` ON ( ( `1-address`.location_type_id = `1-location_type`.id ) OR ( `1-address`.location_type_id = `1-location_type`.id ) OR ( `1-address`.location_type_id = `1-location_type`.id ) OR ( `1-address`.location_type_id = `1-location_type`.id ) ) LEFT JOIN civicrm_group_contact_cache civicrm_group_contact_cache_6605953f13df1 ON contact_a.id = civicrm_group_contact_cache_6605953f13df1.contact_id LEFT JOIN civicrm_value_interests_15 ON civicrm_value_interests_15.entity_id = `contact_a`.id LEFT JOIN civicrm_state_province ON civicrm_address.state_province_id = civicrm_state_province.id LEFT JOIN civicrm_state_province `1-state_province` ON `1-state_province`.id = `1-address`.state_province_id WHERE ( civicrm_address.state_province_id = '1624' AND ( ( civicrm_group_contact_cache_6605953f13df1.group_id IN ("2") ) ) ) AND (contact_a.is_deleted = 0) AND contact_a.is_deleted = 0 GROUP BY contact_a.id ORDER BY `1-state_province` asc, `contact_a`.`id` LIMIT 0, 50 [nativecode=1066 ** Not unique table/alias: 'civicrm_state_province']
DebugInfoSELECT contact_a.id as contact_id, contact_a.contact_type as contact_type, contact_a.contact_sub_type as contact_sub_type, contact_a.sort_name as sort_name, contact_a.last_name as `last_name`, contact_a.first_name as `first_name`, IF ( contact_a.contact_type = 'Individual', contact_a.organization_name, NULL ) as current_employer, civicrm_address.id as address_id, civicrm_address.state_province_id as state_province_id, `1-location_type`.id as `1-location_type_id`, `1-location_type`.name as `1-location_type`, `1-address`.id as `1-address_id`, `1-address`.city as `1-city`, `1-address`.state_province_id as `1-state_province_id`, `1-address`.country_id as `1-country_id`, `1-address`.postal_code as `1-postal_code`, civicrm_value_interests_15.id as civicrm_value_interests_15_id, civicrm_value_interests_15.interests_62 as custom_62, civicrm_state_province.name as `state_province-Primary`, `1-state_province`.abbreviation as `1-state_province` FROM civicrm_contact contact_a LEFT JOIN civicrm_address `1-address` ON (`1-address`.contact_id = contact_a.id AND `1-address`.is_primary = 1) LEFT JOIN civicrm_address ON ( contact_a.id = civicrm_address.contact_id AND civicrm_address.is_primary = 1 ) LEFT JOIN civicrm_state_province ON ( civicrm_address.state_province_id = civicrm_state_province.id ) LEFT JOIN civicrm_location_type `1-location_type` ON ( ( `1-address`.location_type_id = `1-location_type`.id ) OR ( `1-address`.location_type_id = `1-location_type`.id ) OR ( `1-address`.location_type_id = `1-location_type`.id ) OR ( `1-address`.location_type_id = `1-location_type`.id ) ) LEFT JOIN civicrm_group_contact_cache civicrm_group_contact_cache_6605953f13df1 ON contact_a.id = civicrm_group_contact_cache_6605953f13df1.contact_id LEFT JOIN civicrm_value_interests_15 ON civicrm_value_interests_15.entity_id = `contact_a`.id LEFT JOIN civicrm_state_province ON civicrm_address.state_province_id = civicrm_state_province.id LEFT JOIN civicrm_state_province `1-state_province` ON `1-state_province`.id = `1-address`.state_province_id WHERE ( civicrm_address.state_province_id = '1624' AND ( ( civicrm_group_contact_cache_6605953f13df1.group_id IN ("2") ) ) ) AND (contact_a.is_deleted = 0) AND contact_a.is_deleted = 0 GROUP BY contact_a.id ORDER BY `1-state_province` asc, `contact_a`.`id` LIMIT 0, 50 [nativecode=1066 ** Not unique table/alias: 'civicrm_state_province']
PEAR_Exception: DB Error: unknown error in /home/econbot/domains/payments.econbot.org/public_html/sites/all/modules/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php on line 922
- DB_Error: DB Error: unknown error in unknown on line unknown
Exception trace
#FunctionLocation
0CRM_Core_Error::exceptionHandler()/home/econbot/domains/payments.econbot.org/public_html/sites/all/modules/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php:922
1PEAR_Error->__construct()/home/econbot/domains/payments.econbot.org/public_html/sites/all/modules/civicrm/vendor/pear/db/DB.php:997
2DB_Error->__construct()/home/econbot/domains/payments.econbot.org/public_html/sites/all/modules/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php:575
3PEAR::_raiseError()/home/econbot/domains/payments.econbot.org/public_html/sites/all/modules/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php:223
4PEAR->__call()/home/econbot/domains/payments.econbot.org/public_html/sites/all/modules/civicrm/vendor/pear/db/DB/common.php:1928
5DB_common->raiseError()/home/econbot/domains/payments.econbot.org/public_html/sites/all/modules/civicrm/vendor/pear/db/DB/mysqli.php:936
6DB_mysqli->mysqliRaiseError()/home/econbot/domains/payments.econbot.org/public_html/sites/all/modules/civicrm/vendor/pear/db/DB/mysqli.php:406
7DB_mysqli->simpleQuery()/home/econbot/domains/payments.econbot.org/public_html/sites/all/modules/civicrm/vendor/pear/db/DB/common.php:1234
8DB_common->query()/home/econbot/domains/payments.econbot.org/public_html/sites/all/modules/civicrm/packages/DB/DataObject.php:2696
9DB_DataObject->_query()/home/econbot/domains/payments.econbot.org/public_html/sites/all/modules/civicrm/packages/DB/DataObject.php:1829
10DB_DataObject->query()/home/econbot/domains/payments.econbot.org/public_html/sites/all/modules/civicrm/CRM/Core/DAO.php:472
11CRM_Core_DAO->query()/home/econbot/domains/payments.econbot.org/public_html/sites/all/modules/civicrm/CRM/Core/DAO.php:1637
12CRM_Core_DAO::executeQuery()/home/econbot/domains/payments.econbot.org/public_html/sites/all/modules/civicrm/CRM/Contact/BAO/Query.php:4980
13CRM_Contact_BAO_Query->searchQuery()/home/econbot/domains/payments.econbot.org/public_html/sites/all/modules/civicrm/CRM/Profile/Selector/Listings.php:463
14CRM_Profile_Selector_Listings->getRows()/home/econbot/domains/payments.econbot.org/public_html/sites/all/modules/civicrm/CRM/Core/Selector/Controller.php:404
15CRM_Core_Selector_Controller->getRows()/home/econbot/domains/payments.econbot.org/public_html/sites/all/modules/civicrm/CRM/Core/Selector/Controller.php:326
16CRM_Core_Selector_Controller->run()/home/econbot/domains/payments.econbot.org/public_html/sites/all/modules/civicrm/CRM/Profile/Page/Listings.php:382
17CRM_Profile_Page_Listings->run()/home/econbot/domains/payments.econbot.org/public_html/sites/all/modules/civicrm/CRM/Profile/Page/Router.php:107
18CRM_Profile_Page_Router->run()/home/econbot/domains/payments.econbot.org/public_html/sites/all/modules/civicrm/CRM/Core/Invoke.php:319
19CRM_Core_Invoke::runItem()/home/econbot/domains/payments.econbot.org/public_html/sites/all/modules/civicrm/CRM/Core/Invoke.php:69
20CRM_Core_Invoke::_invoke()/home/econbot/domains/payments.econbot.org/public_html/sites/all/modules/civicrm/CRM/Core/Invoke.php:36
21CRM_Core_Invoke::invoke()/home/econbot/domains/payments.econbot.org/public_html/sites/all/modules/civicrm/drupal/civicrm.module:471
22civicrm_invoke()/home/econbot/domains/payments.econbot.org/public_html/includes/menu.inc:527
23menu_execute_active_handler()/home/econbot/domains/payments.econbot.org/public_html/index.php:21
24{main} 
Sorry, due to an error, we are unable to fulfill your request at the moment. You may want to contact your administrator or service provider with more details about what action you were performing when this occurred.
DB Error: unknown error

Return to home page.