Openbravo Issue Tracking System - Retail Modules | ||||||||||||
| View Issue Details | ||||||||||||
| ID | Project | Category | View Status | Date Submitted | Last Update | |||||||
| 0041899 | Retail Modules | Web POS | public | 2019-09-30 10:10 | 2020-10-28 17:00 | |||||||
| Reporter | joniturralde93 | |||||||||||
| Assigned To | Retail | |||||||||||
| Priority | high | Severity | minor | Reproducibility | always | |||||||
| Status | closed | Resolution | duplicate | |||||||||
| Platform | OS | 5 | OS Version | |||||||||
| Product Version | ||||||||||||
| Target Version | Fixed in Version | RR20Q4 | ||||||||||
| Merge Request Status | ||||||||||||
| Review Assigned To | marvintm | |||||||||||
| OBNetwork customer | ||||||||||||
| Support ticket | ||||||||||||
| Regression level | ||||||||||||
| Regression date | ||||||||||||
| Regression introduced in release | ||||||||||||
| Regression introduced by commit | ||||||||||||
| Triggers an Emergency Pack | No | |||||||||||
| Summary | 0041899: It is possible to have a summary product category with products | |||||||||||
| Description | Right now, if you have a product category with "Summary level" included in an assortment, this category is loaded in two different queries for category tree model, so following error is thrown: OB.Dal.insertData: model insert 'ProductCategoryTree'; SQLError: code: 6, message: could not execute statement due to a constraint failure (19 UNIQUE constraint failed: m_product_category_tree.id); This is caused because the first query is suposed to retrieve categories with product (with no summary level), and the second one retrieves the summary level categories, but in this case both queries return that category. | |||||||||||
| Steps To Reproduce | 1. Log into https://livebuilds.openbravo.com/retail_pi_pgsql/ [^] 2. Go to Product Category window, to "Lighting & Electronics" 3. Check Summary Level 4. Do a login in POS 5. Master Data Loading Error (in console there is the error previously mentioned) | |||||||||||
| Proposed Solution | 1. Not allowing to assign a summary level category to a product. 2. Not allowing to check a category with products as summary level. | |||||||||||
| Additional Information | ||||||||||||
| Tags | No tags attached. | |||||||||||
| Relationships |
| |||||||||||
| Attached Files | ||||||||||||
| Issue History | ||||||||||||
| Date Modified | Username | Field | Change | |||||||||
| 2019-09-30 10:10 | joniturralde93 | New Issue | ||||||||||
| 2019-09-30 10:10 | joniturralde93 | Assigned To | => Retail | |||||||||
| 2019-09-30 10:10 | joniturralde93 | Triggers an Emergency Pack | => No | |||||||||
| 2019-09-30 11:18 | Practics | Issue Monitored: Practics | ||||||||||
| 2020-10-28 16:24 | egoitz | Resolution time | => 1605222000 | |||||||||
| 2020-10-28 16:24 | egoitz | Type | feature request => defect | |||||||||
| 2020-10-28 17:00 | marvintm | Review Assigned To | => marvintm | |||||||||
| 2020-10-28 17:00 | marvintm | Relationship added | duplicate of 0044515 | |||||||||
| 2020-10-28 17:00 | marvintm | Status | new => closed | |||||||||
| 2020-10-28 17:00 | marvintm | Resolution | open => duplicate | |||||||||
| 2020-10-28 17:00 | marvintm | Fixed in Version | => RR20Q4 | |||||||||
| There are no notes attached to this issue. |