Missing table on 3.0.2 to 3.1.1 upgrade

[jwhittin]

This was an issue in the beta testing forum, but I don't believe it ever got resolved.  There it was joomla 3.0.4 - 3.1.1; we got the same thing with drupal 3.0.2-3.1.1:

DB Error: no such table
Database Error Code: Table 'yfe_civicrm_data.civicrm_contact_type' doesn't exist, 1146

When I look at the 3.0.2 civicrm.mysql file (not sure what does the actual upgrade), there is a reference to the table:
Three types of contacts are defined: Individual, Organization and Household. Contact objects are defined by a civicrm_contact record plus a related civicrm_contact_type record.
but there is no drop or create for the table.  It is in the 3.1.1 civicrm.mysql, so I could theoretically just create it, but after seeing the problems other people have had after manually changing their databases I was a little afraid to do this.

What should I do?

[Donald Lobo]

that table was introduced in 3.1. that comment has been there for some time and is not specific to a contact_type table

when are u getting this error? at what stage? what was the result of your upgrade

lobo

[jwhittin]

Not sure how to ascertain the stage, but it happened about two minutes into the upgrade.  Here's the entire message:

Sorry. A non-recoverable error has occurred.
 
DB Error: no such table
Database Error Code: Table 'yfe_civicrm_data.civicrm_contact_type' doesn't exist, 1146
Return to home page.
Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

Code: [Select]

=> -18
    [message] => DB Error: no such table
    [mode] => 16
    [debug_info] => SELECT *
 FROM civicrm_contact_type
 
 WHERE (  civicrm_contact_type.name  = 'Individual' ) 
 
 
 
 [nativecode=1146 ** Table 'yfe_civicrm_data.civicrm_contact_type' doesn't exist]
    [type] => DB_Error
    [user_info] => SELECT *
 FROM civicrm_contact_type
 
 WHERE (  civicrm_contact_type.name  = 'Individual' ) 
 
 
 
 [nativecode=1146 ** Table 'yfe_civicrm_data.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 *
 FROM civicrm_contact_type
 
 WHERE (  civicrm_contact_type.name  = 'Individual' ) 
 
 
 
 [nativecode=1146 ** Table 'yfe_civicrm_data.civicrm_contact_type' doesn't exist]"]
)

It was the first and only message I got.  I might also mention that I used wget to get the tar file civicrm-3.1.1-drupal.tar.gz from downloads.sourceforge.net/civicrm/, in case that might possibly not be the right file.

Query string used: http://<your_drupal_home>/civicrm/upgrade?reset=1

I cancelled the upgrade and went back to 3.0.2, since I had no idea why the table wasn't there. 

[jwhittin]

This has been resolved on our site; I'll try and get more info on how it was resolved when we're less busy.

[guaka]

I'm experiencing the same, with an upgrade from 3.0.2 to 3.1.2.

[Donald Lobo]

hey guaka:

can u email me your 3.0.x database (lobo at yahoo dot com)

thanx

lobo

[guaka]

Meanwhile I've resolved the issue by first upgrading to 3.1.1 and then to 3.1.2.

[Deepak Srivastava]

Hey guaka,

We were investigating your database and received this message when trying to upgrade to 3.1.2 (from 3.0.2) -

"Database check failed - it looks like you have already upgraded to the latest version (v3.1.1) of the database. OR If you think this message is wrong, it is very likely that this a partially upgraded db and you will need to reload the correct db on which upgrade was never tried."

Also made some manual checks and found that the db is in partial upgraded state.

How did you resolve the conflicts. While upgrading did you 'll make any changes/fixes to db based on the sql error ?

[guaka]

Hi Deepak,

I forgot to drop the database before importing it back in MySQL :/
I can try it again, but I need to set up a clean civicrm for that.  IIRC there's an easy (scripted) way to set up up a clean civicrm, I'll check it out.