Deleting records from sugar does not remove from table

[bstonehill]

I needed the ability to add many identical records in one operation, so I created a popup that prompts the user to select an item as a template and a quantity and then adds that many records based on the template. The popup also creates a relationship between each of these records and an account that the user selected in the popup.

I'm generating the record id's with an md5 hash of the microtime, an incremental value of i, and the data in the fields. Everything shows up and is editable as desired, relationships work as they should, but when I delete one of these records through sugar it permanently removes them from sugar but not from the table. None of the record's fields appear to be modified in anyway. Is there something else I need to do when creating the records to maintain integrity here?

Oh, in case this matters, these are records for a custom module built through module builder 5.1rc.

Please help, this is pretty much my last hurdle to get it into production.

WinXP Pro
SugarCRM 5.1RC
Apache 2.0.59
PHP 5.2.1.1
MySQL 5.0.24?

**EDIT**
Even though my hashes are the same length as the ones sugar does, they are not hyphenated like sugar's are. Could this have anything to do with it? I would think there would be other problems if that were the case.

[mikesolomon]

I needed the ability to add many identical records in one operation, so I created a popup that prompts the user to select an item as a template and a quantity and then adds that many records based on the template. The popup also creates a relationship between each of these records and an account that the user selected in the popup.

I'm generating the record id's with an md5 hash of the microtime, an incremental value of i, and the data in the fields. Everything shows up and is editable as desired, relationships work as they should, but when I delete one of these records through sugar it permanently removes them from sugar but not from the table. None of the record's fields appear to be modified in anyway. Is there something else I need to do when creating the records to maintain integrity here?

Oh, in case this matters, these are records for a custom module built through module builder 5.1rc.

Please help, this is pretty much my last hurdle to get it into production.

WinXP Pro
SugarCRM 5.1RC
Apache 2.0.59
PHP 5.2.1.1
MySQL 5.0.24?

**EDIT**
Even though my hashes are the same length as the ones sugar does, they are not hyphenated like sugar's are. Could this have anything to do with it? I would think there would be other problems if that were the case.

When u delete an item in sugar it does not remove it from the table - just sets deleted to 1

[bstonehill]

When u delete an item in sugar it does not remove it from the table - just sets deleted to 1

Aha! You are right! Thank you! I never really paid attention to that before, I was just afraid I was setting myself up for major problems down the road.