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) »
  • Support »
  • Using CiviCRM »
  • Using CiviReport (Moderator: Dave Greenberg) »
  • Constituent Report (Detail) Bug
Pages: [1]

Author Topic: Constituent Report (Detail) Bug  (Read 1691 times)

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Constituent Report (Detail) Bug
September 15, 2010, 09:24:50 am
To recreate:

1. Install CiviCRM 3.2.3 on a freshly installed Drupal 6.19.

2. Click CiviCRM.

3. Choose "Constituent Report (Detail)" from the menus.

4. I get:

Code: [Select]
Sorry. A non-recoverable error has occurred.
DB Error: no such field
Error Details
Database Error Code: Unknown column 'participant_civireport.participant_status_id' 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] => SELECT participant_civireport.contact_id as civicrm_participant_contact_id, participant_civireport.id as civicrm_participant_participant_id, participant_civireport.event_id as civicrm_participant_event_id, participant_civireport.participant_status_id as civicrm_participant_participant_status_id, participant_civireport.role_id as civicrm_participant_role_id, participant_civireport.register_date as civicrm_participant_participant_register_date, participant_civireport.fee_level as civicrm_participant_fee_level, participant_civireport.fee_amount as civicrm_participant_fee_amount   FROM
                            civicrm_contact  contact_civireport
                            INNER JOIN civicrm_participant       participant_civireport
                                    ON contact_civireport.id = participant_civireport.contact_id
                               
                         WHERE    contact_civireport.id IN ( 1 )
                         GROUP BY contact_civireport.id,participant_civireport.id  [nativecode=1054 ** Unknown column 'participant_civireport.participant_status_id' in 'field list']
    [type] => DB_Error
    [user_info] => SELECT participant_civireport.contact_id as civicrm_participant_contact_id, participant_civireport.id as civicrm_participant_participant_id, participant_civireport.event_id as civicrm_participant_event_id, participant_civireport.participant_status_id as civicrm_participant_participant_status_id, participant_civireport.role_id as civicrm_participant_role_id, participant_civireport.register_date as civicrm_participant_participant_register_date, participant_civireport.fee_level as civicrm_participant_fee_level, participant_civireport.fee_amount as civicrm_participant_fee_amount   FROM
                            civicrm_contact  contact_civireport
                            INNER JOIN civicrm_participant       participant_civireport
                                    ON contact_civireport.id = participant_civireport.contact_id
                               
                         WHERE    contact_civireport.id IN ( 1 )
                         GROUP BY contact_civireport.id,participant_civireport.id  [nativecode=1054 ** Unknown column 'participant_civireport.participant_status_id' in 'field list']
    [to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT participant_civireport.contact_id as civicrm_participant_contact_id, participant_civireport.id as civicrm_participant_participant_id, participant_civireport.event_id as civicrm_participant_event_id, participant_civireport.participant_status_id as civicrm_participant_participant_status_id, participant_civireport.role_id as civicrm_participant_role_id, participant_civireport.register_date as civicrm_participant_participant_register_date, participant_civireport.fee_level as civicrm_participant_fee_level, participant_civireport.fee_amount as civicrm_participant_fee_amount   FROM
                            civicrm_contact  contact_civireport
                            INNER JOIN civicrm_participant       participant_civireport
                                    ON contact_civireport.id = participant_civireport.contact_id
                               
                         WHERE    contact_civireport.id IN ( 1 )
                         GROUP BY contact_civireport.id,participant_civireport.id  [nativecode=1054 ** Unknown column 'participant_civireport.participant_status_id' in 'field list']"]
)
[/code]
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: Constituent Report (Detail) Bug
September 15, 2010, 11:55:27 am
Just tried that report on our public demo. There are participant records included there - and not getting that error:
http://drupal.demo.civicrm.org/civicrm/report/instance/2&reset=1

Perhaps you've got a different set of display columns or filters? Hopefully you can find a way to recreate this on the demo - or identify if there's particular records in your DB that are triggering it.
Protect your investment in CiviCRM by  becoming a Member!

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Constituent Report (Detail) Bug
September 15, 2010, 12:04:12 pm
Dave, my DB has no data. My steps to recreate above are very simple yet very precise. Just install a fresh CiviCRM with no data and then do nothing but go straight to the report. Someone sent me this precise bug report and I confirmed it by doing it myself. Just try it--you'll see. :)
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Constituent Report (Detail) Bug
September 15, 2010, 12:19:22 pm
To clarify--a client of mine reported that he saw this bug on his existing install and then as part of his own debugging, he found it on a fresh install. It's not appearing on the demo site, no, but I confirmed that it exists on a fresh install. Perhaps if we can determine why that is, then that will fix the issue on his "real" install.

Thanks.
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

jeffmikels

  • I’m new here
  • *
  • Posts: 26
  • Karma: 0
