Uploaded image for project: 'CiviCRM'
  1. CiviCRM
  2. CRM-12598

Database Error Code: Unknown column 'price_field_' in 'field list', 1054

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Critical
    • Resolution: Cannot Reproduce
    • Affects Version/s: 4.3.1
    • Fix Version/s: 4.3.4
    • Component/s: Core CiviCRM
    • Labels:
      None

      Description

      We use price sets for events / registrations, after we upgraded from Drupal 6 to 7, and from CiviCRM 4.2 to 4.3.1 we receive this error when clicking on the "Groups Tab" on any contact record.

      Database Error Code: Unknown column 'price_field_' in 'field list', 1054
      Additional Details:

      Array
      (
      [callback] => Array
      (
      [0] => CRM_Core_Error
      [1] => handle
      )

      [code] => -19
      [message] => DB Error: no such field
      [mode] => 16
      [debug_info] =>
      UPDATE civicrm_temp_custom_35d0b0ffcfad456434371df1e325f954
      SET price_field_ = 1,price_field_ = 1,price_field_ = 1,price_field_ = 1,price_field_ = 1,price_field_ = 1,price_field_ = 1,price_field_ = 1,price_field_ = 1,price_field_ = 1,price_field_ = 1,price_field_ = 1,price_field_ = 1,price_field_ = 1,price_field_ = 1
      WHERE participant_id = 448;
      [nativecode=1054 ** Unknown column 'price_field_' in 'field list']
      [type] => DB_Error
      [user_info] =>
      UPDATE civicrm_temp_custom_35d0b0ffcfad456434371df1e325f954
      SET price_field_ = 1,price_field_ = 1,price_field_ = 1,price_field_ = 1,price_field_ = 1,price_field_ = 1,price_field_ = 1,price_field_ = 1,price_field_ = 1,price_field_ = 1,price_field_ = 1,price_field_ = 1,price_field_ = 1,price_field_ = 1,price_field_ = 1
      WHERE participant_id = 448;
      [nativecode=1054 ** Unknown column 'price_field_' 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_35d0b0ffcfad456434371df1e325f954
      SET price_field_ = 1,price_field_ = 1,price_field_ = 1,price_field_ = 1,price_field_ = 1,price_field_ = 1,price_field_ = 1,price_field_ = 1,price_field_ = 1,price_field_ = 1,price_field_ = 1,price_field_ = 1,price_field_ = 1,price_field_ = 1,price_field_ = 1
      WHERE participant_id = 448;
      [nativecode=1054 ** Unknown column 'price_field_' in 'field list']"]
      )

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              zkrebs Zachary
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: