| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0005856 | OXID eShop (all versions) | 2.4. Administer products | public | 2014-08-21 02:55 | 2023-12-06 14:19 |
| Reporter | stephen | Assigned To | |||
| Priority | normal | Severity | tweak | Reproducibility | random |
| Status | confirmed | Resolution | open | ||
| Platform | All | OS | All | OS Version | All |
| Product Version | 4.8.7 / 5.1.7 | ||||
| Summary | 0005856: Incorrect sort order of reviews | ||||
| Description | Article reviews in eShop backend are not ordered by creation time. See screenshot. The problem will only occur, if the database table oxreviews is defined as InnoDB. Not for MyIsam. The problem comes from the following file: application/controllers/admin/article_review.php There is a method named: _getReviewList In that method there isn't an "order by" statement defined. Proposed solution: Find: $sSelect .= "and oxreviews.oxtext != '' "; Add after: $sSelect .= "order by oxreviews.oxcreate"; | ||||
| Steps To Reproduce | - Use a database in which the storage engine of the table oxreviews is defined as InnoDB. - Write some reviews for a certain article - Enter eShop backend - Select the article - Click on the tab "Reviews" | ||||
| Tags | Reviews, Specialized Management Apps | ||||
| Theme | Azure | ||||
| Browser | All | ||||
| PHP Version | Not defined | ||||
| Database Version | Not defined | ||||
- Anonymous
