[No Subject]

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

Return-Path: <caché>
Received: from [216.100.32.92] by web53714.mail.yahoo.com via HTTP;
 Thu, 08 Dec 2005 08:40:29 PST
Message-ID: <caché>
Date: Thu, 8 Dec 2005 08:40:29 -0800 (PST)
From: "Donald A. Lobo" <caché>
Reply-To: caché,
  "CiviCRM: General discussion around development" <caché>
Sender: caché
To: "CiviCRM: General discussion around development" <caché>
Subject: Re: [Crm-dev] CiviCRM error #1054 (unknown column)
In-Reply-To: <20051208112701993.00000004140@issremote002>
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:42:02 -0500
X-Forwarded-To: caché
X-Forwarded-For: caché caché
X-Gmail-Received: 039ef3c63946a20676fa3224ea9dd1a3df286ae6
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é)
DomainKey-Status: bad (test mode)
Old-Return-Path: <caché>
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
 h=Message-ID:Received:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding;
 b=SiLM9N+urAs/cTuawNk72kprJA1F2quJlTeqqQoRTBGsr4K4/FlGz6jja1aj4CEo0xfEkAqyjxacp3I+Z5/c+ggezFwCRvK8osjXLLT1CaT+KKttitc5+6Sxu2aooMcdDHyHi3FQpIV4mz6ZvpDXgvbkPdXPxCkvdvdQg8v1IZg=
 ;
X-Mime-Autoconverted: from 8bit to 7bit by courier 0.47
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é


brad:

looks like you are using mysql5.x. CiviCRM v1.2 has
some problems with mysql 5.x (not sure what, but we
know it does not work).

v1.3 will resolve these issues. sorry about that :(

lboo


--- Brad Buran <caché> wrote:

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

_______________________________________________
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.