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) »
  • Upgrading WordPress install of CiviCRM from 4.2.1 to 4.4.6
Pages: 1 [2]

Author Topic: Upgrading WordPress install of CiviCRM from 4.2.1 to 4.4.6  (Read 3619 times)

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Upgrading WordPress install of CiviCRM from 4.2.1 to 4.4.6
July 25, 2014, 03:33:18 am
Quote from: sfeher on July 24, 2014, 01:47:23 pm
Is this actually how you all manage data from version to version?

No, it's rare that one needs to do this. Generally, the upgrader works fine.

Quote from: sfeher on July 24, 2014, 01:47:23 pm
    There's no other way to upload/update data from version 4.2.1 beyond 4.2.3? 

It would appear that your situation, for whatever reasons, is unique. I have not heard of anyone else getting "stuck" at this stage, and I run upgrades regularly, on production DBs, and have been doing so for years, and I have never had this issue.

However after I review your initial post again, what I would suggest is that if this is the issue:

Code: [Select]
ALTER TABLE civicrm_discount DROP FOREIGN KEY FK_civicrm_discount_option_group_id [nativecode=1025 ** Error on rename of './stjocl14_civiCRM/civicrm_discount' to './stjocl14_civiCRM/#sql2-26c4-23f59b' (errno: 152)]
then open up civicrm/CRM/Upgrade/Incremental/sql/4.2.3.mysql.tpl and remove line 46:

Code: [Select]
ALTER TABLE civicrm_discount DROP FOREIGN KEY FK_civicrm_discount_option_group_id;
and try again. Because in reality there are only two more lines left in that file and then you finished the 4.2.3 upgrade.

So first make sure you have a clean 4.2.2 DB and then delete the line above and then proceed and let us know what happens.
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

Michael McAndrew

  • Forum Godess / God
  • I live on this forum
  • *****
  • Posts: 1274
  • Karma: 55
    • Third Sector Design
  • CiviCRM version: various
  • CMS version: Nearly always Drupal
  • MySQL version: 5.5
  • PHP version: 5.3
Re: Upgrading WordPress install of CiviCRM from 4.2.1 to 4.4.6
July 28, 2014, 07:53:12 am
Hey there,

A different perspective on this. Hopefully it is useful.

IMO this sounds like a "spend time to save money or spend money to save time" scenario.

Upgrade problems can be hard to diagnose if one of more of the following applies

* you are not familiar with CiviCRM / it is your first installation
* you have not upgraded before
* don't have MySQL experience

So I think you have two options:

1) Upgrade and learn the hard way, with some help from some of the volunteers in this forum, etc. I'm not sure how long this will take since I'm not sure about your experience, etc.  If you do get there, you will have learnt a lot. (Whether it will have been worth it depends on if you will be doing more upgrades like this in the future.)
2) Pay someone who has been there before to do help you out. This might be a better solution for you.



Service providers: Grow your business, build your reputation and support CiviCRM. Become a partner today

sammy66

  • I’m new here
  • *
  • Posts: 2
  • Karma: 0
  • CiviCRM version: 2.0.5
  • CMS version: 2.0.5
  • MySQL version: 2.0.5
  • PHP version: 2.0.5
Re: Upgrading WordPress install of CiviCRM from 4.2.1 to 4.4.6
July 30, 2014, 06:06:51 am
I was running civi 4.2.7 in Joomla and having trouble upgrading, so I migrated to WP. I found the upgrades went smoothly from 4.2.7 to 4.3.5, then to 4.4.5, then 4.4.6. (You might be able to skip 4.4.5, at the time I was working on this 4.4.6 wasn't out yet.)
daily deals, online shopping sites, hot deals, best deals

phanhan

  • I’m new here
  • *
  • Posts: 6
  • Karma: 0
  • CiviCRM version: 234
  • CMS version: joomla
  • MySQL version: 3.4
  • PHP version: 2.34
Re: Upgrading WordPress install of CiviCRM from 4.2.1 to 4.4.6
September 16, 2014, 07:43:12 pm
this is an issue that I am interested.
My advice is when doing increments, go to the latest 4.3, not 4.3.1
How many custom code/template files do you have? Any custom extensions or modules?
« Last Edit: October 21, 2015, 08:00:53 am by mathieu »
Pages: 1 [2]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • Upgrading WordPress install of CiviCRM from 4.2.1 to 4.4.6

This forum was archived on 2017-11-26.