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']"]
)