Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0053228 | Openbravo ERP | 02. Master data management | public | 2023-08-17 13:27 | 2023-09-08 14:57 |
|
| Reporter | Leyre | |
| Assigned To | AugustoMauch | |
| Priority | normal | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 5 | OS Version | |
| Product Version | | |
| Target Version | | Fixed in Version | PR23Q4 | |
| Merge Request Status | approved |
| Review Assigned To | |
| OBNetwork customer | OBPS |
| Web browser | |
| Modules | Core |
| Support ticket | 72487 |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0053228: Error when trying to delete a variant with a new column "image BLOB" in m_product table. |
| Description | Error when trying to delete a variant with a new column "image BLOB" in m_product table. |
| Steps To Reproduce | 1. Create a new column in the m_product table that references to an image:
ALTER TABLE public.m_product ADD COLUMN em_pit_sketch_image_id character varying(32);
ALTER TABLE public.m_product
ADD CONSTRAINT em_pit_prod_sketch_imag FOREIGN KEY (em_pit_sketch_image_id)
REFERENCES public.ad_image (ad_image_id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION;
2. As 'System Administrator':
2.1 In the m_product table, add the new column (using the "create columns form DB" button) and set Reference: Image BLOB.
2.2 In the "Product" window, add a new field -> Column: EM_Pit_Sketch_Image_ID and name: test.
3. As 'The White Valley Group Admin - The White Valley Group':
3.1 Configure a new generic product and add an image in the test section.
3.2 Add a Characteristic for this product.
4. Click on "Create Variants" button and confirm that there are new products-variants.
5. Try to delete one of the new product/variant created and confirm that it is not possible:
Error: This record cannot be deleted because it is associated with other existing elements. Please see Linked Items
Fix: See attached possible .diff |
| Proposed Solution | |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | |
| Attached Files |  fixEliminarVarianteConImagenes.diff (1,880) 2023-08-17 13:27
https://issues.openbravo.com/file_download.php?file_id=18876&type=bug |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2023-08-17 13:27 | Leyre | New Issue | |
| 2023-08-17 13:27 | Leyre | Assigned To | => Triage Omni OMS |
| 2023-08-17 13:27 | Leyre | File Added: fixEliminarVarianteConImagenes.diff | |
| 2023-08-17 13:27 | Leyre | OBNetwork customer | => OBPS |
| 2023-08-17 13:27 | Leyre | Modules | => Core |
| 2023-08-17 13:27 | Leyre | Support ticket | => 72487 |
| 2023-08-17 13:27 | Leyre | Triggers an Emergency Pack | => No |
| 2023-08-17 13:34 | Practics | Issue Monitored: Practics | |
| 2023-08-17 14:07 | aferraz | Assigned To | Triage Omni OMS => Triage Platform Base |
| 2023-09-05 17:28 | hgbot | Merge Request Status | => open |
| 2023-09-05 17:28 | hgbot | Note Added: 0154520 | |
| 2023-09-06 08:21 | AugustoMauch | Assigned To | Triage Platform Base => AugustoMauch |
| 2023-09-06 08:21 | AugustoMauch | Status | new => scheduled |
| 2023-09-07 15:21 | hgbot | Merge Request Status | open => approved |
| 2023-09-08 14:57 | hgbot | Note Added: 0154644 | |
| 2023-09-08 14:57 | hgbot | Resolution | open => fixed |
| 2023-09-08 14:57 | hgbot | Status | scheduled => closed |
| 2023-09-08 14:57 | hgbot | Fixed in Version | => PR23Q4 |
| 2023-09-08 14:57 | hgbot | Note Added: 0154645 | |