Answers.Body: <p>Based on the error in the debug message, the problem field is this one: <code>civicrm_value_developing_an_accredited_course_5.provide_instructions_on_any_furt_119</code></p>
  
  <p>I can't find it now, but there was a bug report recently that discussed problems with very long custom field names.  Please find your custom field with an ID of 119 and see if the form works when it's removed (or at least see if the MySQL error changes).  Consider recreating those fields with shorter names - you can always display them with the longer "names" in the profile's field label.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-01-11T07:28:20.603Z
Answers.LastActivityDate: 2017-01-11T07:28:20.603Z
Answers.UserDisplayName: Jon G - Megaphone Tech
Body: <p>I have created profile forms, using custom fields, which open up perfectly in create mode but when I test the forms I get this error once I hit save:</p>
  
  <blockquote>
    <p>Sorry but we are not able to provide this at the moment. DB Error: no
    such field Return to home page.</p>
  </blockquote>
  
  <p>Any ideas of how to solve this?</p>
  
  <p>Here is a link to one of the forms in question: <a href="http://skillsguru.web.za/civicrm/?page=CiviCRM&amp;q=civicrm/profile/create&amp;gid=21&amp;reset=1" rel="nofollow noreferrer">http://skillsguru.web.za/civicrm/?page=CiviCRM&amp;q=civicrm/profile/create&amp;gid=21&amp;reset=1</a> </p>
  
  <p>The detailed debugging report is <a href="http://skillsguru.web.za/blog/2017/01/11/debug/" rel="nofollow noreferrer">here</a>.</p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2017-01-10T20:31:03.197Z
Comments.Text: may be easier to help you if you can add a quick example on one of the demo sites.
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2017-01-10T20:32:43.953Z
Comments.Text: note that Demo sites get rebuilt every 24 hours - hopefully your efforts will last long enough for someone to take a look before it gets wiped
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2017-01-11T18:41:49.673Z
Comments.Text: It would also be helpful if you could edit your question to include the version of CiviCRM and the CMS you are using (e.g. WordPress, Drupal or Joomla).
Comments.UserDisplayName: William Mortada
Tags: <profile><error>
Title: Sorry but we are not able to provide this at the moment. DB Error: no such field Return to home page
ThreadText: # Sorry but we are not able to provide this at the moment. DB Error: no such field Return to home page
  
  (Asked by: username_0 on 2017-01-10)
  
  I have created profile forms, using custom fields, which open up perfectly in create mode but when I test the forms I get this error once I hit save:
  
  > Sorry but we are not able to provide this at the moment. DB Error: no
  > such field Return to home page.
  
  Any ideas of how to solve this?
  
  Here is a link to one of the forms in question: <http://skillsguru.web.za/civicrm/?page=CiviCRM&q=civicrm/profile/create&gid=21&reset=1>
  
  The detailed debugging report is [here](http://skillsguru.web.za/blog/2017/01/11/debug/).
  
  **Tags:** profile, error
  
  > **Comments:**
  > **username_1**: may be easier to help you if you can add a quick example on one of the demo sites.  
  > **username_1**: note that Demo sites get rebuilt every 24 hours - hopefully your efforts will last long enough for someone to take a look before it gets wiped  
  > **username_2**: It would also be helpful if you could edit your question to include the version of CiviCRM and the CMS you are using (e.g. WordPress, Drupal or Joomla).  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_3 on 2017-01-11. Score: 1
  
  Based on the error in the debug message, the problem field is this one: `civicrm_value_developing_an_accredited_course_5.provide_instructions_on_any_furt_119`
  
  I can't find it now, but there was a bug report recently that discussed problems with very long custom field names. Please find your custom field with an ID of 119 and see if the form works when it's removed (or at least see if the MySQL error changes). Consider recreating those fields with shorter names - you can always display them with the longer "names" in the profile's field label.
  
  
  ---
  
  