Answers.Body: <p>I just tried to replicate this problem on the demo site but couldn't.</p>
  
  <p>I would recommend upgrading to Civi 4.7.9, and if you still have the problem, you can do two things:</p>
  
  <ul>
  <li>Try to replicate it on the demo server (demo.civicrm.org).  If you can't, the issue is most likely in the configuration.</li>
  <li>The "DB Error" isn't really enough info to go on.  So you can go to <strong>Administer menu » System Settings » Debugging and Error Handling</strong>, 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!</li>
  </ul>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-07-18T22:31:53.123Z
Answers.Text: Thanks, I will follow your advice and upgrade next week. Thanks so much, Ian
Answers.UserDisplayName: Hock
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-07-18T05:13:43.307Z
Answers.LastActivityDate: 2016-07-18T05:13:43.307Z
Answers.UserDisplayName: Jon G - Megaphone Tech
Body: <p>Drupal 7.43 / CIVICRM 4.7.7</p>
  
  <p>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</p>
  
  <p>It doesn't seem to matter what operator I use, the result is the same.
  Please help. Ian</p>
  
Tags: <search-builder>
Title: Search Builder One of parameters is not of the type MysqlColumnName
ThreadText: # Search Builder One of parameters is not of the type MysqlColumnName
  
  (Asked by: username_0 on 2016-07-18)
  
  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
  
  **Tags:** search-builder
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2016-07-18. Score: 2 | Accepted answer
  
  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!
  
  > **Comments:**
  > **username_0**: Thanks, I will follow your advice and upgrade next week. Thanks so much, Ian  
  
  ---
  
  