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 CiviContribute (Moderator: Donald Lobo) »
  • Contribution search in Search Builder - undefined variable, group save errors
Pages: [1]

Author Topic: Contribution search in Search Builder - undefined variable, group save errors  (Read 832 times)

joemcl

  • I post occasionally
  • **
  • Posts: 72
  • Karma: 1
    • Citizen Action of New York
  • CiviCRM version: 4.4.13
  • CMS version: Drupal 7.34
  • MySQL version: 5.6
  • PHP version: Unsure
Contribution search in Search Builder - undefined variable, group save errors
May 19, 2014, 11:49:50 am
I ran this search on the Drupal demo site ( http://drupal.demo.civicrm.org/) in Search Builder:

Contribution Status = Pending ...AND...Receive Date IS NOT EMPTY

and got no results, not surprisingly, but also received this error message:

Notice: Undefined variable: quoteValue in CRM_Contribute_BAO_Query::whereClauseSingle() (line 607 of /home/webeditor/jenkins-node/workspace/buildkit-demos.civicrm.org/build/d7-demo/sites/all/modules/civicrm/CRM/Contribute/BAO/Query.php).

The search ran successfully on my production site (4.4.5), though if I add:

Contacts - Internal Contact ID Not Empty
to show the Internal Contact ID to appear as a column,the search crashes, and I get
DB Error: syntax error

I don't want to turn on debugging on my production site at the moment. I could save the results list as a Group, but received
DB Error
when trying to save as a New Smart Group.
 


bcobin

  • I post frequently
  • ***
  • Posts: 337
  • Karma: 9
    • InterCreative Media
  • CiviCRM version: 4.3.3
  • CMS version: Drupal 7.22
  • MySQL version: 5.5.9
  • PHP version: 5.3
Re: Contribution search in Search Builder - undefined variable, group save errors
July 10, 2014, 07:43:52 am
I'm seeing this error as well in using a smart group that automatically adds contributors to an email list. Commenting here so I can keep track of any updates... thanks!

CiviTeacher.com

  • I live on this forum
  • *****
  • Posts: 1282
  • Karma: 118
    • CiviTeacher
  • CiviCRM version: 3.4 - 4.5
  • CMS version: Drupal 6&7, Wordpress
  • MySQL version: 5.1 - 5.5
  • PHP version: 5.2 - 5.4
Re: Contribution search in Search Builder - undefined variable, group save errors
July 14, 2014, 12:58:06 pm
Thanks for the error report guys.  CiviCRM needs the help of people like you to improve.

I have placed a bug report on the Issue Tracker directly.  Please consider creating an account there and doing this next time for best responses from the development team. 
Try CiviTeacher: the online video tutorial CiviCRM learning library.

joemcl

  • I post occasionally
  • **
  • Posts: 72
  • Karma: 1
    • Citizen Action of New York
  • CiviCRM version: 4.4.13
  • CMS version: Drupal 7.34
  • MySQL version: 5.6
  • PHP version: Unsure
Re: Contribution search in Search Builder - undefined variable, group save errors
August 04, 2014, 05:54:34 pm
Thanks and sorry for the delayed reply, I've been neck deep in prepping for and getting through our big annual conference this past weekend. I see in the Issue Tracker that the bug has been fixed in 4.5, great news! Thanks so much.

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviContribute (Moderator: Donald Lobo) »
  • Contribution search in Search Builder - undefined variable, group save errors

This forum was archived on 2017-11-26.