Upgrade from 3.0.4 to 3.1 b6 failed

[tabletguy]

New install of 3.03, added custom fields, upgraded to 3.0.4 no problem.

Today, upgraded from 3.0.4 to 3.1 beta 6 and it fails with this message:

Suggestions for recovery?  Alternatively, I have emailed Kurund an admin access to the site.  Let me know. I will have to leave it as is anyways for the next 4-6 hours while I do something else.

Code:

unrecoverable error
    Sorry. A non-recoverable error has occurred.

    DB Error: no such table

    Database Error Code: Table 'ahymsin_joomla.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 *
 FROM civicrm_contact_type
 
 WHERE (  civicrm_contact_type.name  = 'Individual' ) 
 
 
 
 [nativecode=1146 ** Table 'ahymsin_joomla.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 'ahymsin_joomla.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 'ahymsin_joomla.civicrm_contact_type' doesn't exist]"]
)

[/code]

[Kurund Jalmi]

Looks like you upgrade failed. Can you restore back to 3.0.4 and try again.

Kurund

[tabletguy]

I can delete the install, reinstall 3.0.4 and then immediately uninstall 3.0.4 and reinstall 3.1 b6. Is that what you mean?

[Kurund Jalmi]

Yes install 3.0.4 and make sure it is working correctly. Then follow these instructions: http://wiki.civicrm.org/confluence/display/CRMUPCOMING/Upgrade+Joomla+Sites+to+3.1

HTh
Kurund

[tabletguy]

Did as you suggested, except just clicked the link to upgrade the database, rather than copy / paste the link provided on the document page for that purpose. However, I did verify that they were essentially the same (had my domain, of course).

Still fails in same manner. I did also check, and that table isn't in my 3.04 system. I searched and edited contacts to test it out. I didn't do extensive testing on 3.04, but didn't find anything that didn't work before again trying to upgrade to 3.1

So, I could try the same "cycle" again, but I'm sure it will result in same outcome.

Should I just try and add this table manually, and then repeat calling the URL to update the DB? :

Code:

http://www.ahymsin.org/main/administrator/index2.php?option=com_civicrm&task=civicrm/upgrade&reset=1

I will be busy for next 4-5 days filming a conference, and won't be able to give much if any time to this, but will try and check in each evening.

Code:

unrecoverable error
    Sorry. A non-recoverable error has occurred.

    DB Error: no such table

    Database Error Code: Table 'ahymsin_joomla.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 *
 FROM civicrm_contact_type
 
 WHERE (  civicrm_contact_type.name  = 'Individual' ) 
 
 [nativecode=1146 ** Table 'ahymsin_joomla.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 'ahymsin_joomla.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 'ahymsin_joomla.civicrm_contact_type' doesn't exist]"]
)

[/code]

[Kurund Jalmi]

Can you send your 3.0.4 db to kurund at civicrm dot org, we will investigate and get back to you on this issue.

Kurund

[gaetgodi]

In upgrading from 3.0.4 to 3.1.1 I got the same error on this table... 1146. I copied civicrm_contact to civicrm_contact_type, did the database upgrade again and got an error saying the table already existed.  Deleted the table civicrm_contact_type, did the database upgrade again and it worked.
I am now going to test the results of the installation but it looks good.

[neha]

tabletguy:

I followed these steps:
1. Provided DB is of CiviCRM v3.0.4, I installed it on my local machine. Everything seems to be working fine w/ v3.0.4
2. Then I upgraded it to CiviCRM v3.1.beta6, My upgrade process went smoothly and db upgraded successfully.
3. After upgrade everything seems to be working fine for CiviCRM v3.1.beta6.

It looks like I am missing some steps to replicate the issue, it would be great if you give some more details to replicate this issue.  

thanks
Neha

[tabletguy]

I still have the problem. I was hoping that looking at the database SQL that I sent would allow you to tell me how to repair the problem.

I have tried using the release 3.1 with same results.

Obviously I need to do something with the 3.0.4 database before upgrading. Can I just add that table (from the SQL scripts) and then do another upgrade, or are there other issues.

There's no way that I can see that I can export all the custom fields and contact data, or I would do that and then drop all the tables and start from a fresh 3.1 install and import the data.

As is, I'd like to attempt repairing the existing tables first.

[Donald Lobo]

please start a new topic on this in the appropriate forums. i'm closing the 3.1 release testing topic (since 3.1 is already released)

lobo