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 (Moderator: Dave Greenberg) »
  • Error with Seach Builder and Preferred Communication Method
Pages: [1]

Author Topic: Error with Seach Builder and Preferred Communication Method  (Read 812 times)

mcternan

  • I’m new here
  • *
  • Posts: 27
  • Karma: 0
  • CiviCRM version: 4.4.11
  • CMS version: Drupal 7.10
  • MySQL version: 5.1.58
  • PHP version: 5.3
Error with Seach Builder and Preferred Communication Method
January 17, 2012, 12:31:18 am
I've encountered a bug when creating a query and setting the Preferred Communication Method value to IS NULL or IS NOT NULL

Steps to reproduce
  • Select Search Builder
  • Under "include contacts where" set the fields to "Individual" "Preferred Communication Method" and "IS NULL"
  • Leave the text box empty
  • Perform the search


I have tested this on the demo site and on my own install and each time it returns a non-recoverable error.

The error message I have received is as follows:
Quote
Sorry. A non-recoverable error has occurred.
DB Error: syntax error
Error Details

Clicking on Error Details does not expand the error, if I view the source of the page I can see multiple messages reporting SQL syntax errors.

It seems another user reported a similar problem here before http://forum.civicrm.org/index.php/topic,13469.msg67370.html#msg67370 they seemed to solve it for emails, but it does not address searches for preferred communication method.

Using the previous posting as a starting point I was able to hack together a fix in my Query.php, I've posted the diff below.

Is anyone aware of this being a logged bug? And if so is there any plans to fix this issue in future releases?

Cheers,

Conor

(Could not post the code, it was somehow interpreted as an external link)

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: Error with Seach Builder and Preferred Communication Method
January 17, 2012, 09:02:22 am
Hi Conor - A few other fatal error bugs where fixed in Search Builder for 4.1, but I don't see an explicit mention of this one. Please retest on the 4.1 sandbox - and if it recreates, go ahead and post a bug report in the issue tracker with your fix attached as a patch (ideally against the trunk revision - because 4.1 is in code freeze).

http://book.civicrm.org/developer/introduction/fixing-bugs
Protect your investment in CiviCRM by  becoming a Member!

maya

  • I’m new here
  • *
  • Posts: 6
  • Karma: 0
  • CiviCRM version: lots!
  • CMS version: Drupal 6/7
  • MySQL version: varies
  • PHP version: varies
Re: Error with Seach Builder and Preferred Communication Method
December 13, 2013, 12:43:41 am
Hi,

Did you ever release a patch for this? Encountering the same issue now for one of our client, tested on sandbox 4.4 and still getting the error.

Thanks,
Maya

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Error with Seach Builder and Preferred Communication Method
December 13, 2013, 07:04:25 am

since this is still happening in 4.4, can u please file an issue.

If u'll can contribute a patch great. We'll try and take a quick look and hopefully get it fixed for 4.4.4

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

maya

  • I’m new here
  • *
  • Posts: 6
  • Karma: 0
  • CiviCRM version: lots!
  • CMS version: Drupal 6/7
  • MySQL version: varies
  • PHP version: varies
Re: Error with Seach Builder and Preferred Communication Method
December 19, 2013, 06:36:37 am
Have filed an issue for this at http://issues.civicrm.org/jira/browse/CRM-14010
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM (Moderator: Dave Greenberg) »
  • Error with Seach Builder and Preferred Communication Method

This forum was archived on 2017-11-26.