View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0006062 | OXID eShop (all versions) | 1.01. Products (product, categories, manufacturer, promotions etc.) | public | 2015-03-02 13:06 | 2016-05-16 15:18 |
| Reporter | Alpha-Sys | Assigned To | |||
| Priority | low | Severity | trivial | Reproducibility | always |
| Status | resolved | Resolution | fixed | ||
| Product Version | 4.9.3 / 5.2.3 | ||||
| Fixed in Version | 4.9.10 / 5.2.10 | ||||
| Summary | 0006062: SQL error if setting "Number of similar Products" is 0 => Shop offline | ||||
| Description | If the setting "Number of similar Products which are shown with a Product" is 0 and you open an article in the frontend which should have similar products, you will get the shop offline page. In the exception log you will find a mysql error. | ||||
| Steps To Reproduce | Go to the admin to "Master Settings" => "Core Settings" => "Settings" and set the setting "Number of similar Products which are shown with a Product" to 0. Then open for example the article detail page of the Kite NBK EVO 2010 (link in demoshop: http://demoshop.oxid-esales.com/community-edition/Kiteboarding/Kites/Kite-NBK-EVO-2010.html). You get the shop offline page. In the exception log you will find a mysql error. | ||||
| Tags | No tags attached. | ||||
| Theme | All | ||||
| Browser | All | ||||
| PHP Version | Not defined | ||||
| Database Version | Not defined | ||||
|
|
This could be resolved easily by adding a hint: If you want to disable loading similar articles use the option bl_perfLoadSimilar in the performance tab (Admin panel -> Master settings -> Core Settings -> Perform. -> " Load similar Products ". |
|
|
As martin pointed out above: it is very easy to workaround this bug, thus the low status and severity. Bug is indeed reproducible following the original steps mentioned by Alpha-Sys. |
|
|
Create a pull request with the bugfix: https://github.com/OXID-eSales/oxideshop_ce/pull/372 |
|
|
Thank you for the pull request. Merged to 5.2, 5.3 and Master. |
