DB Error: no such field (Joomla - view contact)
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.