Duplicates where one record has Deleted = 1 ?

**al3** · 2007-12-29, 10:59 PM

FreeBSD 6.x, Apache 2.x, PHP 5.x, MySQL 5.x, Sugar 5.0CE

I look through my Accounts table and I see I have a few pairs of records with the same name but different keys. One rec will have the "deleted" field set to 1, the other set to 0. There is one pair where they are both set to 1. What is that all about? Why two records? Is the database corrupt? Everything seems to work OK.

Thanks,
Al

**dpatech** · 2007-12-31, 08:19 AM

Sugar does not physically delete records from the database but instead flags the records as deleted by setting the deleted field to "1". So, yes, everything is working properly and your database is not corrupt. There is a job that you can schedule through the administrative interface to periodically "purge" these deleted records from your database.

**al3** · 2007-12-31, 03:21 PM

Originally Posted by dpatech

Sugar does not physically delete records from the database but instead flags the records as deleted by setting the deleted field to "1". So, yes, everything is working properly and your database is not corrupt. There is a job that you can schedule through the administrative interface to periodically "purge" these deleted records from your database.

OK, but why would there be TWO records... same name...one with delete set to 1 and another with 0. Looks like a record got added again since the keys are different?

Al