Details
-
Type:
Bug
-
Status: Done/Fixed
-
Priority:
Critical
-
Resolution: Won't Fix
-
Affects Version/s: 2.1
-
Fix Version/s: 2.1.2
-
Component/s: None
-
Labels:None
Description
Newbie to CiviCRM - please assist. It seems as though I cannot add individuals, groups, organizations, etc. Thanks!
backTrace
/home/seascout/public_html/seascoutevents.us/r15/administrator/components/com_civicrm/civicrm/CRM/Core/Error.php, backtrace, 138
, handle,
/home/seascout/public_html/seascoutevents.us/r15/administrator/components/com_civicrm/civicrm/packages/PEAR.php, call_user_func, 912
/home/seascout/public_html/seascoutevents.us/r15/administrator/components/com_civicrm/civicrm/packages/DB.php, PEAR_Error, 966
/home/seascout/public_html/seascoutevents.us/r15/administrator/components/com_civicrm/civicrm/packages/PEAR.php, DB_Error, 574
/home/seascout/public_html/seascoutevents.us/r15/administrator/components/com_civicrm/civicrm/packages/DB/common.php, raiseError, 1903
/home/seascout/public_html/seascoutevents.us/r15/administrator/components/com_civicrm/civicrm/packages/DB/mysql.php, raiseError, 898
/home/seascout/public_html/seascoutevents.us/r15/administrator/components/com_civicrm/civicrm/packages/DB/mysql.php, mysqlRaiseError, 327
/home/seascout/public_html/seascoutevents.us/r15/administrator/components/com_civicrm/civicrm/packages/DB/common.php, simpleQuery, 1216
/home/seascout/public_html/seascoutevents.us/r15/administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php, query, 2394
/home/seascout/public_html/seascoutevents.us/r15/administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php, _query, 1587
/home/seascout/public_html/seascoutevents.us/r15/administrator/components/com_civicrm/civicrm/CRM/Core/DAO.php, query, 144
/home/seascout/public_html/seascoutevents.us/r15/administrator/components/com_civicrm/civicrm/CRM/Dedupe/Finder.php, query, 101
/home/seascout/public_html/seascoutevents.us/r15/administrator/components/com_civicrm/civicrm/CRM/Contact/Form/Individual.php, dupesByParams, 230
, formRule,
/home/seascout/public_html/seascoutevents.us/r15/administrator/components/com_civicrm/civicrm/packages/HTML/QuickForm.php, call_user_func, 1591
/home/seascout/public_html/seascoutevents.us/r15/administrator/components/com_civicrm/civicrm/CRM/Core/Form.php, validate, 290
/home/seascout/public_html/seascoutevents.us/r15/administrator/components/com_civicrm/civicrm/CRM/Core/QuickForm/Action/Refresh.php, validate, 69
/home/seascout/public_html/seascoutevents.us/r15/administrator/components/com_civicrm/civicrm/packages/HTML/QuickForm/Controller.php, perform, 203
/home/seascout/public_html/seascoutevents.us/r15/administrator/components/com_civicrm/civicrm/packages/HTML/QuickForm/Page.php, handle, 103
/home/seascout/public_html/seascoutevents.us/r15/administrator/components/com_civicrm/civicrm/CRM/Core/Controller.php, handle, 232
/home/seascout/public_html/seascoutevents.us/r15/administrator/components/com_civicrm/civicrm/CRM/Utils/Wrapper.php, run, 114
/home/seascout/public_html/seascoutevents.us/r15/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php, run, 169
/home/seascout/public_html/seascoutevents.us/r15/administrator/components/com_civicrm/admin.civicrm.php, invoke, 45
/home/seascout/public_html/seascoutevents.us/r15/administrator/components/com_civicrm/admin.civicrm.php, civicrm_invoke, 22
/home/seascout/public_html/seascoutevents.us/r15/libraries/joomla/application/component/helper.php, require_once, 162
/home/seascout/public_html/seascoutevents.us/r15/administrator/includes/application.php, renderComponent, 130
/home/seascout/public_html/seascoutevents.us/r15/administrator/index.php, dispatch, 67
/home/seascout/public_html/seascoutevents.us/r15/administrator/index2.php, include, 14
unrecoverable error
Sorry. A non-recoverable error has occurred.
DB Error: unknown error
Database Error Code: Column 'id' in field list is ambiguous, 1052
Return to home page.
Error Details:
Array
(
[callback] => Array
(
[0] => CRM_Core_Error
[1] => handle
)
[code] => -1
[message] => DB Error: unknown error
[mode] => 16
[debug_info] => SELECT id
FROM dedupe JOIN civicrm_contact USING (id)
WHERE contact_type = 'Individual'
GROUP BY id HAVING SUM(weight) >= 20
ORDER BY SUM(weight) desc [nativecode=1052 ** Column 'id' in field list is ambiguous]
[type] => DB_Error
[user_info] => SELECT id
FROM dedupe JOIN civicrm_contact USING (id)
WHERE contact_type = 'Individual'
GROUP BY id HAVING SUM(weight) >= 20
ORDER BY SUM(weight) desc [nativecode=1052 ** Column 'id' in field list is ambiguous]
[to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT id
FROM dedupe JOIN civicrm_contact USING (id)
WHERE contact_type = 'Individual'
GROUP BY id HAVING SUM(weight) >= 20
ORDER BY SUM(weight) desc [nativecode=1052 ** Column 'id' in field list is ambiguous]"]
)