[No Subject]

Objet:   [No Subject] (trouver plus)
De:    
Date:   Dec 08, 2005 17:27

Return-Path: <caché>
Received: from ISS.local (ASHDOWN-TWENTY-SEVEN.MIT.EDU [18.250.5.27])
 (authenticated bits=0) (User authenticated as caché)
 by outgoing.mit.edu (8.13.1/8.12.4) with ESMTP id jB8GTKtr025876
 (version=TLSv1/SSLv3 cipher=EDH-RSA-DES-CBC3-SHA bits=168 verify=NOT)
 for <caché>;
 Thu, 8 Dec 2005 11:29:33 -0500 (EST)
Message-ID: <caché>
Date: Thu, 8 Dec 2005 11:27:01 -0500
From: "Brad Buran" <caché>
Reply-To: "CiviCRM: General discussion around development" <caché>
Sender: caché
To: "caché" <caché>
Subject: [Crm-dev] CiviCRM error #1054 (unknown column)
Errors-To: caché
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Delivery-Date: Thu, 08 Dec 2005 11:35:27 -0500
X-Forwarded-To: caché
X-Forwarded-For: caché caché
X-Gmail-Received: 52db0b8fbb6b1706f5aa2af2731586b98ed0b447
Delivered-To: caché
Received-SPF: neutral (gmail.com: 80.72.33.166 is neither permitted nor denied by best guess record for domain of caché)
Old-Return-Path: <caché>
X-Sent-Folder-Path: Sent Items
X-Mailer: Oracle Connector for Outlook 9.0.4.2.6 61101 (11.0.5608)
X-Spam-Score: 1.352
X-Spam-Level: * (1.352)
X-Spam-Flag: NO
X-Scanned-By: MIMEDefang 2.42
X-BeenThere: caché
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: "CiviCRM: General discussion around development"
 <crm-dev.lists.objectledge.net>
List-Unsubscribe: <http://lists.objectledge.net/mailman/listinfo/crm-dev&gt;,
 <mailto:caché?subject=unsubscribe>
List-Archive: <http://lists.caltha.pl/pipermail/crm-dev>
List-Post: <mailto:caché>
List-Help: <mailto:caché?subject=help>
List-Subscribe: <http://lists.objectledge.net/mailman/listinfo/crm-dev&gt;,
 <mailto:caché?subject=subscribe>
Envelope-To: caché

I just installed CivicSpace on my devolopment server to play with.  Very nice!

However, when I tried using CiviCRM, I keep getting the following error when I add a contact or select a contact:

Database Error Code: Unknown column 'civicrm_contact.id' in 'on clause', 1054

I already checked the database, and the column and table appear to be there, so I'm not sure how to fix this issue.  Does anyone have suggestions?

Thank you,
Brad

=====================================================

Below is the code for debugging:

