View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0006366 | OXID eShop (all versions) | 4.01. Database handling | public | 2016-04-06 11:09 | 2024-03-20 15:22 |
| Reporter | smxsm | Assigned To | |||
| Priority | low | Severity | major | Reproducibility | always |
| Status | confirmed | Resolution | open | ||
| Product Version | 4.9.5 / 5.2.5 | ||||
| Summary | 0006366: oxarticle::unassignFromShop() always tries to clean complete oxfield2shop table | ||||
| Description | oxarticle::unassignFromShop() always calls foreach ($aShopIds as $sShopId) { $oField2Shop->cleanMultishopFields($sShopId); } without specifying a product id, so for *every* article unassignment all oxarticles and oxfield2shop are joined and searched for "orphans". This is very, very, very ineffective with lots of subshops, articles and oxfield2shop values. It should really be called with the article id, e.g. foreach ($aShopIds as $sShopId) { $oField2Shop->cleanMultishopFields($sShopId, $this->getId()); } | ||||
| Tags | EE | ||||
| Theme | Not defined | ||||
| Browser | Not defined | ||||
| PHP Version | 5.4 | ||||
| Database Version | 5.5 | ||||
