Error Field | Error Value |
---|---|
Type | DB_Error |
Code | -1 |
Message | DB Error: unknown error |
Mode | 16 |
UserInfo | SELECT 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_6606e41b1608d ON contact_a.id = civicrm_group_contact_cache_6606e41b1608d.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 = '3833' AND ( ( civicrm_group_contact_cache_6606e41b1608d.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'] |
DebugInfo | SELECT 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_6606e41b1608d ON contact_a.id = civicrm_group_contact_cache_6606e41b1608d.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 = '3833' AND ( ( civicrm_group_contact_cache_6606e41b1608d.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 | ||
# | Function | Location |
0 | CRM_Core_Error::exceptionHandler() | /home/econbot/domains/payments.econbot.org/public_html/sites/all/modules/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php:922 |
1 | PEAR_Error->__construct() | /home/econbot/domains/payments.econbot.org/public_html/sites/all/modules/civicrm/vendor/pear/db/DB.php:997 |
2 | DB_Error->__construct() | /home/econbot/domains/payments.econbot.org/public_html/sites/all/modules/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php:575 |
3 | PEAR::_raiseError() | /home/econbot/domains/payments.econbot.org/public_html/sites/all/modules/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php:223 |
4 | PEAR->__call() | /home/econbot/domains/payments.econbot.org/public_html/sites/all/modules/civicrm/vendor/pear/db/DB/common.php:1928 |
5 | DB_common->raiseError() | /home/econbot/domains/payments.econbot.org/public_html/sites/all/modules/civicrm/vendor/pear/db/DB/mysqli.php:936 |
6 | DB_mysqli->mysqliRaiseError() | /home/econbot/domains/payments.econbot.org/public_html/sites/all/modules/civicrm/vendor/pear/db/DB/mysqli.php:406 |
7 | DB_mysqli->simpleQuery() | /home/econbot/domains/payments.econbot.org/public_html/sites/all/modules/civicrm/vendor/pear/db/DB/common.php:1234 |
8 | DB_common->query() | /home/econbot/domains/payments.econbot.org/public_html/sites/all/modules/civicrm/packages/DB/DataObject.php:2696 |
9 | DB_DataObject->_query() | /home/econbot/domains/payments.econbot.org/public_html/sites/all/modules/civicrm/packages/DB/DataObject.php:1829 |
10 | DB_DataObject->query() | /home/econbot/domains/payments.econbot.org/public_html/sites/all/modules/civicrm/CRM/Core/DAO.php:472 |
11 | CRM_Core_DAO->query() | /home/econbot/domains/payments.econbot.org/public_html/sites/all/modules/civicrm/CRM/Core/DAO.php:1637 |
12 | CRM_Core_DAO::executeQuery() | /home/econbot/domains/payments.econbot.org/public_html/sites/all/modules/civicrm/CRM/Contact/BAO/Query.php:4980 |
13 | CRM_Contact_BAO_Query->searchQuery() | /home/econbot/domains/payments.econbot.org/public_html/sites/all/modules/civicrm/CRM/Profile/Selector/Listings.php:463 |
14 | CRM_Profile_Selector_Listings->getRows() | /home/econbot/domains/payments.econbot.org/public_html/sites/all/modules/civicrm/CRM/Core/Selector/Controller.php:404 |
15 | CRM_Core_Selector_Controller->getRows() | /home/econbot/domains/payments.econbot.org/public_html/sites/all/modules/civicrm/CRM/Core/Selector/Controller.php:326 |
16 | CRM_Core_Selector_Controller->run() | /home/econbot/domains/payments.econbot.org/public_html/sites/all/modules/civicrm/CRM/Profile/Page/Listings.php:382 |
17 | CRM_Profile_Page_Listings->run() | /home/econbot/domains/payments.econbot.org/public_html/sites/all/modules/civicrm/CRM/Profile/Page/Router.php:107 |
18 | CRM_Profile_Page_Router->run() | /home/econbot/domains/payments.econbot.org/public_html/sites/all/modules/civicrm/CRM/Core/Invoke.php:319 |
19 | CRM_Core_Invoke::runItem() | /home/econbot/domains/payments.econbot.org/public_html/sites/all/modules/civicrm/CRM/Core/Invoke.php:69 |
20 | CRM_Core_Invoke::_invoke() | /home/econbot/domains/payments.econbot.org/public_html/sites/all/modules/civicrm/CRM/Core/Invoke.php:36 |
21 | CRM_Core_Invoke::invoke() | /home/econbot/domains/payments.econbot.org/public_html/sites/all/modules/civicrm/drupal/civicrm.module:471 |
22 | civicrm_invoke() | /home/econbot/domains/payments.econbot.org/public_html/includes/menu.inc:527 |
23 | menu_execute_active_handler() | /home/econbot/domains/payments.econbot.org/public_html/index.php:21 |
24 | {main} |