error

Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -19
    [message] => DB Error: no such field
    [mode] => 16
    [debug_info] => (  SELECT civicrm_relationship.id as civicrm_relationship_id,
                              civicrm_contact.sort_name as sort_name,
                              civicrm_address.street_address as street_address,
                              civicrm_address.city as city,
                              civicrm_address.postal_code as postal_code,
                              civicrm_state_province.abbreviation as state,
                              civicrm_country.name as country,
                              civicrm_email.email as email,
                              civicrm_phone.phone as phone,
                              civicrm_contact.id as civicrm_contact_id,
                              civicrm_contact.contact_type as contact_type,
                              civicrm_relationship.contact_id_b as contact_id_b,
                              civicrm_relationship.contact_id_a as contact_id_a,
                              civicrm_relationship_type.id as civicrm_relationship_type_id,
                              civicrm_relationship.start_date as start_date,
                              civicrm_relationship.end_date as end_date,
                              civicrm_relationship.is_active as is_active , civicrm_relationship_type.name_a_b as name_a_b,
                              civicrm_relationship_type.name_b_a as relation  FROM civicrm_contact, civicrm_relationship, civicrm_relationship_type
                        LEFT OUTER JOIN civicrm_location ON ( civicrm_location.entity_table = 'civicrm_contact' AND
                                                              civicrm_contact.id = civicrm_location.entity_id AND
                                                              civicrm_location.is_primary = 1 )
                        LEFT OUTER JOIN civicrm_address ON (civicrm_location.id = civicrm_address.location_id )
                        LEFT OUTER JOIN civicrm_phone ON (civicrm_location.id = civicrm_phone.location_id AND civicrm_phone.is_primary = 1)
                        LEFT OUTER JOIN civicrm_email ON (civicrm_location.id = civicrm_email.location_id AND civicrm_email.is_primary = 1)
                        LEFT OUTER JOIN civicrm_state_province ON (civicrm_address.state_province_id = civicrm_state_province.id)
                        LEFT OUTER JOIN civicrm_country ON (civicrm_address.country_id = civicrm_country.id)  WHERE civicrm_relationship.relationship_type_id = civicrm_relationship_type.id  AND civicrm_relationship.contact_id_b = 5 AND civicrm_relationship.contact_id_a = civicrm_contact.id  ) UNION (  SELECT civicrm_relationship.id as civicrm_relationship_id,
                              civicrm_contact.sort_name as sort_name,
                              civicrm_address.street_address as street_address,
                              civicrm_address.city as city,
                              civicrm_address.postal_code as postal_code,
                              civicrm_state_province.abbreviation as state,
                              civicrm_country.name as country,
                              civicrm_email.email as email,
                              civicrm_phone.phone as phone,
                              civicrm_contact.id as civicrm_contact_id,
                              civicrm_contact.contact_type as contact_type,
                              civicrm_relationship.contact_id_b as contact_id_b,
                              civicrm_relationship.contact_id_a as contact_id_a,
                              civicrm_relationship_type.id as civicrm_relationship_type_id,
                              civicrm_relationship.start_date as start_date,
                              civicrm_relationship.end_date as end_date,
                              civicrm_relationship.is_active as is_active , civicrm_relationship_type.name_a_b as name_a_b,
                              civicrm_relationship_type.name_a_b as relation  FROM civicrm_contact, civicrm_relationship, civicrm_relationship_type
                        LEFT OUTER JOIN civicrm_location ON ( civicrm_location.entity_table = 'civicrm_contact' AND
                                                              civicrm_contact.id = civicrm_location.entity_id AND
                                                              civicrm_location.is_primary = 1 )
                        LEFT OUTER JOIN civicrm_address ON (civicrm_location.id = civicrm_address.location_id )
                        LEFT OUTER JOIN civicrm_phone ON (civicrm_location.id = civicrm_phone.location_id AND civicrm_phone.is_primary = 1)
                        LEFT OUTER JOIN civicrm_email ON (civicrm_location.id = civicrm_email.location_id AND civicrm_email.is_primary = 1)
                        LEFT OUTER JOIN civicrm_state_province ON (civicrm_address.state_province_id = civicrm_state_province.id)
                        LEFT OUTER JOIN civicrm_country ON (civicrm_address.country_id = civicrm_country.id)  WHERE civicrm_relationship.relationship_type_id = civicrm_relationship_type.id  AND civicrm_relationship.contact_id_a = 5 AND civicrm_relationship.contact_id_b = civicrm_contact.id  )  ORDER BY civicrm_relationship_type_id, sort_name  LIMIT 0, 3 [nativecode=1054 ** Unknown column 'civicrm_contact.id' in 'on clause']
    [type] => db_error
    [user_info] => (  SELECT civicrm_relationship.id as civicrm_relationship_id,
                              civicrm_contact.sort_name as sort_name,
                              civicrm_address.street_address as street_address,
                              civicrm_address.city as city,
                              civicrm_address.postal_code as postal_code,
                              civicrm_state_province.abbreviation as state,
                              civicrm_country.name as country,
                              civicrm_email.email as email,
                              civicrm_phone.phone as phone,
                              civicrm_contact.id as civicrm_contact_id,
                              civicrm_contact.contact_type as contact_type,
                              civicrm_relationship.contact_id_b as contact_id_b,
                              civicrm_relationship.contact_id_a as contact_id_a,
                              civicrm_relationship_type.id as civicrm_relationship_type_id,
                              civicrm_relationship.start_date as start_date,
                              civicrm_relationship.end_date as end_date,
                              civicrm_relationship.is_active as is_active , civicrm_relationship_type.name_a_b as name_a_b,
                              civicrm_relationship_type.name_b_a as relation  FROM civicrm_contact, civicrm_relationship, civicrm_relationship_type
                        LEFT OUTER JOIN civicrm_location ON ( civicrm_location.entity_table = 'civicrm_contact' AND
                                                              civicrm_contact.id = civicrm_location.entity_id AND
                                                              civicrm_location.is_primary = 1 )
                        LEFT OUTER JOIN civicrm_address ON (civicrm_location.id = civicrm_address.location_id )
                        LEFT OUTER JOIN civicrm_phone ON (civicrm_location.id = civicrm_phone.location_id AND civicrm_phone.is_primary = 1)
                        LEFT OUTER JOIN civicrm_email ON (civicrm_location.id = civicrm_email.location_id AND civicrm_email.is_primary = 1)
                        LEFT OUTER JOIN civicrm_state_province ON (civicrm_address.state_province_id = civicrm_state_province.id)
                        LEFT OUTER JOIN civicrm_country ON (civicrm_address.country_id = civicrm_country.id)  WHERE civicrm_relationship.relationship_type_id = civicrm_relationship_type.id  AND civicrm_relationship.contact_id_b = 5 AND civicrm_relationship.contact_id_a = civicrm_contact.id  ) UNION (  SELECT civicrm_relationship.id as civicrm_relationship_id,
                              civicrm_contact.sort_name as sort_name,
                              civicrm_address.street_address as street_address,
                              civicrm_address.city as city,
                              civicrm_address.postal_code as postal_code,
                              civicrm_state_province.abbreviation as state,
                              civicrm_country.name as country,
                              civicrm_email.email as email,
                              civicrm_phone.phone as phone,
                              civicrm_contact.id as civicrm_contact_id,
                              civicrm_contact.contact_type as contact_type,
                              civicrm_relationship.contact_id_b as contact_id_b,
                              civicrm_relationship.contact_id_a as contact_id_a,
                              civicrm_relationship_type.id as civicrm_relationship_type_id,
                              civicrm_relationship.start_date as start_date,
                              civicrm_relationship.end_date as end_date,
                              civicrm_relationship.is_active as is_active , civicrm_relationship_type.name_a_b as name_a_b,
                              civicrm_relationship_type.name_a_b as relation  FROM civicrm_contact, civicrm_relationship, civicrm_relationship_type
                        LEFT OUTER JOIN civicrm_location ON ( civicrm_location.entity_table = 'civicrm_contact' AND
                                                              civicrm_contact.id = civicrm_location.entity_id AND
                                                              civicrm_location.is_primary = 1 )
                        LEFT OUTER JOIN civicrm_address ON (civicrm_location.id = civicrm_address.location_id )
                        LEFT OUTER JOIN civicrm_phone ON (civicrm_location.id = civicrm_phone.location_id AND civicrm_phone.is_primary = 1)
                        LEFT OUTER JOIN civicrm_email ON (civicrm_location.id = civicrm_email.location_id AND civicrm_email.is_primary = 1)
                        LEFT OUTER JOIN civicrm_state_province ON (civicrm_address.state_province_id = civicrm_state_province.id)
                        LEFT OUTER JOIN civicrm_country ON (civicrm_address.country_id = civicrm_country.id)  WHERE civicrm_relationship.relationship_type_id = civicrm_relationship_type.id  AND civicrm_relationship.contact_id_a = 5 AND civicrm_relationship.contact_id_b = civicrm_contact.id  )  ORDER BY civicrm_relationship_type_id, sort_name  LIMIT 0, 3 [nativecode=1054 ** Unknown column 'civicrm_contact.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 civicrm_relationship.id as civicrm_relationship_id,
                              civicrm_contact.sort_name as sort_name,
                              civicrm_address.street_address as street_address,
                              civicrm_address.city as city,
                              civicrm_address.postal_code as postal_code,
                              civicrm_state_province.abbreviation as state,
                              civicrm_country.name as country,
                              civicrm_email.email as email,
                              civicrm_phone.phone as phone,
                              civicrm_contact.id as civicrm_contact_id,
                              civicrm_contact.contact_type as contact_type,
                              civicrm_relationship.contact_id_b as contact_id_b,
                              civicrm_relationship.contact_id_a as contact_id_a,
                              civicrm_relationship_type.id as civicrm_relationship_type_id,
                              civicrm_relationship.start_date as start_date,
                              civicrm_relationship.end_date as end_date,
                              civicrm_relationship.is_active as is_active , civicrm_relationship_type.name_a_b as name_a_b,
                              civicrm_relationship_type.name_b_a as relation  FROM civicrm_contact, civicrm_relationship, civicrm_relationship_type
                        LEFT OUTER JOIN civicrm_location ON ( civicrm_location.entity_table = 'civicrm_contact' AND
                                                              civicrm_contact.id = civicrm_location.entity_id AND
                                                              civicrm_location.is_primary = 1 )
                        LEFT OUTER JOIN civicrm_address ON (civicrm_location.id = civicrm_address.location_id )
                        LEFT OUTER JOIN civicrm_phone ON (civicrm_location.id = civicrm_phone.location_id AND civicrm_phone.is_primary = 1)
                        LEFT OUTER JOIN civicrm_email ON (civicrm_location.id = civicrm_email.location_id AND civicrm_email.is_primary = 1)
                        LEFT OUTER JOIN civicrm_state_province ON (civicrm_address.state_province_id = civicrm_state_province.id)
                        LEFT OUTER JOIN civicrm_country ON (civicrm_address.country_id = civicrm_country.id)  WHERE civicrm_relationship.relationship_type_id = civicrm_relationship_type.id  AND civicrm_relationship.contact_id_b = 5 AND civicrm_relationship.contact_id_a = civicrm_contact.id  ) UNION (  SELECT civicrm_relationship.id as civicrm_relationship_id,
                              civicrm_contact.sort_name as sort_name,
                              civicrm_address.street_address as street_address,
                              civicrm_address.city as city,
                              civicrm_address.postal_code as postal_code,
                              civicrm_state_province.abbreviation as state,
                              civicrm_country.name as country,
                              civicrm_email.email as email,
                              civicrm_phone.phone as phone,
                              civicrm_contact.id as civicrm_contact_id,
                              civicrm_contact.contact_type as contact_type,
                              civicrm_relationship.contact_id_b as contact_id_b,
                              civicrm_relationship.contact_id_a as contact_id_a,
                              civicrm_relationship_type.id as civicrm_relationship_type_id,
                              civicrm_relationship.start_date as start_date,
                              civicrm_relationship.end_date as end_date,
                              civicrm_relationship.is_active as is_active , civicrm_relationship_type.name_a_b as name_a_b,
                              civicrm_relationship_type.name_a_b as relation  FROM civicrm_contact, civicrm_relationship, civicrm_relationship_type
                        LEFT OUTER JOIN civicrm_location ON ( civicrm_location.entity_table = 'civicrm_contact' AND
                                                              civicrm_contact.id = civicrm_location.entity_id AND
                                                              civicrm_location.is_primary = 1 )
                        LEFT OUTER JOIN civicrm_address ON (civicrm_location.id = civicrm_address.location_id )
                        LEFT OUTER JOIN civicrm_phone ON (civicrm_location.id = civicrm_phone.location_id AND civicrm_phone.is_primary = 1)
                        LEFT OUTER JOIN civicrm_email ON (civicrm_location.id = civicrm_email.location_id AND civicrm_email.is_primary = 1)
                        LEFT OUTER JOIN civicrm_state_province ON (civicrm_address.state_province_id = civicrm_state_province.id)
                        LEFT OUTER JOIN civicrm_country ON (civicrm_address.country_id = civicrm_country.id)  WHERE civicrm_relationship.relationship_type_id = civicrm_relationship_type.id  AND civicrm_relationship.contact_id_a = 5 AND civicrm_relationship.contact_id_b = civicrm_contact.id  )  ORDER BY civicrm_relationship_type_id, sort_name  LIMIT 0, 3 [nativecode=1054 ** Unknown column 'civicrm_contact.id' in 'on clause']"]
)

_______________________________________________
Crm-dev mailing list
caché
http://lists.objectledge.net/mailman/listinfo/crm-dev

Creative Commons License
Except where otherwise noted, content on this site is licensed under a Creative Commons Attribution-Share Alike 3.0 United States Licence.