CiviCRM Community Forums (archive)

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.


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]

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?

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? :
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.


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]

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.

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.