OSCommerce Product Manager for Windows
FS#190 - Deleting productt does not delete the product descriptions records.
Attached to Project:
OSCommerce Product Manager
Opened by Mario A. Valdez-Ramirez (mvaldez) - Monday, 11 April 2005, 13:00 GMT
Last edited by Mario A. Valdez-Ramirez (mvaldez) - Sunday, 15 July 2007, 06:33 GMT
Opened by Mario A. Valdez-Ramirez (mvaldez) - Monday, 11 April 2005, 13:00 GMT
Last edited by Mario A. Valdez-Ramirez (mvaldez) - Sunday, 15 July 2007, 06:33 GMT
|
DetailsWhen deleting a product, only the record in the products database is deleted. The records in all other prdouct-related tables are left intact.
Expected behavior: All data related to a given product should be deleted when the main record of the product is deleted. OSCommerce seems unaffected by the orphan records. |
This task depends upon
Very sloppy programming. It seems we are not deleting even those records we add when creating a product: description, special price and cat-to-prod relation.
Fixing it.
Fixed by deleting what we create. However, unsupported tables (even standard tables of OSCommerce) are not modified.
Closing.
Reopening.
After reviewing the deletion procedure followed by OSCommerce, we have decided to implemente the following cleaning steps (besides those already taken):
Delete from table products_attributes.
Delete from table customer_basket.
Delete from table customer_basket_attributes.
Delete from table reviews.
Delete from table reviews_description.
We are deferring because OSCPMWin currently does not know anything about those tables. We need to include the references and handling code (including configuration).
So, Deferred.