Answers.Body: <p>Try installing the CiviCRM Log Viewer extension (you can do that via the web interface) and then you'll be able to see more details about the specifics of the error, which are logged in a CiviCRM error log file that is otherwise not easy to access.</p>
  <p>The 'Transaction integrity error' isn't super useful, it's evidence of a deeper issue - see:
  <a href="https://civicrm.stackexchange.com/search?q=Transaction+integrity+error%3A+Expected+to+find+active+frame">https://civicrm.stackexchange.com/search?q=Transaction+integrity+error%3A+Expected+to+find+active+frame</a></p>
  <p>That deeper issue would be more easily seen via the error log.</p>
  <p>Sometimes, if you make changes to custom fields via the web interface, it will only half-complete, leaving a mismatch between the tables in mysql and what CiviCRM thinks is there. That might be evidence of a server setup issue, for example.</p>
  <p>The easiest solution, if it works, is to delete the fields that make up the custom fieldset, then delete the fieldset itself and start again.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-12-02T16:16:22.340Z
Answers.LastActivityDate: 2020-12-02T16:16:22.340Z
Answers.UserDisplayName: Alan Dixon
Body: <p>We're just a very small charity trying to put this together with limited experience.</p>
  <p>I had set up some custom fields for the database but some changes to those fields was requested which I made and now when I run a find contact search, a list of releveant contacts will come up but if I click on a contact name I get this message:</p>
  <p>Sorry, due to an error, we are unable to fulfill your request at the moment. You may want to contact your administrator or service provider with more details about what action you were performing when this occurred.
  DB Error: no such field</p>
  <p>I imagine it has something to do with changing the fields. Any ideas of how to move forward with this?  I only had uploaded some of our database as a test so happy to delete all of our contacts and start again but don't know how.</p>
  <p>Thanks in advance!!</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-12-01T10:20:07.233Z
Comments.Text: Sounds like the fields have caused the issue. First thing to check is if you changed the search results profiles to include those fields. If you did then that would probably explain why you're seeing the message. If not then pasting in the content of the CiviCRM Log file for the error will help point to which field is causing the issue.
Comments.UserDisplayName: Parvez Saleh
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-12-01T18:20:32.493Z
Comments.Text: might help if you give an example of a change you made to one of the fields
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-12-01T23:07:58.197Z
Comments.Text: @petednz-fuzion thanks for the prompt, for example I have changed the field set a field is in although theis can be done using the move function so I figured that shouldn't cause an issue.
Comments.UserDisplayName: Clair
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-12-01T23:10:04.873Z
Comments.Text: @petednz-fuzion I also made changes such as changing the options in a multiple choice custom field and chaning the name of custom fields. Thks.
Comments.UserDisplayName: Clair
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-12-01T23:40:39.510Z
Comments.Text: UPDATE tried to add a new contact and got the same 'DB error:no such field' with this line beneath 'Fatal error: Uncaught CRM_Core_Exception: [0: Transaction integrity error: Expected to find active frame thrown in /home/adhdrich/www/www/wp-content/plugins/civicrm/civicrm/Civi/Core/Transaction/Manager.php on line 93'
Comments.UserDisplayName: Clair
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-12-02T18:33:17.047Z
Comments.Text: did you make changes to fields via UI or in DB?
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-12-02T18:34:09.197Z
Comments.Text: if the latter i would probably consider "happy to delete all of our contacts and start again" and next time make changes via UI or make backups so you can roll back if you make via DB
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-01-03T04:36:33.783Z
Comments.Text: I wanted to add to this I am running into the same issue. It seems to have begun when upgrading to 5.3.2 on a Joomla install. I am also prevented from adding contributions to current contacts. Interestingly enough, when a user registers on our site or makes a donation, it is successful but I am unable add contacts on the admin side.
  
  I too suspected custom fields and have disabled all of them with the same result.
  
  I don’t want to step on the OP’s issue so I won’t post logs here yet, but wanted to add the additional for this issue.
