Answers.Body: <p>There are two ways.
  First, you can enable debugging and backtrace under <strong>Administer menu » System Settings » Debugging and Error Handling</strong>.</p>
  
  <p>The same information should be available in your ConfigAndLog directory.  See <a href="https://civicrm.stackexchange.com/questions/15931/where-are-the-configandlog-and-templates-c-directories">Where are the &quot;ConfigAndLog&quot; and &quot;templates_c&quot; directories?</a></p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-05-07T18:14:37.953Z
Answers.LastActivityDate: 2017-05-07T18:14:37.953Z
Answers.UserDisplayName: Jon G - Megaphone Tech
Body: <p>I have created an event registration form, using a profile with a custom field. When I click <code>Continue</code> after filling in the form, I see <code>Processing ...</code> and then I get the confirmation screen, which looks good. But when I hit <code>Continue</code> I get:</p>
  
  <pre><code>Sorry but we are not able to provide this at the moment. DB Error: no such field Return to home page.
  </code></pre>
  
  <p>WordPress 4.7.4
  CiviCRM 4.7.17</p>
  
  <p>I'm filling in two of the input fields from URL variables.  Not sure if that might be a problem.</p>
  
  <p>If you want to try:</p>
  
  <p><a href="https://connectionpractice.org/test-webinar-with-affiliate-code/?affiliatecode=irthlingz1&amp;eventtype=Introduction" rel="nofollow noreferrer">https://connectionpractice.org/test-webinar-with-affiliate-code/?affiliatecode=irthlingz1&amp;eventtype=Introduction</a></p>
  
  <p>I'm thinking I need to get more debug info to figure out which field is causing the problem.  How can I do that?</p>
  
  <p>P.S. My code for the URL variables</p>
  
  <pre><code>&lt;script&gt;
  (function($) {
    // all JS code here
  var l = document.location;
    var affiliatecode = l.search.match(/affiliatecode=([a-zA-Z0-9_]+)/)[1];
  var eventtype = l.search.match(/eventtype=([a-zA-Z0-9_]+)/)[1];
     $( "input#custom_3").val(affiliatecode);
     $( "input#event_type").val(eventtype);
  })(jQuery);
  &lt;/script&gt;
  </code></pre>
  
Tags: <wordpress><error><database>
Title: How to get more debug info about "DB Error: no such field Return to home page"
ThreadText: # How to get more debug info about "DB Error: no such field Return to home page"
  
  (Asked by: username_0 on 2017-05-07)
  
  I have created an event registration form, using a profile with a custom field. When I click `Continue` after filling in the form, I see `Processing ...` and then I get the confirmation screen, which looks good. But when I hit `Continue` I get:
  
  ```
  Sorry but we are not able to provide this at the moment. DB Error: no such field Return to home page.
  
  ```
  
  WordPress 4.7.4
  CiviCRM 4.7.17
  
  I'm filling in two of the input fields from URL variables. Not sure if that might be a problem.
  
  If you want to try:
  
  <https://connectionpractice.org/test-webinar-with-affiliate-code/?affiliatecode=irthlingz1&eventtype=Introduction>
  
  I'm thinking I need to get more debug info to figure out which field is causing the problem. How can I do that?
  
  P.S. My code for the URL variables
  
  ```
  <script>
  (function($) {
    // all JS code here
  var l = document.location;
    var affiliatecode = l.search.match(/affiliatecode=([a-zA-Z0-9_]+)/)[1];
  var eventtype = l.search.match(/eventtype=([a-zA-Z0-9_]+)/)[1];
     $( "input#custom_3").val(affiliatecode);
     $( "input#event_type").val(eventtype);
  })(jQuery);
  </script>
  
  ```
  
  **Tags:** wordpress, error, database
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2017-05-07. Score: 2 | Accepted answer
  
  There are two ways.
  First, you can enable debugging and backtrace under **Administer menu » System Settings » Debugging and Error Handling**.
  
  The same information should be available in your ConfigAndLog directory. See [Where are the "ConfigAndLog" and "templates\_c" directories?](https://civicrm.stackexchange.com/questions/15931/where-are-the-configandlog-and-templates-c-directories)
  
  
  ---
  
  