Details
-
Type:
Task
-
Status: Done/Fixed
-
Priority:
Critical
-
Resolution: Fixed/Completed
-
Affects Version/s: 4.2.6
-
Fix Version/s: 4.3.0
-
Component/s: Core CiviCRM
-
Labels:
Description
Coleman, dgg suggested I assign this to you.
Using a db supplied by Stuart Gaston to test a 4.0.8 -> 4.3.alpha1 upgrade, Mitharshan encountered the attached error.
We're unable to test the 4.3 upgrade stuff until this is resolved.
Attachments
Activity
So far I haven't even been able to get as far as that error in my testing. I got the following on that db, and then reproduced it again on a vanilla sample 4.1.6 db.
INSERT INTO civicrm_price_field_value ( price_field_id, name, label, description, amount, membership_type_id) SELECT cpf.id, cmt.name as label1, cmt.name as label2,cmt.description, cmt.minimum_fee, cmt.id FROM `civicrm_membership_type` cmt LEFT JOIN civicrm_price_field cpf ON cmt.member_of_contact_id = cpf.name [nativecode=1292 ** Truncated incorrect DOUBLE value: 'contribution_amount']
I'm finding it hard to figure out what that error even means since the column 'contribution_amount' is not referenced in the query.
My setup is as follows:
MYSQL 5.5
PHP 5.4
Ubuntu 12.10
CiviCRM 4.2 branch (svn checkout)
We've received the same error when attempting to upgrade the Drupal Association db from 4.1.7 to 4.3.alpha1 as well. See image 4.2civii upgrde.png