CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site

This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • Fatal error "civicrm_location doesn't exist" upgrading 1.9 -> 2.0
Pages: [1]

Author Topic: Fatal error "civicrm_location doesn't exist" upgrading 1.9 -> 2.0  (Read 3164 times)

Wonder95

  • Guest
Fatal error "civicrm_location doesn't exist" upgrading 1.9 -> 2.0
May 23, 2008, 03:24:15 pm
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:

Code: [Select]
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]

Deepak Srivastava

  • Moderator
  • Ask me questions
  • *****
  • Posts: 677
  • Karma: 65
Re: Fatal error "civicrm_location doesn't exist" upgrading 1.9 -> 2.0
May 23, 2008, 10:57:39 pm
The query in the error you pasted doesn't relate to upgrade queries. The error looks to be related with 1.9 code-base. Not sure what could be going wrong.

Did you proceed exactly in the manner mentioned on http://wiki.civicrm.org/confluence/display/CRMDOC/Upgrade+Drupal+Sites+to+2.0 ?

Found this reply helpful? Contribute NOW and help us improve CiviCRM with the Make it Happen! initiative.

Wonder95

  • Guest
Re: Fatal error "civicrm_location doesn't exist" upgrading 1.9 -> 2.0
May 24, 2008, 08:44:13 am
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.

Deepak Srivastava

  • Moderator
  • Ask me questions
  • *****
  • Posts: 677
  • Karma: 65
Re: Fatal error "civicrm_location doesn't exist" upgrading 1.9 -> 2.0
May 24, 2008, 09:09:08 am
Can you check with back-trace on and paste the output here.

You can switch on the back-trace by commenting the lines - 257 & 259 in the file CRM/Core/Error.php
Found this reply helpful? Contribute NOW and help us improve CiviCRM with the Make it Happen! initiative.

Wonder95

  • Guest
Re: Fatal error "civicrm_location doesn't exist" upgrading 1.9 -> 2.0
May 24, 2008, 08:47:32 pm
Here is the backtrace.

Code: [Select]
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

Deepak Srivastava

  • Moderator
  • Ask me questions
  • *****
  • Posts: 677
  • Karma: 65
Re: Fatal error "civicrm_location doesn't exist" upgrading 1.9 -> 2.0
May 24, 2008, 09:53:18 pm
Can't see the call to any upgrade process. I am actually interested in the backtrace of the last step of the upgrade process where you noticed the location related problem, along /w the error and the url.
Found this reply helpful? Contribute NOW and help us improve CiviCRM with the Make it Happen! initiative.

Wonder95

  • Guest
Re: Fatal error "civicrm_location doesn't exist" upgrading 1.9 -> 2.0
May 24, 2008, 10:06:55 pm
That is the backtrace that was displayed on the same page as the error.

Deepak Srivastava

  • Moderator
  • Ask me questions
  • *****
  • Posts: 677
  • Karma: 65
Re: Fatal error "civicrm_location doesn't exist" upgrading 1.9 -> 2.0
May 24, 2008, 10:11:51 pm
Ok, what was the url which displayed this backtrace & the error you pasted ?
Found this reply helpful? Contribute NOW and help us improve CiviCRM with the Make it Happen! initiative.

Wonder95

  • Guest
Re: Fatal error "civicrm_location doesn't exist" upgrading 1.9 -> 2.0
May 24, 2008, 10:27:28 pm
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

Deepak Srivastava

  • Moderator
  • Ask me questions
  • *****
  • Posts: 677
  • Karma: 65
Re: Fatal error "civicrm_location doesn't exist" upgrading 1.9 -> 2.0
May 24, 2008, 11:11:48 pm
hmm, looking at your backtrace it seems some other module "civimember_roles" other than civicrm is being invoked. Can you try removing / disabling that ? I suspect that module is not compatible with civicrm 2.0 and hence you see that error.   
« Last Edit: May 24, 2008, 11:14:17 pm by Deepak Srivastava »
Found this reply helpful? Contribute NOW and help us improve CiviCRM with the Make it Happen! initiative.

Wonder95

  • Guest
Re: Fatal error "civicrm_location doesn't exist" upgrading 1.9 -> 2.0
May 24, 2008, 11:20:19 pm
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.

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • Fatal error "civicrm_location doesn't exist" upgrading 1.9 -> 2.0

This forum was archived on 2017-11-26.