AnsweredAssumed Answered

Deleting records results in a blank page and MySQL 1054 error

Question asked by PS PS on May 28, 2014
Latest reply on Jun 2, 2014 by Sumit Sahay
When ever i m deleting any record in sugarcrm, it gives me a blank page and the record is not deleted. I am trying to delete a case, and check the error log which shows...

Wed May 28 17:45:19 2014 [9694][87320c78-2997-3d67-b7c5-532a7b736003][FATAL]  
Query Failed: UPDATE cases_cstm SET court_high_name_c = ' '
WHERE id_c = b4f8789b-6ee8-28a3-8740-5385d270692f : MySQL error 1054:
Unknown column 'b4f8789b' in 'where clause'
the id value is should be in single quote but its missing that. How to solve this issue?

Outcomes