View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0001285 | OXID eShop (all versions) | 3.1. Design, GUI, UX | public | 2009-09-03 15:25 | 2009-09-30 10:33 |
| Reporter | dainius.bigelis | Assigned To | |||
| Priority | low | Severity | minor | Reproducibility | always |
| Status | resolved | Resolution | no change required | ||
| Product Version | 4.1.6 revision 22740 | ||||
| Summary | 0001285: Two similar querries are used in getActiveSnippet | ||||
| Description | Noticed that oxArticle::getActiveSnippet() uses 2 subqueries (!). Please check is it really necesarry to do that way (maybe these are duplicated). | ||||
| Additional Information | Entry moved from comments in the bug 0000626. | ||||
| Tags | No tags attached. | ||||
| Theme | |||||
| Browser | All | ||||
| PHP Version | 5.2.6 | ||||
| Database Version | 5.0.33 | ||||
|
|
oxArticle::getActiveSnippet() function was changed to oxArticle::getSqlActiveSnippet(). In this function both subqueries will be used: 1) first subquery is used to check if article has any active variants. With bug 0000932 some improvement were made: run this subquery only if varcount is not 0. 2) second subquery is used to check if this article has any rights. |
