Answers.Body: <p>This might be the same problem as <a href="https://lab.civicrm.org/dev/core/-/issues/3113" rel="nofollow noreferrer">https://lab.civicrm.org/dev/core/-/issues/3113</a></p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-04-14T10:51:54.450Z
Answers.LastActivityDate: 2022-04-14T10:51:54.450Z
Answers.UserDisplayName: Demerit
Body: <p>I am searching <strong>Contributions</strong> by <strong>Contribution Note</strong> with <strong>Search Builder</strong>.</p>
  <hr />
  <h2>When no matches are found, it properly says so.</h2>
  <p><a href="https://i.sstatic.net/jwI59.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/jwI59.png" alt="enter image description here" /></a></p>
  <h2>However, when the search matches result, there is &quot;DB Error: No such field&quot;</h2>
  <p><a href="https://i.sstatic.net/ed2fJ.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/ed2fJ.png" alt="enter image description here" /></a></p>
  <p><a href="https://i.sstatic.net/vLCJl.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/vLCJl.png" alt="enter image description here" /></a></p>
  <h1>How do I troubleshoot / fix this?</h1>
  
Tags: <search-results><search-builder>
Title: How do I troubleshoot/fix search error (when search is successful)?
ThreadText: # How do I troubleshoot/fix search error (when search is successful)?
  
  (Asked by: username_0 on 2022-04-14)
  
  I am searching **Contributions** by **Contribution Note** with **Search Builder**.
  
  ---
  
  ## When no matches are found, it properly says so.
  
  [![enter image description here](https://i.sstatic.net/jwI59.png)](https://i.sstatic.net/jwI59.png)
  
  ## However, when the search matches result, there is "DB Error: No such field"
  
  [![enter image description here](https://i.sstatic.net/ed2fJ.png)](https://i.sstatic.net/ed2fJ.png)
  
  [![enter image description here](https://i.sstatic.net/vLCJl.png)](https://i.sstatic.net/vLCJl.png)
  
  # How do I troubleshoot / fix this?
  
  **Tags:** search-results, search-builder
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2022-04-14. Score: 0
  
  This might be the same problem as <https://lab.civicrm.org/dev/core/-/issues/3113>
  
  
  ---
  
  