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
    Commented Apr 13, 2018 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
    Commented Apr 13, 2018 at 20:05
  • Any extensions being used?
    – petednz - fuzion
    Commented Apr 13, 2018 at 20:22
  • Caldera Forms CiviCRM is the only one Ive used in the past week that resulted in this error.
    – DerpyBirds
    Commented Apr 13, 2018 at 20:25
  • Is there more in the log, where it shows the actual SQL statement that would indicate the field name?
    – Demerit
    Commented Apr 13, 2018 at 20:30

1 Answer 1


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
    Commented Apr 13, 2018 at 22:04
  • Your answer is just as unhelpful as the question. How did you disable the data set with bad custom field?
    – Onlyjob
    Commented May 23, 2019 at 11:12

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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