Drupal 7.43 / CIVICRM 4.7.7

I am trying to find contacts with no emails (any type eg/ Home, Other) using Search Builder. Using either IS EMPTY or IS NULL, I end up with no result but get a DB error. Viz: Sorry but we are not able to provide this at the moment. One of parameters (value: Home-email) is not of the type MysqlColumnName

It doesn't seem to matter what operator I use, the result is the same. Please help. Ian

1 Answer 1


I just tried to replicate this problem on the demo site but couldn't.

I would recommend upgrading to Civi 4.7.9, and if you still have the problem, you can do two things:

  • Try to replicate it on the demo server (demo.civicrm.org). If you can't, the issue is most likely in the configuration.
  • The "DB Error" isn't really enough info to go on. So you can go to Administer menu » System Settings » Debugging and Error Handling, and set "Debug mode" and "backtrace" to "yes". That will give you a much more detailed error. Updating your question with that info will let folks provide much more detailed information!
  • Thanks, I will follow your advice and upgrade next week. Thanks so much, Ian
    – Hock
    Commented Jul 18, 2016 at 22:31

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.