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>, <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>, <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