CiviCRM Community Forums (archive)

Drupal 6.22
Organic groups 6.x-2.x-dev (2011-Oct-16)
CiviCRM 3.4.5

When I go to Content > Create new Group and save, it creates the group but I get this error:
Sorry. A non-recoverable error has occurred.
DB Error: no such field

and the group does not display on the domain.com/og page

any ideas what's going on here?
Array ( [callback] => Array ( [0] => CRM_Core_Error [1] => handle ) [code] => -19 [message] => DB Error: no such field [mode] => 16 [debug_info] => SELECT contact_a.id as id FROM civicrm_contact contact_a LEFT JOIN civicrm_address ON ( contact_a.id = civicrm_address.contact_id AND civicrm_address.is_primary = 1 ) LEFT JOIN civicrm_state_province ON civicrm_address.state_province_id = civicrm_state_province.id WHERE ( ( ROUND(civicrm_address.postal_code) >= '97201' AND ROUND(civicrm_address.postal_code) <= '97299' AND contact_a.contact_type IN ('Individual') ) OR ( LOWER(civicrm_address.city) = 'vancouver' AND civicrm_state_province.id IN (Washington) AND contact_a.contact_type IN ('Individual') ) ) AND (contact_a.is_deleted = 0) AND contact_a.id NOT IN ( SELECT contact_id FROM civicrm_group_contact WHERE civicrm_group_contact.status = 'Removed' AND civicrm_group_contact.group_id = 38 ) UNION SELECT contact_id as id FROM civicrm_group_contact WHERE civicrm_group_contact.status = 'Added' AND civicrm_group_contact.group_id = 38 [nativecode=1054 ** Unknown column 'Washington' in 'where clause'] [type] => DB_Error [user_info] => SELECT contact_a.id as id FROM civicrm_contact contact_a LEFT JOIN civicrm_address ON ( contact_a.id = civicrm_address.contact_id AND civicrm_address.is_primary = 1 ) LEFT JOIN civicrm_state_province ON civicrm_address.state_province_id = civicrm_state_province.id WHERE ( ( ROUND(civicrm_address.postal_code) >= '97201' AND ROUND(civicrm_address.postal_code) <= '97299' AND contact_a.contact_type IN ('Individual') ) OR ( LOWER(civicrm_address.city) = 'vancouver' AND civicrm_state_province.id IN (Washington) AND contact_a.contact_type IN ('Individual') ) ) AND (contact_a.is_deleted = 0) AND contact_a.id NOT IN ( SELECT contact_id FROM civicrm_group_contact WHERE civicrm_group_contact.status = 'Removed' AND civicrm_group_contact.group_id = 38 ) UNION SELECT contact_id as id FROM civicrm_group_contact WHERE civicrm_group_contact.status = 'Added' AND civicrm_group_contact.group_id = 38 [nativecode=1054 ** Unknown column 'Washington' in 'where clause'] [to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT contact_a.id as id FROM civicrm_contact contact_a LEFT JOIN civicrm_address ON ( contact_a.id = civicrm_address.contact_id AND civicrm_address.is_primary = 1 ) LEFT JOIN civicrm_state_province ON civicrm_address.state_province_id = civicrm_state_province.id WHERE ( ( ROUND(civicrm_address.postal_code) >= '97201' AND ROUND(civicrm_address.postal_code) <= '97299' AND contact_a.contact_type IN ('Individual') ) OR ( LOWER(civicrm_address.city) = 'vancouver' AND civicrm_state_province.id IN (Washington) AND contact_a.contact_type IN ('Individual') ) ) AND (contact_a.is_deleted = 0) AND contact_a.id NOT IN ( SELECT contact_id FROM civicrm_group_contact WHERE civicrm_group_contact.status = 'Removed' AND civicrm_group_contact.group_id = 38 ) UNION SELECT contact_id as id FROM civicrm_group_contact WHERE civicrm_group_contact.status = 'Added' AND civicrm_group_contact.group_id = 38 [nativecode=1054 ** Unknown column 'Washington' in 'where clause']"] )

We have OG and Civi behaving nicely on both 3.4.4 and 3.4.7 (same site but have just upgraded on dev so tested this to confirm for your benefit).
ie, creating an OG creates the two Civi Groups expected         
Using OG 6.x-2.1 

Cool - nice to know the old 'try upgrading' helped