Answers.Body: <p>Problem Solved!
  I had a broken custom profile with broken custom fields.
  I was not even able to delte those fields and that profile from the backend.
  Had to go into the Database and delete the entire table which is related to that profile.</p>
  
  <p>That fixed the problem.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-12-24T00:23:35.023Z
Answers.LastActivityDate: 2016-12-24T00:23:35.023Z
Answers.UserDisplayName: Marc
Body: <p>please I need help. When I go into the backend to see the details of a contact, I get the following error:</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>I cant find any error logs, nothing is displayed on the debug, I just dont know where to else look for an issue.</p>
  
  <ul>
  <li>I also upgraded to the latest version 4.7.14 </li>
  <li>I ran the database upgrade successfully </li>
  <li>I downloaded a sql file of the entire database
  and compared it with a fresh new installation - no difference on the
  structure</li>
  </ul>
  
  <p>Please, what else can I check?</p>
  
  <p>Thank you in advance</p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-12-17T14:00:55.740Z
Comments.Text: You could check two further things:
  - the ACL settings for your login (i.e your usergroup);
  - the assets table, most use the (paid) component ACL manager for this.
Comments.UserDisplayName: Paul Kleingeld
Tags: <contacts><joomla>
Title: DB Error: no such field (Joomla - view contact)
ThreadText: # DB Error: no such field (Joomla - view contact)
  
  (Asked by: username_0 on 2016-12-16)
  
  please I need help. When I go into the backend to see the details of a contact, I get the following error:
  
  ```
  Sorry but we are not able to provide this at the moment.
  DB Error: no such field
  
  Return to home page.
  
  ```
  
  I cant find any error logs, nothing is displayed on the debug, I just dont know where to else look for an issue.
  
  * I also upgraded to the latest version 4.7.14
  * I ran the database upgrade successfully
  * I downloaded a sql file of the entire database
    and compared it with a fresh new installation - no difference on the
    structure
  
  Please, what else can I check?
  
  Thank you in advance
  
  **Tags:** contacts, joomla
  
  > **Comments:**
  > **username_1**: You could check two further things: - the ACL settings for your login (i.e your usergroup); - the assets table, most use the (paid) component ACL manager for this.  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_0 on 2016-12-24. Score: 0 | Accepted answer
  
  Problem Solved!
  I had a broken custom profile with broken custom fields.
  I was not even able to delte those fields and that profile from the backend.
  Had to go into the Database and delete the entire table which is related to that profile.
  
  That fixed the problem.
  
  
  ---
  
  