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) »
  • How do you rerun the DB update? Failed upgrade to 2.2.5
Pages: [1]

Author Topic: How do you rerun the DB update? Failed upgrade to 2.2.5  (Read 1248 times)

Daria

  • Guest
How do you rerun the DB update? Failed upgrade to 2.2.5
June 09, 2009, 12:38:28 pm
First of all I need to say that I came into this whole thing in the middle so I do not know what the original error was....

We are in limbo between DBs upgrades. It seems like we are missing some of the updates but not others. We do not have the skip_breadcrumb field in civicrm_menu but when I remove the old component (following the failed upgrade instructions) and run the install and DB upgrade I get an error that the table  civicrm_php_block already exists. I have renamed that table and tried to run the db update again it says I am already at 2.2.5.

How can I see what the upgrade script is to see if I have other tables/columns that I need to clean up?
How can I rerun the db upgrade?

Thanks,
Daria
« Last Edit: June 09, 2009, 05:13:22 pm by Daria »

Kurund Jalmi

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4169
  • Karma: 128
    • CiviCRM
  • CiviCRM version: 4.x, future
  • CMS version: Drupal 7, Joomla 3.x
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: How do you rerun the DB update? Failed upgrade to 2.2.5
June 10, 2009, 04:12:02 am
Daria:

Quote
DB upgrade I get an error that the table  civicrm_php_block already exists.
This is not a CiviCRM related table.  Do you mean civicrm_pcp_block ?

I would recommend you should restore to original CiviCRM database and then run upgrade processt. Also what is the version of your current CiviCRM i.e before upgrade.

HTh

Kurund
Found this reply helpful? Support CiviCRM

Daria

  • Guest
Re: How do you rerun the DB update? Failed upgrade to 2.2.5
June 10, 2009, 04:21:35 am
Sorry it is civicrm_pcp_block.

We had a failed 2.2.1 upgrade and I can't go back to that backup because it was months ago and there has been a lot of new data added since then.

I did go back to the pre-re-upgrade (from failed 2.2.1-2.2.5) and tried it again... It didn't help. Are you suggesting that I do it again and get rid of the civicrm_pcp_block and try it again. Then if it dies on another table am I supposed to go back and remove that table and keep doing this till I finally make it through??? REALLY?

This is so painful....

Kurund Jalmi

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4169
  • Karma: 128
    • CiviCRM
  • CiviCRM version: 4.x, future
  • CMS version: Drupal 7, Joomla 3.x
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: How do you rerun the DB update? Failed upgrade to 2.2.5
June 10, 2009, 06:02:23 am
Quote
We had a failed 2.2.1 upgrade
What failed? Errors ?
Quote
I did go back to the pre-re-upgrade (from failed 2.2.1-2.2.5) and tried it again..
What was the version of pre-re-upgrade CiviCRM ?

Ping us  on #civicrm irc channel, will be easier to debug

Kurund

Found this reply helpful? Support CiviCRM
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • How do you rerun the DB update? Failed upgrade to 2.2.5

This forum was archived on 2017-11-26.