DB Error: no such table

[tmccartney]

Hello:

I transferred a Drupal/Civi installation from one Hostmonster account (where it was primary) to another HM account (where it is an add-on).  Things have gone MOSTLY smoothly; I imported the Drupal and Civi databases to the new account.  For Civi, I created the database in cpanel, installed Civi, dropped the database, re-created it and then imported my old tables into it. It's running okay for the most part.

However, certain administrative functions yield this error:

Error Details:


Array
(
    [callback] => Array
        (
            

• => 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  
 [nativecode=1146 ** Table 'fairhou1_tfhccivi.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  
 [nativecode=1146 ** Table 'fairhou1_tfhccivi.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  
 [nativecode=1146 ** Table 'fairhou1_tfhccivi.civicrm_contact_type' doesn't exist]"]
)

I looked in the original SQL file I exported from the old account and didn't see a reference to a civicrm_contact_type table.  Is it too late to create one?  Any other workaround?

Thanks!

[tmccartney]

Replying to myself to admit to being an idiot.  I installed 3.1.3 on the new site when I was actually running 3.0.3 before.  That's why the installation of Civi didn't like my database.