Upgrading WordPress install of CiviCRM from 4.2.1 to 4.4.6

[Hershel]

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.

    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.

[Michael McAndrew]

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.

[sammy66]

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.)

[phanhan]

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?