Re: Constituent Report (Detail) Bug
September 17, 2010, 11:20:39 am
I just got this result by following these steps:

Upgraded my site from 3.1.3 to 3.2.3
Select Constituent Report (Detail)

bam

Database Error Code: Unknown column 'participant_civireport.participant_status_id' in 'field list', 1054

Code: [Select]
Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )
 
    [code] => -19
    [message] => DB Error: no such field
    [mode] => 16
    [debug_info] => SELECT participant_civireport.contact_id as civicrm_participant_contact_id, participant_civireport.id as civicrm_participant_participant_id, participant_civireport.event_id as civicrm_participant_event_id, participant_civireport.participant_status_id as civicrm_participant_participant_status_id, participant_civireport.role_id as civicrm_participant_role_id, participant_civireport.register_date as civicrm_participant_participant_register_date, participant_civireport.fee_level as civicrm_participant_fee_level, participant_civireport.fee_amount as civicrm_participant_fee_amount   FROM
                            civicrm_contact  contact_civireport
                            INNER JOIN civicrm_participant       participant_civireport
                                    ON contact_civireport.id = participant_civireport.contact_id
                               
                         WHERE    contact_civireport.id IN ( 1,13,15,16,18,19,21,22,23,24 )
                         GROUP BY contact_civireport.id,participant_civireport.id  [nativecode=1054 ** Unknown column 'participant_civireport.participant_status_id' in 'field list']
    [type] => DB_Error
    [user_info] => SELECT participant_civireport.contact_id as civicrm_participant_contact_id, participant_civireport.id as civicrm_participant_participant_id, participant_civireport.event_id as civicrm_participant_event_id, participant_civireport.participant_status_id as civicrm_participant_participant_status_id, participant_civireport.role_id as civicrm_participant_role_id, participant_civireport.register_date as civicrm_participant_participant_register_date, participant_civireport.fee_level as civicrm_participant_fee_level, participant_civireport.fee_amount as civicrm_participant_fee_amount   FROM
                            civicrm_contact  contact_civireport
                            INNER JOIN civicrm_participant       participant_civireport
                                    ON contact_civireport.id = participant_civireport.contact_id
                               
                         WHERE    contact_civireport.id IN ( 1,13,15,16,18,19,21,22,23,24 )
                         GROUP BY contact_civireport.id,participant_civireport.id  [nativecode=1054 ** Unknown column 'participant_civireport.participant_status_id' in 'field list']
    [to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT participant_civireport.contact_id as civicrm_participant_contact_id, participant_civireport.id as civicrm_participant_participant_id, participant_civireport.event_id as civicrm_participant_event_id, participant_civireport.participant_status_id as civicrm_participant_participant_status_id, participant_civireport.role_id as civicrm_participant_role_id, participant_civireport.register_date as civicrm_participant_participant_register_date, participant_civireport.fee_level as civicrm_participant_fee_level, participant_civireport.fee_amount as civicrm_participant_fee_amount   FROM
                            civicrm_contact  contact_civireport
                            INNER JOIN civicrm_participant       participant_civireport
                                    ON contact_civireport.id = participant_civireport.contact_id
                               
                         WHERE    contact_civireport.id IN ( 1,13,15,16,18,19,21,22,23,24 )
                         GROUP BY contact_civireport.id,participant_civireport.id  [nativecode=1054 ** Unknown column 'participant_civireport.participant_status_id' in 'field list']"]
)
[/code]

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: Constituent Report (Detail) Bug
September 17, 2010, 01:49:07 pm
Jeff / Hershel - This bug has been reported and fixed for 3.2.4 (next release):

http://issues.civicrm.org/jira/browse/CRM-6796

I went to the Fisheye tab and looks like there's 2 related commits - so might be a bit tricky to patch, but you can try if it's critical. The changes only affect one file so you can back that one up and restore if the patches mess things up.

BTW - with the new CiviSearch you can a bit more easily find existing bugs. I put this in "Constituent Detail Report bug" and got the issue tracker issue right away.
Protect your investment in CiviCRM by  becoming a Member!

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Constituent Report (Detail) Bug
September 19, 2010, 03:22:47 am
Thank you, Dave. Could you tell me which file you meant? The fisheye tab there indicates around 200 files were edited. :)
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: Constituent Report (Detail) Bug
September 19, 2010, 07:21:57 am
I think the relevant changes are in branches/v3.2/CRM/Report/Form/Contact/Detail.php. However, given all the other files in the changesets it's possible that other changes are buried in there. I guess try patching Detail.php and see if that fixes things for you.
Protect your investment in CiviCRM by  becoming a Member!
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviReport (Moderator: Dave Greenberg) »
  • Constituent Report (Detail) Bug

This forum was archived on 2017-11-26.