So I just updated CiviCRM to 5.0 and I keep getting the error DB Error: no such field when I try and view/edit a contact. It doesn't allow me to view any contact but I can search and find my contacts. I am not sure what is going on but this happened even before I upgraded Civi and it was 4.7.

  • Can you look at or post the relevant part from the CiviCRM log that says which field this is talking about (file location described here civicrm.stackexchange.com/questions/15931/…)? – Demerit Apr 13 '18 at 19:45
  • Apr 10 20:25:19 [info] $Fatal Error Details = Array ( [callback] => Array ( [0] => CRM_Core_Error [1] => exceptionHandler ) [code] => -19 [message] => DB Error: no such field [mode] => 16 Here is an instance where it happened. – DerpyBirds Apr 13 '18 at 20:05
  • Any extensions being used? – petednz - fuzion Apr 13 '18 at 20:22
  • Caldera Forms CiviCRM is the only one Ive used in the past week that resulted in this error. – DerpyBirds Apr 13 '18 at 20:25
  • Is there more in the log, where it shows the actual SQL statement that would indicate the field name? – Demerit Apr 13 '18 at 20:30

I found out that it was a bad custom field in my data set, when I disabled the set I can view my contacts. Thank you everyone who helped me with this.

  • Cant accept my answer apparently so sorry if it is unresolved still. – DerpyBirds Apr 13 '18 at 22:04
  • Your answer is just as unhelpful as the question. How did you disable the data set with bad custom field? – Onlyjob May 23 '19 at 11:12

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.