CiviCRM Community Forums (archive)

I was upgrading a site from 3.0.3 to 3.2beta3, and the upgrade script shot an error saying that the civicrm_contact_type table didn't exist.  My understanding is that's a new table with 3.1, so I imagine the script isn't catching at least some schema changes from 3.0.

I was able to restore the 3.0.3 site, upgrade it to 3.1.5, and then upgrade again to 3.2beta3 with no problems.

Here's the error information:
Sorry. A non-recoverable error has occurred.

DB Error: no such table

Database Error Code: Table 'XXXXX_civicrm.civicrm_contact_type' doesn't exist, 1146

Return to home page.

Error Details:

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

    [code] => -18
    [message] => DB Error: no such table
    [mode] => 16
    [debug_info] =>
SELECT subtype.*, parent.name as parent, parent.label as parent_label
FROM   civicrm_contact_type subtype
INNER JOIN civicrm_contact_type parent ON subtype.parent_id = parent.id
WHERE  subtype.name IS NOT NULL AND subtype.parent_id IS NOT NULL  
 AND subtype.is_active = 1 AND parent.is_active = 1 ORDER BY parent.id [nativecode=1146 ** Table 'XXXXX_civicrm.civicrm_contact_type' doesn't exist]
    [type] => DB_Error
    [user_info] =>
SELECT subtype.*, parent.name as parent, parent.label as parent_label
FROM   civicrm_contact_type subtype
INNER JOIN civicrm_contact_type parent ON subtype.parent_id = parent.id
WHERE  subtype.name IS NOT NULL AND subtype.parent_id IS NOT NULL  
 AND subtype.is_active = 1 AND parent.is_active = 1 ORDER BY parent.id [nativecode=1146 ** Table 'XXXXX_civicrm.civicrm_contact_type' doesn't exist]
    [to_string] => [db_error: message="DB Error: no such table" code=-18 mode=callback callback=CRM_Core_Error::handle prefix="" info="
SELECT subtype.*, parent.name as parent, parent.label as parent_label
FROM   civicrm_contact_type subtype
INNER JOIN civicrm_contact_type parent ON subtype.parent_id = parent.id
WHERE  subtype.name IS NOT NULL AND subtype.parent_id IS NOT NULL  
 AND subtype.is_active = 1 AND parent.is_active = 1 ORDER BY parent.id [nativecode=1146 ** Table 'XXXXX_civicrm.civicrm_contact_type' doesn't exist]"]
)

[/code]