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

Personal Campaign Page Summary: Database Error Code: Unknown column 'pcp_civireport.contribution_page_id' in 'on clause', 1054

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Major
    • Resolution: Fixed/Completed
    • Affects Version/s: 4.1.0
    • Fix Version/s: 4.1.6
    • Component/s: CiviReport
    • Labels:

      Description

      Non-recoverable error upon opening Personal Campaign Page Summary. Tested on Drupal, Windows. Also reported on Joomla (including online test page).

      Database Error Code: Unknown column 'pcp_civireport.contribution_page_id' in 'on clause', 1054

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

      [code] => -19
      [message] => DB Error: no such field
      [mode] => 16
      [debug_info] => SELECT SQL_CALC_FOUND_ROWS contact_civireport.sort_name as civicrm_contact_sort_name, contact_civireport.id as civicrm_contact_id, contribution_page_civireport.title as civicrm_contribution_page_page_title, pcp_civireport.title as civicrm_pcp_title, pcp_civireport.goal_amount as civicrm_pcp_goal_amount, sum(contribution_soft_civireport.amount) as civicrm_contribution_soft_amount_1_sum, SUM(IF( contribution_civireport.contribution_status_id > 1, 0, contribution_soft_civireport.amount)) as civicrm_contribution_soft_amount_2, COUNT(contribution_soft_civireport.id) as civicrm_contribution_soft_soft_id_count, contribution_civireport.id as civicrm_contribution_contribution_id, max(contribution_civireport.receive_date) as civicrm_contribution_receive_date_max
      FROM civicrm_pcp pcp_civireport

      LEFT JOIN civicrm_contribution_soft contribution_soft_civireport
      ON pcp_civireport.id =
      contribution_soft_civireport.pcp_id

      LEFT JOIN civicrm_contribution contribution_civireport
      ON contribution_soft_civireport.contribution_id =
      contribution_civireport.id

      LEFT JOIN civicrm_contact contact_civireport
      ON pcp_civireport.contact_id =
      contact_civireport.id

      LEFT JOIN civicrm_contribution_page contribution_page_civireport
      ON pcp_civireport.contribution_page_id =
      contribution_page_civireport.id WHERE ( 1 ) GROUP BY pcp_civireport.id ORDER BY contact_civireport.sort_name LIMIT 0, 50 [nativecode=1054 ** Unknown column 'pcp_civireport.contribution_page_id' in 'on clause']
      [type] => DB_Error
      [user_info] => SELECT SQL_CALC_FOUND_ROWS contact_civireport.sort_name as civicrm_contact_sort_name, contact_civireport.id as civicrm_contact_id, contribution_page_civireport.title as civicrm_contribution_page_page_title, pcp_civireport.title as civicrm_pcp_title, pcp_civireport.goal_amount as civicrm_pcp_goal_amount, sum(contribution_soft_civireport.amount) as civicrm_contribution_soft_amount_1_sum, SUM(IF( contribution_civireport.contribution_status_id > 1, 0, contribution_soft_civireport.amount)) as civicrm_contribution_soft_amount_2, COUNT(contribution_soft_civireport.id) as civicrm_contribution_soft_soft_id_count, contribution_civireport.id as civicrm_contribution_contribution_id, max(contribution_civireport.receive_date) as civicrm_contribution_receive_date_max
      FROM civicrm_pcp pcp_civireport

      LEFT JOIN civicrm_contribution_soft contribution_soft_civireport
      ON pcp_civireport.id =
      contribution_soft_civireport.pcp_id

      LEFT JOIN civicrm_contribution contribution_civireport
      ON contribution_soft_civireport.contribution_id =
      contribution_civireport.id

      LEFT JOIN civicrm_contact contact_civireport
      ON pcp_civireport.contact_id =
      contact_civireport.id

      LEFT JOIN civicrm_contribution_page contribution_page_civireport
      ON pcp_civireport.contribution_page_id =
      contribution_page_civireport.id WHERE ( 1 ) GROUP BY pcp_civireport.id ORDER BY contact_civireport.sort_name LIMIT 0, 50 [nativecode=1054 ** Unknown column 'pcp_civireport.contribution_page_id' in 'on clause']
      [to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT SQL_CALC_FOUND_ROWS contact_civireport.sort_name as civicrm_contact_sort_name, contact_civireport.id as civicrm_contact_id, contribution_page_civireport.title as civicrm_contribution_page_page_title, pcp_civireport.title as civicrm_pcp_title, pcp_civireport.goal_amount as civicrm_pcp_goal_amount, sum(contribution_soft_civireport.amount) as civicrm_contribution_soft_amount_1_sum, SUM(IF( contribution_civireport.contribution_status_id > 1, 0, contribution_soft_civireport.amount)) as civicrm_contribution_soft_amount_2, COUNT(contribution_soft_civireport.id) as civicrm_contribution_soft_soft_id_count, contribution_civireport.id as civicrm_contribution_contribution_id, max(contribution_civireport.receive_date) as civicrm_contribution_receive_date_max
      FROM civicrm_pcp pcp_civireport

      LEFT JOIN civicrm_contribution_soft contribution_soft_civireport
      ON pcp_civireport.id =
      contribution_soft_civireport.pcp_id

      LEFT JOIN civicrm_contribution contribution_civireport
      ON contribution_soft_civireport.contribution_id =
      contribution_civireport.id

      LEFT JOIN civicrm_contact contact_civireport
      ON pcp_civireport.contact_id =
      contact_civireport.id

      LEFT JOIN civicrm_contribution_page contribution_page_civireport
      ON pcp_civireport.contribution_page_id =
      contribution_page_civireport.id WHERE ( 1 ) GROUP BY pcp_civireport.id ORDER BY contact_civireport.sort_name LIMIT 0, 50 [nativecode=1054 ** Unknown column 'pcp_civireport.contribution_page_id' in 'on clause']"]
      )

        Attachments

          Activity

            People

            • Assignee:
              ravish.nair Ravish Nair
              Reporter:
              fadeout Fade Out
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: