CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Discussion (deprecated) »
  • Alpha and Beta Release Testing »
  • 4.1 Release Testing (Moderator: Kurund Jalmi) »
  • Campaign Page Summary crash
Pages: [1]

Author Topic: Campaign Page Summary crash  (Read 1055 times)

JoeMurray

  • Administrator
  • Ask me questions
  • *****
  • Posts: 578
  • Karma: 24
    • JMA Consulting
  • CiviCRM version: 4.4 and 4.5 (as of Nov 2014)
  • CMS version: Drupal, WordPress, Joomla
  • MySQL version: MySQL 5.5, 5.6, MariaDB 10.0 (as of Nov 2014)
Campaign Page Summary crash
February 05, 2012, 01:33:10 pm
On http://sandbox.drupal.civicrm.org/civicrm/report/instance/15?reset=1:

Sorry. A non-recoverable error has occurred.
DB Error: no such field
Error Details
Database Error Code: Unknown column 'pcp_civireport.contribution_page_id' in 'on clause', 1054
Additional Details:

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

       
Code: [Select]
=> -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']"]
)

Return to home page.
Co-author of Using CiviCRM https://www.packtpub.com/using-civicrm/book
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Discussion (deprecated) »
  • Alpha and Beta Release Testing »
  • 4.1 Release Testing (Moderator: Kurund Jalmi) »
  • Campaign Page Summary crash

This forum was archived on 2017-11-26.