CiviCRM Community Forums (archive)

Since I can't find any other posts about this problem I thought I'd document it here. When upgrading from 4.1 -> 4.2 I get:
DB_Error: Upgrade DB to 4.2.alpha1: SQL
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 get this when testing on a sample db and also on a few live dbs. So far I've been unable to make sense of the reference to 'contribution_amount' in the error msg because that is not a column in any table in the db nor is it a value retrieved by that SELECT statement in the INSERT. All the values from the select look normal, but when I run that query on its own in the partially upgraded db I get the same error.

MySQL: 5.5.28-0ubuntu0.12.10.1
Apache: 2.2.22 (Ubuntu)

I'll check to see if upgrading MySQL helps.

Ok, was able to confirm this issue with lobo and totten.
Filed as http://issues.civicrm.org/jira/browse/CRM-11446