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 CiviEvent (Moderator: Yashodha Chaku) »
  • Event Participant and Event Income Report (Summary) Collapsed Report Criteria
Pages: [1]

Author Topic: Event Participant and Event Income Report (Summary) Collapsed Report Criteria  (Read 3472 times)

ES.Bill

  • I’m new here
  • *
  • Posts: 3
  • Karma: 0
  • CiviCRM version: 3.4.4
  • CMS version: Drupal 6.20
  • MySQL version: 5.1.54
  • PHP version: 5.2.17
Event Participant and Event Income Report (Summary) Collapsed Report Criteria
July 05, 2011, 10:13:18 am
We have been setting up our first paid event and everything has been working fine except for The Event Participant and Event Income Report (Summary) reports.  I know that they were both working at some time but now the Report Criteria and Report Settings sections of both reports are collapsed and will not open to let us change settings.  The Event Income Report (Detail) and Attendee List reports do let us open  both sections.

I have made two changes since I last saw the reports working properly.  I upgraded CiviCRM from version 3.3.5 to version 3.4.4 and I made two custom fields searchable which were not searchable before.  ( I have since gone back and made the fields unsearchable and I still have the problem.)

I tried the demo site and noticed that the Event Income Report (Summary) was doing the same thing as on my site, but the Event Participant report was working. 

Even though I can't change settings I am getting a report and no errors.

Any help would be appreciated.

Thanks

malks

  • I post occasionally
  • **
  • Posts: 81
  • Karma: 7
  • CiviCRM version: 3.4.x 4.x
  • CMS version: Drupal 6.22
  • MySQL version: 5.1.x
  • PHP version: 5.3.x
Re: Event Participant and Event Income Report (Summary) Collapsed Report Criteria
August 07, 2011, 11:20:34 pm
Hi,

I am seeing the same symptoms on my local and production installs.  I notice that the Event Income Report (Summar) is still not working on the http://drupal.demo.civicrm.org/ site either.  I see one error in Firebug on both my sites and demo:

Code: [Select]
uncaught exception: Missing number at position 0

Is anyone else seeing this or does anyone have an idea on how to diagnose?

Malks.

malks

  • I post occasionally
  • **
  • Posts: 81
  • Karma: 7
  • CiviCRM version: 3.4.x 4.x
  • CMS version: Drupal 6.22
  • MySQL version: 5.1.x
  • PHP version: 5.3.x
Re: Event Participant and Event Income Report (Summary) Collapsed Report Criteria
August 08, 2011, 01:45:06 am
I'm still not 100% sure what was going on here, but if you delete the report and recreate it from the template it seems to work again.  Hope that helps someone.

Siv

  • I post occasionally
  • **
  • Posts: 94
  • Karma: -17
  • CiviCRM version: 4.6.2
  • CMS version: Drupal 7.44
  • MySQL version: 5.5.24
  • PHP version: 5.3.13
Re: Event Participant and Event Income Report (Summary) Collapsed Report Criteria
July 13, 2012, 12:23:54 am
Am also facing the same problem.after some research i found the problem.
Datepicker only causing this issue.
civicrm/template/CRM/Common/jcalendar.tpl at line 115 :: var displayDateValue = cj.datepicker.parseDate( altDateFormat, dateValue );
Civicrm version : 4.1.

But i couldn't solve the problem yet.

jere

  • I post occasionally
  • **
  • Posts: 41
  • Karma: 1
  • CiviCRM version: 4.3.3
  • CMS version: Drupal 7.22
  • MySQL version: 5.5.31
  • PHP version: 5.3.10
Re: Event Participant and Event Income Report (Summary) Collapsed Report Criteria
October 01, 2012, 06:52:40 am
Was this ever resolved? I am having some difficulty with the same line (var displayDateValue = cj.datepicker.parseDate( altDateFormat, dateValue ) in another context.

Eileen

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4195
  • Karma: 218
    • Fuzion
Re: Event Participant and Event Income Report (Summary) Collapsed Report Criteria
April 14, 2013, 06:43:25 pm
I have just hit this on a 3.4 to 4.2 upgrade. I find that any reports returned by this query

Code: [Select]
SELECT * FROM civicrm_report_instance WHERE form_values LIKE '%s:1:" "%'
are problematic & fixed them in our Db & can fix with the below (NB I found that most sites that had started on 3.4 & less appeared to have this bug)


Code: [Select]
UPDATE civicrm_report_instance SET form_values = REPLACE(
  form_values,
  's:34:"participant_register_date_relative";s:1:"0";s:30:"participant_register_date_from";s:1:" ";s:28:"participant_register_date_to";s:1:" "',
  's:34:"participant_register_date_relative";s:1:"0";s:30:"participant_register_date_from";s:0:"";s:28:"participant_register_date_to";s:0:"";')
WHERE form_values LIKE '%s:34:"participant_register_date_relative";s:1:"0";s:30:"participant_register_date_from";s:1:" ";%'
;
UPDATE civicrm_report_instance SET form_values = REPLACE(
  form_values,
's:15:"receive_date_to";s:1:" ";',
's:15:"receive_date_to";s:0:"";'
)
WHERE form_values LIKE '%s:15:"receive_date_to";s:1:" ";%';
UPDATE civicrm_report_instance SET form_values = REPLACE(
  form_values,
's:17:"receive_date_from";s:1:" ";',
's:17:"receive_date_from";s:0:"";'
)
WHERE form_values LIKE '%s:17:"receive_date_from";s:1:" ";%';


Make today the day you step up to support CiviCRM and all the amazing organisations that are using it to improve our world - http://civicrm.org/contribute

kreynen

  • I post occasionally
  • **
  • Posts: 105
  • Karma: 8
Re: Event Participant and Event Income Report (Summary) Collapsed Report Criteria
August 12, 2013, 01:41:13 pm
I just ran into this on a a D6/4.2.9 to D7/4.3.5 upgrade.  @Eileen's UPDATE queries resolved the issue.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviEvent (Moderator: Yashodha Chaku) »
  • Event Participant and Event Income Report (Summary) Collapsed Report Criteria

This forum was archived on 2017-11-26.