CiviCRM Community Forums (archive)

In doing a test upgrade from 1.9 to 2.0 on my local machine, I'm getting a fatal error in the final upgrade step telling me that the civicrm_location table doesn't exist:

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

    [code] => -18
    [message] => DB Error: no such table
    [mode] => 16
    [debug_info] => SELECT status_id, email FROM civicrm_membership cm
                    LEFT JOIN civicrm_contact cc ON cm.contact_id = cc.id
                    LEFT JOIN civicrm_location cl ON cc.id = cl.entity_id
                    LEFT JOIN civicrm_email ce ON cl.id = ce.location_id
                    WHERE contact_type = 'Individual'
                    AND entity_table = 'civicrm_contact'
                    AND cl.is_primary = 1
                    AND ce.is_primary = 1
                    AND membership_type_id = 1
                    AND cc.domain_id = 1 AND email = 'killshot91@comcast.net' [nativecode=1146 ** Table 'campfire_civicrm.civicrm_location' doesn't exist]
    [type] => DB_Error
    [user_info] => SELECT status_id, email FROM civicrm_membership cm
                    LEFT JOIN civicrm_contact cc ON cm.contact_id = cc.id
                    LEFT JOIN civicrm_location cl ON cc.id = cl.entity_id
                    LEFT JOIN civicrm_email ce ON cl.id = ce.location_id
                    WHERE contact_type = 'Individual'
                    AND entity_table = 'civicrm_contact'
                    AND cl.is_primary = 1
                    AND ce.is_primary = 1
                    AND membership_type_id = 1
                    AND cc.domain_id = 1 AND email = 'killshot91@comcast.net' [nativecode=1146 ** Table 'campfire_civicrm.civicrm_location' 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 status_id, email FROM civicrm_membership cm
                    LEFT JOIN civicrm_contact cc ON cm.contact_id = cc.id
                    LEFT JOIN civicrm_location cl ON cc.id = cl.entity_id
                    LEFT JOIN civicrm_email ce ON cl.id = ce.location_id
                    WHERE contact_type = 'Individual'
                    AND entity_table = 'civicrm_contact'
                    AND cl.is_primary = 1
                    AND ce.is_primary = 1
                    AND membership_type_id = 1
                    AND cc.domain_id = 1 AND email = 'killshot91@comcast.net' [nativecode=1146 ** Table 'campfire_civicrm.civicrm_location' doesn't exist]"]
)

From what I've seen on other posts, the civicrm_location table was done away with in 2.0.  I've verified that the table is still there prior to starting the last step.  But if it's supposed to go away, then why am I getting an error that it doesn't exist?

Thanks.
[/code]

Yes, I've done it multiple times, and I keep getting the same error.  My initial install was version 1.9, so I was told at http://forum.civicrm.org/index.php/topic,2905.msg12620.html#msg12620 that step 4 is unnecessary.  Other than that, I've followed the instructions exactly as listed.

Here is the backtrace.

C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\civicrmtest\sites\all\modules\civicrm\CRM\Core\Error.php, backtrace, 148
, handle,
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\civicrmtest\sites\all\modules\civicrm\packages\PEAR.php, call_user_func, 901
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\civicrmtest\sites\all\modules\civicrm\packages\DB.php, PEAR_Error, 888
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\civicrmtest\sites\all\modules\civicrm\packages\PEAR.php, DB_Error, 563
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\civicrmtest\sites\all\modules\civicrm\packages\DB\common.php, raiseError, 1849
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\civicrmtest\sites\all\modules\civicrm\packages\DB\mysql.php, raiseError, 894
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\civicrmtest\sites\all\modules\civicrm\packages\DB\mysql.php, mysqlRaiseError, 324
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\civicrmtest\sites\all\modules\civicrm\packages\DB\common.php, simpleQuery, 1162
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\civicrmtest\sites\all\modules\civicrm\packages\DB\DataObject.php, query, 2343
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\civicrmtest\sites\all\modules\civicrm\packages\DB\DataObject.php, _query, 1566
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\civicrmtest\sites\all\modules\civicrm\CRM\Core\DAO.php, query, 716
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\civicrmtest\sites\all\modules\civimember_roles\civimember_roles.module, executeQuery, 411
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\civicrmtest\sites\all\modules\civimember_roles\civimember_roles.module, _civimember_roles_sync, 61
, civimember_roles_menu,
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\civicrmtest\includes\module.inc, call_user_func_array, 406
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\civicrmtest\includes\menu.inc, module_invoke_all, 1224
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\civicrmtest\includes\menu.inc, _menu_append_contextual_items, 220
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\civicrmtest\includes\menu.inc, menu_get_menu, 441
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\civicrmtest\includes\menu.inc, menu_set_active_item, 425
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\civicrmtest\sites\all\modules\securepages\securepages.module, menu_get_active_item, 245
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\civicrmtest\sites\all\modules\securepages\securepages.module, securepages_match, 24
, securepages_init,
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\civicrmtest\includes\module.inc, call_user_func_array, 406
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\civicrmtest\includes\common.inc, module_invoke_all, 1860
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\civicrmtest\includes\bootstrap.inc, _drupal_bootstrap_full, 883
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\civicrmtest\includes\bootstrap.inc, _drupal_bootstrap, 823
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\civicrmtest\index.php, drupal_bootstrap, 13


That is the backtrace that was displayed on the same page as the error.

before I click on the final step, it is

/civicrm/upgrade?_qf_Step6_display=true&qfKey=6824edb81b2226cf871b6ab155e9a2f6

and when the error is displayed, it is

/civicrm/upgrade?_qf_Step7_display=true&qfKey=6824edb81b2226cf871b6ab155e9a2f6

That did it.  Once I disabled civimember_roles, the upgrade went through just fine.  What's even more interesting is that when I went back and enabled it again, I got the exact same error about civicrm_location again.  It looks like that module depends on the civicrm_location table.  I'll definitely add an issue for that module.

Thanks for your help.