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) »
  • Getting error after trying 2.2.7 upgrade to 3.2 ... but upgrade seemed to work?
Pages: [1]

Author Topic: Getting error after trying 2.2.7 upgrade to 3.2 ... but upgrade seemed to work?  (Read 1638 times)

backdrifting

  • I post frequently
  • ***
  • Posts: 178
  • Karma: 2
Getting error after trying 2.2.7 upgrade to 3.2 ... but upgrade seemed to work?
October 17, 2010, 07:36:24 pm
Trying to upgrade 2.2.7 to 3.2.  The upgrade script started running then I received a white screen.  When I try rebuilding the CiviCRM menus by typing in this path:  civicrm/menu/rebuild?reset=1

I get the following error:

<code>Database Error Code: Table '_civoct.civicrm_acl_contact_cache' doesn't exist, 1146
Additional Details:

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

       
Code: [Select]
=> -18
    [message] => DB Error: no such table
    [mode] => 16
    [debug_info] => TRUNCATE TABLE civicrm_acl_contact_cache [nativecode=1146 ** Table '_civoct.civicrm_acl_contact_cache' doesn't exist]
    [type] => DB_Error
    [user_info] => TRUNCATE TABLE civicrm_acl_contact_cache [nativecode=1146 ** Table '_civoct.civicrm_acl_contact_cache' doesn't exist]
    [to_string] => [db_error: message="DB Error: no such table" code=-18 mode=callback callback=CRM_Core_Error::handle prefix="" info="TRUNCATE TABLE civicrm_acl_contact_cache [nativecode=1146 ** Table '_civoct.civicrm_acl_contact_cache' doesn't exist]"]
)
</code>

If I just go to /civicrm I get it to work and the CiviCRM screen loads and tells me:    Menu has been rebuilt Menu has been rebuilt

It also shows I'm now upgraded to 3.2.  Should I just ignore the error above?

Suggestions?

Best-

Trevor

backdrifting

  • I post frequently
  • ***
  • Posts: 178
  • Karma: 2
Re: Getting error after trying 2.2.7 upgrade to 3.2 ... but upgrade seemed to work?
October 17, 2010, 07:41:02 pm
Unfortunately if I go to the CiviCRM Administration console I get this message:

Database check failed - the database looks to have been partially upgraded. You may want to reload the database with the backup and try the upgrade process again.

And if I try loading any dashboards I get the following:

Database Error Code: Table 'ousasand_civoct.civicrm_dashboard' doesn't exist, 1146

So something didn't work correctly here.

Does this mean I should try the entire upgrade process again?  Since I received the white screen originally during the upgrade and that probably has something to do with causing these issues; how can I make sure that doesn't happen again?  I'm running this on a shared server using Siteground as my host.

Best-

Trevor

backdrifting

  • I post frequently
  • ***
  • Posts: 178
  • Karma: 2
Re: Getting error after trying 2.2.7 upgrade to 3.2 ... but upgrade seemed to work?
October 18, 2010, 09:43:54 am
Any assistance/suggestions with this?  Should I just run the upgrade again?

Best-

Trevor

xavier

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4453
  • Karma: 161
    • Tech To The People
  • CiviCRM version: yes probably
  • CMS version: drupal
Re: Getting error after trying 2.2.7 upgrade to 3.2 ... but upgrade seemed to work?
October 18, 2010, 10:33:38 am
Hi,

I would copy the db and do the upgrade on your local machine, then upload the db on the production. lessen the chance of getting the wsod

X+
-Hackathon and data journalism about the European parliament 24-26 jan. Watch out the result

backdrifting

  • I post frequently
  • ***
  • Posts: 178
  • Karma: 2
Re: Getting error after trying 2.2.7 upgrade to 3.2 ... but upgrade seemed to work?
October 21, 2010, 09:41:39 am
I just ran the upgrade on my localhost and it also failed.  Getting the following error during the upgrade process:

Sorry. A non-recoverable error has occurred.

DB Error: a515ac9c2796ca0e23adbe92c68fc9fc

Database Error Code: Error on rename of '.\orciv\civicrm_group_organization' to '.\orciv\#sql2-16e0-379' (errno: 152), 1025

Return to home page.

If I then try to reset the menus by running this path:  http://localhost:8082/civicrm/menu/rebuild?reset=1

I just get a timeout/problem loading page screen.

Suggestions?  This is getting frustrating.

-backdrifting

torenware

  • I post frequently
  • ***
  • Posts: 153
  • Karma: 4
Re: Getting error after trying 2.2.7 upgrade to 3.2 ... but upgrade seemed to work?
October 22, 2010, 05:53:03 pm
I'm not getting this problem, but there does seem to be some "chicken v. egg" type problems -- it's possible for the upgrader to fail to load because some of its tables have not been installed yet.  I'm having problems with civicrm_contactSubtype.  I had to change the source before the upgrader would even load.

I see you have a similar problem with one of the ACL tables.  I'm not sure what to suggest, although if you can set things up so you get a stack crawl (i.e., the hierarchy of functions called on your way to CiviCRM_Core_Error::handle()), it may be possible how to figure out a work-around.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • Getting error after trying 2.2.7 upgrade to 3.2 ... but upgrade seemed to work?

This forum was archived on 2017-11-26.