Comments.UserDisplayName: Taylor Pyles
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-02-06T23:06:20.387Z
Comments.Text: Resolved...we think the error was the length of the custom fields names for which there is apparently a character limit. Seemed to solve our problem. Thanks for all your advice!
Comments.UserDisplayName: Clair
Tags: <contacts><error><database>
Title: DB: No such field! Error message
ThreadText: # DB: No such field! Error message
  
  (Asked by: username_0 on 2020-12-01)
  
  We're just a very small charity trying to put this together with limited experience.
  
  I had set up some custom fields for the database but some changes to those fields was requested which I made and now when I run a find contact search, a list of releveant contacts will come up but if I click on a contact name I get this message:
  
  Sorry, due to an error, we are unable to fulfill your request at the moment. You may want to contact your administrator or service provider with more details about what action you were performing when this occurred.
  DB Error: no such field
  
  I imagine it has something to do with changing the fields. Any ideas of how to move forward with this? I only had uploaded some of our database as a test so happy to delete all of our contacts and start again but don't know how.
  
  Thanks in advance!!
  
  **Tags:** contacts, error, database
  
  > **Comments:**
  > **username_1**: Sounds like the fields have caused the issue. First thing to check is if you changed the search results profiles to include those fields. If you did then that would probably explain why you're seeing the message. If not then pasting in the content of the CiviCRM Log file for the error will help point to which field is causing the issue.  
  > **username_2**: might help if you give an example of a change you made to one of the fields  
  > **username_0**: @username_2 thanks for the prompt, for example I have changed the field set a field is in although theis can be done using the move function so I figured that shouldn't cause an issue.  
  > **username_0**: @username_2 I also made changes such as changing the options in a multiple choice custom field and chaning the name of custom fields. Thks.  
  > **username_0**: UPDATE tried to add a new contact and got the same 'DB error:no such field' with this line beneath 'Fatal error: Uncaught CRM_Core_Exception: [0: Transaction integrity error: Expected to find active frame thrown in /home/adhdrich/www/www/wp-content/plugins/civicrm/civicrm/Civi/Core/Transaction/Manager.php on line 93'  
  > **username_2**: did you make changes to fields via UI or in DB?  
  > **username_2**: if the latter i would probably consider "happy to delete all of our contacts and start again" and next time make changes via UI or make backups so you can roll back if you make via DB  
  > **username_3**: I wanted to add to this I am running into the same issue. It seems to have begun when upgrading to 5.3.2 on a Joomla install. I am also prevented from adding contributions to current contacts. Interestingly enough, when a user registers on our site or makes a donation, it is successful but I am unable add contacts on the admin side.  I too suspected custom fields and have disabled all of them with the same result.  I don’t want to step on the OP’s issue so I won’t post logs here yet, but wanted to add the additional for this issue.  
  > **username_0**: Resolved...we think the error was the length of the custom fields names for which there is apparently a character limit. Seemed to solve our problem. Thanks for all your advice!  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_4 on 2020-12-02. Score: 1
  
  Try installing the CiviCRM Log Viewer extension (you can do that via the web interface) and then you'll be able to see more details about the specifics of the error, which are logged in a CiviCRM error log file that is otherwise not easy to access.
  
  The 'Transaction integrity error' isn't super useful, it's evidence of a deeper issue - see:
  <https://civicrm.stackexchange.com/search?q=Transaction+integrity+error%3A+Expected+to+find+active+frame>
  
  That deeper issue would be more easily seen via the error log.
  
  Sometimes, if you make changes to custom fields via the web interface, it will only half-complete, leaving a mismatch between the tables in mysql and what CiviCRM thinks is there. That might be evidence of a server setup issue, for example.
  
  The easiest solution, if it works, is to delete the fields that make up the custom fieldset, then delete the fieldset itself and start again.
  
  
  ---
  
  