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) »
  • "Illegal offset type" warning for Extended Reports
Pages: 1 2 [3] 4

Author Topic: "Illegal offset type" warning for Extended Reports  (Read 5161 times)

JohnM

  • I post occasionally
  • **
  • Posts: 36
  • Karma: 0
  • CiviCRM version: 4.4.6
  • CMS version: Drupal 7
Re: "Illegal offset type" warning for Extended Reports
September 24, 2013, 04:20:33 am
Thanks Eileen. The reports are much better now with those amendments.

A couple of things I have spotted as I have used them...

There are error messages from the webpage when I go into the following reports:

Extended Reports (Price Line Item Membership) showBlocks array item not in .tpl = OptionField_6
Extended Reports (Price - Contribution Based) showBlocks array item not in .tpl = OptionField_6
Extended Reports (Price Line Item) showBlocks array item not in .tpl = OptionField_6
Extended Reports (Price Line Item Participant) showBlocks array item not in .tpl = OptionField_6
Extended Activity Report - includes multi-contact custom fields
showBlocks array item not in .tpl = OptionField_6 showBlocks array item not in .tpl = OptionField_7
showBlocks array item not in .tpl = OptionField_8
Extended Relationship Report showBlocks array item not in .tpl = OptionField_6 showBlocks array item not in .tpl = OptionField_7

Apart from that everything works fine now.

Thanks for the great work on this extension!

Eileen

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4195
  • Karma: 218
    • Fuzion
Re: "Illegal offset type" warning for Extended Reports
September 24, 2013, 01:54:56 pm
showBlocks array item not in .tpl = OptionField_6 - yeah - that just started happening - not sure why
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

JohnM

  • I post occasionally
  • **
  • Posts: 36
  • Karma: 0
  • CiviCRM version: 4.4.6
  • CMS version: Drupal 7
Re: "Illegal offset type" warning for Extended Reports
September 24, 2013, 11:58:38 pm
Maybe worth looking at the Extended Activity Report - this is where the OptionField_6 error first started happening. The last set of changes have then added the OptionField_7 and 8 errors.

Eileen

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4195
  • Karma: 218
    • Fuzion
Re: "Illegal offset type" warning for Extended Reports
September 25, 2013, 04:28:58 pm
It turns out a max of 5 order-bys are supported by the current report framework - http://issues.civicrm.org/jira/browse/CRM-13454 - I've reduced back to sort_name only
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

JohnM

  • I post occasionally
  • **
  • Posts: 36
  • Karma: 0
  • CiviCRM version: 4.4.6
  • CMS version: Drupal 7
Re: "Illegal offset type" warning for Extended Reports
September 25, 2013, 11:56:25 pm
Ok - that makes sense...thanks for giving it a go...

liblogger

  • I’m new here
  • *
  • Posts: 19
  • Karma: 0
  • CiviCRM version: 4.3.5
  • CMS version: Drupal 7.23
  • MySQL version: 5.0.7
  • PHP version: 5.3.5
Re: "Illegal offset type" warning for Extended Reports
September 26, 2013, 03:54:58 am
Hi there - I can't see that last change on github?

With the previous version, apart from the OptionField errors, I'm still seeing the same errors/lack of custom fields as in my last message, I'm afraid.

Eileen

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4195
  • Karma: 218
    • Fuzion
Re: "Illegal offset type" warning for Extended Reports
September 26, 2013, 01:36:51 pm
liblogger - the e-notice should be fixed now - but you will only see custom fields if they are set to searchable - are yours definitely set to that?
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

JohnM

  • I post occasionally
  • **
  • Posts: 36
  • Karma: 0
  • CiviCRM version: 4.4.6
  • CMS version: Drupal 7
Re: "Illegal offset type" warning for Extended Reports
September 26, 2013, 03:21:11 pm
Hi Eileen, Just to confirm that the custom fields on my reports are definitely working.

I have also just had a quick look at the latest version on github and there is still one report showing the .tpl = OptionField_6 error

Extended Activity Report - includes multi-contact custom fields

Eileen

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4195
  • Karma: 218
    • Fuzion
Re: "Illegal offset type" warning for Extended Reports
September 26, 2013, 07:49:37 pm
Really! What order by options do you have? if there are more than 5 options it gives that error. The error is a bit pointless because actually the limitation is that you can only assign 5 options, not that you can only have 5 to choose from. I would be fairly easy to suppress the error in core - but that would not be on everyone's install
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

liblogger

  • I’m new here
  • *
  • Posts: 19
  • Karma: 0
  • CiviCRM version: 4.3.5
  • CMS version: Drupal 7.23
  • MySQL version: 5.0.7
  • PHP version: 5.3.5
Re: "Illegal offset type" warning for Extended Reports
September 27, 2013, 02:38:18 am
Hi Eileen - yes, all the custom fields are set to searchable.

JohnM

  • I post occasionally
  • **
  • Posts: 36
  • Karma: 0
  • CiviCRM version: 4.4.6
  • CMS version: Drupal 7
Re: "Illegal offset type" warning for Extended Reports
September 27, 2013, 02:52:34 am
Actually only 2...I have tried several different Order by Column combinations but the error will not go away.

Eileen

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4195
  • Karma: 218
    • Fuzion
Re: "Illegal offset type" warning for Extended Reports
September 27, 2013, 08:31:45 pm
The error appears if more than 5 fields are AVAILABLE to be filtered on

Does your order by look like the attached (5 order by fields) ?

Note a couple of minor tidy ups just gone into the repo including adding 'source' prefix in the order by list
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

JohnM

  • I post occasionally
  • **
  • Posts: 36
  • Karma: 0
  • CiviCRM version: 4.4.6
  • CMS version: Drupal 7
Re: "Illegal offset type" warning for Extended Reports
September 28, 2013, 05:01:04 am
There is something very odd going on with this report.

I have deleted the original and started afresh. The fields are similar to yours and I am only using one order by column. When I first preview the report there is no error message and it works fine. When I save it or update it the error message appears.

Interestingly when I do save, 2 more order by columns magically appear! Assignee Contact: Name - this is in each of the 2 additional columns. I then try to correct the order by options and save it - the message reappears and I have 3 order by fields (the one I have selected + 2 duplicate fields with Assignee Contact: Name). Hope this is of helpful...

Eileen

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4195
  • Karma: 218
    • Fuzion
Re: "Illegal offset type" warning for Extended Reports
September 29, 2013, 03:25:27 pm
Try again now
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

JohnM

  • I post occasionally
  • **
  • Posts: 36
  • Karma: 0
  • CiviCRM version: 4.4.6
  • CMS version: Drupal 7
Re: "Illegal offset type" warning for Extended Reports
September 30, 2013, 08:18:07 am
Many thanks - that sorted it!
Pages: 1 2 [3] 4
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviReport (Moderator: Dave Greenberg) »
  • "Illegal offset type" warning for Extended Reports

This forum was archived on 2017-11-26.