AnsweredAssumed Answered

Find Duplicates - Database Query failed

Question asked by DavidL DavidL on Apr 13, 2015
Latest reply on Jan 3, 2017 by Ishani Lad
I want to find duplicates in the accounts module and merge it but the query for the notes created by sugar failed because of setting NULL to a "missing field":

SOME UPDATE QUERY ...,description=NULL,=NULL WHERE  notes.id = 'SOME ID' AND deleted=0



Has anybody a hint for me how to delete this field? I've tried a quick repair and rebuild but it doesn't work.

Outcomes