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

          [CRM-10096] Personal Campaign Page Summary: Database Error Code: Unknown column 'pcp_civireport.contribution_page_id' in 'on clause', 1054
          Donald A. Lobo added a comment -


          This is fixed in 4.1.2

          Fade Out added a comment -

          Still getting "DB Error: no such field" in 4.1.2 - will investigate.

          Hari Prasad added a comment -

          able to reproduce this on 4.1.3, Drupal 7.

          Hari Prasad added a comment -

          Okay, I'm able to replicate this issue on Drupal 7 demo site as well:
          http://drupal.demo.civicrm.org/civicrm/report/instance/15?reset=1

          Hari Prasad added a comment -

          Here's the diff of a quick patch for this on 4.1.3:

          CRM/Report/Form/Contribute/PCP.php
          76a77,84
          > 'page_id' =>
          > array('id' => ts('Contribution ID'),
          > 'name' => 'id',
          > 'type' => CRM_Utils_Type::T_STRING,
          > 'default' => TRUE,
          > 'required' => TRUE,
          > 'no_display' => TRUE,
          > ),
          201c209
          < ON {$this->_aliases['civicrm_pcp']}.contribution_page_id =

          > ON {$this->_aliases['civicrm_pcp']}.page_id =

          Kindly review this. I can fine-tune it a bit more and attach a diff or patch against the latest code checked out from svn as needed.

          Fade Out added a comment -

          Hi,

          That fixes it for me!

          Nice one.

          Ravish Nair added a comment -

          Checked in r41680

            People

            • Assignee:
              Ravish Nair
              Reporter:
              Fade Out

              Dates

              • Created:
                Updated:
                Resolved: