DB Error: No Such Field (On Price Set Custom Field Export)

[zkrebs]

Help!
Drupal 7, CiviCRM 4.4.4

Database Error Code: Unknown column 'price_field_438' in 'field list', 1054
Additional Details:
Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

Code: [Select]

=> -19
    [message] => DB Error: no such field
    [mode] => 16
    [debug_info] =>
UPDATE civicrm_temp_custom_20187c4970e7d90400b605b40089672e
SET price_field_438 = 1
WHERE participant_id = 1130;
 [nativecode=1054 ** Unknown column 'price_field_438' in 'field list']
    [type] => DB_Error
    [user_info] =>
UPDATE civicrm_temp_custom_20187c4970e7d90400b605b40089672e
SET price_field_438 = 1
WHERE participant_id = 1130;
 [nativecode=1054 ** Unknown column 'price_field_438' in 'field list']
    [to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="
UPDATE civicrm_temp_custom_20187c4970e7d90400b605b40089672e
SET price_field_438 = 1
WHERE participant_id = 1130;
 [nativecode=1054 ** Unknown column 'price_field_438' in 'field list']"]
)


[Hershel]

Hard to know what may be wrong. Did you drop any fields ever? Or any price sets?

Do you know what field 438 is?

[zkrebs]

I think when we made our 2012 conference we used price sets for early bird and normal prices, made it live, and some may have been deleted in the process as our requirements changed. Any hope of what I can do to fix this? Field 438 - no idea!

[Hershel]

Seems you may need to recreate that missing field, but you would probably need MySQL skills for that. You would have to create it normally through the CiviCRM interface and then edit the name in the database, in (at least) two places.

I'm guessing that's the fix that will be necessary. I'm not certain. You might want to hire a consultant.