CiviCRM Community Forums (archive)

Is your 4.1.5 a fresh or upgraded CiviCRM install?

Kurund

I seemingly ran into the same error when upgrading from 4.2.0 to 4.2.2. The upgrade hangs at the step Upgrade DB to 4.2.alpha1: Contributions (1 => 5000)
I tried that 2 times with the same result.

The error report was as follows

Error Field	Error Value
Type	DB_Error
Code	-3
Message	DB Error: constraint violation
Mode	16
UserInfo	INSERT INTO civicrm_line_item (entity_table , entity_id , label , qty , unit_price , line_total , participant_count ) VALUES ('civicrm_contribution' , 22 , 'Contribution Amount' , 1 , 100.00 , 100.00 , 0 ) [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`c3_civicrm`.`civicrm_line_item`, CONSTRAINT `FK_civicrm_line_item_price_field_id` FOREIGN KEY (`price_field_id`) REFERENCES `civicrm_price_field` (`id`) ON DELETE CASCADE)]
DebugInfo	INSERT INTO civicrm_line_item (entity_table , entity_id , label , qty , unit_price , line_total , participant_count ) VALUES ('civicrm_contribution' , 22 , 'Contribution Amount' , 1 , 100.00 , 100.00 , 0 ) [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`c3_civicrm`.`civicrm_line_item`, CONSTRAINT `FK_civicrm_line_item_price_field_id` FOREIGN KEY (`price_field_id`) REFERENCES `civicrm_price_field` (`id`) ON DELETE CASCADE)]

I've attached a screenshot which perhaps contains some additional information.

I remember when ugrading from 4.0.x to 4.2.0 there was the same error (at least it was about 'contributions'). But the last time the error page had a Proceed-button which turned out was safe to use. This time the button is missing

I can confirm a similar experience on an upgrade from 3.4.8 to 4.2.2.

Issue 1: The process stalled at 4.1.beta, and I left it running overnight.   When I reloaded the page in the morning, the upgrade proceeded without error until...

Issue 2: 4.2.alpha1, when it stalled again.  I left for 1 hour, and returned, and reloaded the page.  That's when I got this error

ALTER TABLE `civicrm_prevnext_cache` ADD COLUMN is_selected tinyint(4)
DEFAULT '0' [nativecode=1060 ** Duplicate column name 'is_selected']

I dropped the db, loaded it again, tried upgrade again with the same error, same result. 

I have not yet tried the schema integrity check, but it seems if this is_selected is a new column for 4.1 or 4.2, then why should it error?

Would it help to upgrade to 4.1 FIRST and then a subsequent upgrade to 4.2?

Any other ideas?

Does anyone in this thread have the modules jQuery Update, jQuery UI, or another module that does something with jQuery installed?

It looks like the upgrade gets through the first part of the update to 4.2.alpha1, in that all the database changes in this file:

civicrm/CRM/Upgrade/Incremental/sql/4.2.alpha1.mysql.tpl

were made to the database. So it hangs somewhere after this... hopefully that helps.

Are there any logs that would show more detailed progress of the upgrade?

Just my 2 cents on upgrading, it may help. The first thing I would do is make sure the integrity of the database schema is up to date for the version you currently have installed. Kurund points out this step below as well. But this is the absolute best way to know that what your trying to upgrade is in a good state. Instructions for this step can be found here:

http://wiki.civicrm.org/confluence/display/CRMDOC42/Ensuring+Schema+Integrity+on+Upgrades

Secondly...I have done many civicrm upgrades from various version. It can be difficult and patience is a virtue. I would advise against trying to do large jumps in 1 swoop. IE 3.4.8 to 4.2.2. In my experience doing smaller jumps seems to breed less frustration. The reason being, smaller jumps introduces less changes to the database. I have had much more success doing upgrades more incrementally.

99% of the time I have experienced an error it has some way or another been related to a foreign key constraint. Often times my best course of action was to check the civicrm domain table after a failed upgrade and checking where the upgraded stopped. Then I would go in to that .sql file and comment out the part where the error is coming in. After I got through those errors and at least got my civi install up to the version I wanted, I would ensure the schema by using the method above.

Finally just a couple notes to keep in mind for people managing civi sites. CiviCRM 4.2.4 is the first version to no longer support php 5.2. This means if your joomla/drupal/wp site was built on a system with php 5.2, civi 4.2.2 is the highest you will be able to upgrade to unless you redo your site in php 5.3. This does not require a full rebuild of the site but is still kind of a pain and its a good thing to think about beforehand. Also with civi 4.2.4 a higher level of database privilege is now required to run the db upgrade. If not properly permissioned you will get an error saying that you need a 'Super' privilege to execute the upgrade. This can pose problems on shared hosts such as godaddy or network solutions as you can't get this level of access. I had to use a personal wamp installation to get a few sites from 4.2.2 to 4.2.4. Food for thought.

We're having the same problem
Running 4.1.5 under drupal 7.19

I've tried in the past and have the progress bar hang at about 10% and that's it

Did a restore and got it back working

I tried the incremental upgrade and was successful from 4.1.5 to 4.1.6

Any suggestions?

Thanks!