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) »
  • Developer Discussion (Moderator: Donald Lobo) »
  • Help debugging custom report
Pages: [1]

Author Topic: Help debugging custom report  (Read 591 times)

sggreener

  • I post occasionally
  • **
  • Posts: 35
  • Karma: 0
    • The SpatialDB Advisor
  • CiviCRM version: 4.6.15
  • CMS version: Joomla 5.5.1
  • MySQL version: 5.6.29
  • PHP version: 5.3.8
Help debugging custom report
October 04, 2012, 08:43:37 pm
I have developed a custom report template and am trying to get it working.

Why I try to preview the report I get a web page that says: "DB Error: no such field" or Syntax error etc.

How can I see what the database is seing? That is the SQL fabricated by CiviCRM?

regards
simon

Eileen

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4195
  • Karma: 218
    • Fuzion
Re: Help debugging custom report
October 04, 2012, 10:53:06 pm
Edit CRM/Report/Form.php (I think that's it) & in the postProcess function where it has run buildQuery then add echo $sql; to see what the query is.

Or turn on debugging & make sure backtrace is enabled.
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

sggreener

  • I post occasionally
  • **
  • Posts: 35
  • Karma: 0
    • The SpatialDB Advisor
  • CiviCRM version: 4.6.15
  • CMS version: Joomla 5.5.1
  • MySQL version: 5.6.29
  • PHP version: 5.3.8
Re: Help debugging custom report
October 05, 2012, 12:30:40 am
Eileen,

Thank you.

regards
Simon
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Developer Discussion (Moderator: Donald Lobo) »
  • Help debugging custom report

This forum was archived on 2017-11-26.