Error Details:

In an installation of 1.7 upgraded to 1.8, then to 1.9, upon trying to view My Account, we get this error:

Database Error Code: Unknown column 'Home-individual.id' in 'field list', 1054

There are 102 tables in the db, if that helps. There seems to be nothing on the Internet about this Home-individual table.

Error Details:

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 contact_id, civicrm_individual.id as individual_id, civicrm_individual.first_name as `first_name`, `Home-location`.id as `Home-location_id`, `Home-location_type`.id as `Home-location_type_id`, `Home-location_type`.name as `Home-location_type`, `Home-address`.id as `Home-address_id`, `Home-individual`.id as `Home-individual_id`, `Home-individual`.last_name as `Home-last_name`, `1-location`.id as `1-location_id`, `1-location_type`.id as `1-location_type_id`, `1-location_type`.name as `1-location_type`, `1-address`.id as `1-address_id`, `1-email-1`.id as `1-email-1_id`, `1-email-1`.email as `1-email-1` FROM civicrm_contact contact_a LEFT JOIN civicrm_individual ON (contact_a.id = civicrm_individual.contact_id)
LEFT JOIN civicrm_location `1-location` ON (`1-location`.entity_table = 'civicrm_contact' AND `1-location`.entity_id = contact_a.id AND `1-location`.is_primary = 1 )
LEFT JOIN civicrm_location `Home-location` ON (`Home-location`.entity_table = 'civicrm_contact' AND `Home-location`.entity_id = contact_a.id AND `Home-location`.location_type_id = 1 )
LEFT JOIN civicrm_location_type `1-location_type` ON (`1-location`.location_type_id = `1-location_type`.id )
LEFT JOIN civicrm_location_type `Home-location_type` ON (`Home-location`.location_type_id = `Home-location_type`.id )
LEFT JOIN civicrm_address `1-address` ON (`1-address`.location_id = `1-location`.id)
LEFT JOIN civicrm_address `Home-address` ON (`Home-address`.location_id = `Home-location`.id)
LEFT JOIN civicrm_email `1-email-1` ON `1-location`.id = `1-email-1`.location_id AND `1-email-1`.is_primary = 1 WHERE ( contact_a.id = 1153 ) AND ( 1 ) ORDER BY contact_a.sort_name [nativecode=1054 ** Unknown column 'Home-individual.id' in 'field list']