CiviCRM Community Forums (archive)

I originally created a form that called two profiles, however, because of difficulties in this, I amalgamated all the fields into one custom group and one profile.

When I try to edit the form via a link created in the Menu Manager, I get this error:
backTrace

/home/bcsiorg/public_html/beta/administrator/components/com_civicrm/civicrm/CRM/Core/Error.php, backtrace, 138
, handle,
/home/bcsiorg/public_html/beta/administrator/components/com_civicrm/civicrm/packages/PEAR.php, call_user_func, 912
/home/bcsiorg/public_html/beta/administrator/components/com_civicrm/civicrm/packages/DB.php, PEAR_Error, 966
/home/bcsiorg/public_html/beta/administrator/components/com_civicrm/civicrm/packages/PEAR.php, DB_Error, 574
/home/bcsiorg/public_html/beta/administrator/components/com_civicrm/civicrm/packages/DB/common.php, raiseError, 1903
/home/bcsiorg/public_html/beta/administrator/components/com_civicrm/civicrm/packages/DB/mysql.php, raiseError, 898
/home/bcsiorg/public_html/beta/administrator/components/com_civicrm/civicrm/packages/DB/mysql.php, mysqlRaiseError, 327
/home/bcsiorg/public_html/beta/administrator/components/com_civicrm/civicrm/packages/DB/common.php, simpleQuery, 1216
/home/bcsiorg/public_html/beta/administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php, query, 2394
/home/bcsiorg/public_html/beta/administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php, _query, 1587
/home/bcsiorg/public_html/beta/administrator/components/com_civicrm/civicrm/CRM/Core/DAO.php, query, 144
/home/bcsiorg/public_html/beta/administrator/components/com_civicrm/civicrm/CRM/Dedupe/Finder.php, query, 97
/home/bcsiorg/public_html/beta/administrator/components/com_civicrm/civicrm/CRM/Profile/Form.php, dupesByParams, 477
, formRule,
/home/bcsiorg/public_html/beta/administrator/components/com_civicrm/civicrm/packages/HTML/QuickForm.php, call_user_func, 1591
/home/bcsiorg/public_html/beta/administrator/components/com_civicrm/civicrm/CRM/Core/Form.php, validate, 290
/home/bcsiorg/public_html/beta/administrator/components/com_civicrm/civicrm/CRM/Profile/Form/Edit.php, validate, 252
/home/bcsiorg/public_html/beta/administrator/components/com_civicrm/civicrm/CRM/Core/StateMachine.php, validate, 148
/home/bcsiorg/public_html/beta/administrator/components/com_civicrm/civicrm/CRM/Core/QuickForm/Action/Next.php, perform, 63
/home/bcsiorg/public_html/beta/administrator/components/com_civicrm/civicrm/packages/HTML/QuickForm/Controller.php, perform, 203
/home/bcsiorg/public_html/beta/administrator/components/com_civicrm/civicrm/packages/HTML/QuickForm/Page.php, handle, 103
/home/bcsiorg/public_html/beta/administrator/components/com_civicrm/civicrm/CRM/Core/Controller.php, handle, 232
/home/bcsiorg/public_html/beta/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php, run, 335
, profile,
/home/bcsiorg/public_html/beta/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php, call_user_func, 164
/home/bcsiorg/public_html/beta/components/com_civicrm/civicrm.php, invoke, 73
/home/bcsiorg/public_html/beta/components/com_civicrm/civicrm.php, civicrm_invoke, 24
/home/bcsiorg/public_html/beta/libraries/joomla/application/component/helper.php, require_once, 162
/home/bcsiorg/public_html/beta/includes/application.php, renderComponent, 124
/home/bcsiorg/public_html/beta/index.php, dispatch, 68

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) >= 10
                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) >= 10
                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) >= 10
                ORDER BY SUM(weight) desc [nativecode=1052 ** Column 'id' in field list is ambiguous]"]
)


Thing is I don't have a field called 'id' in the custom group.

This is happening on submit, and previously the form worked without a problem.

I recently upgraded from J1.0 to J1.5

Running CiviCRM 2.1.4.

[/code]

Hookay... thanks for the fast response. I'm going to ask the host to upgrade.