View Issue Details

IDProjectCategoryView StatusLast Update
0006062OXID eShop (all versions)1.01. Products (product, categories, manufacturer, promotions etc.)public2016-05-16 15:18
ReporterAlpha-Sys Assigned To 
PrioritylowSeveritytrivialReproducibilityalways
Status resolvedResolutionfixed 
Product Version4.9.3 / 5.2.3 
Fixed in Version4.9.10 / 5.2.10 
Summary0006062: SQL error if setting "Number of similar Products" is 0 => Shop offline
DescriptionIf 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 ReproduceGo 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.
TagsNo tags attached.
ThemeAll
BrowserAll
PHP VersionNot defined
Database VersionNot defined

Activities

martinwegele

2015-03-02 14:33

reporter   ~0010734

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 ".

QA

2015-03-03 11:59

administrator   ~0010739

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.

Alpha-Sys

2016-05-02 22:22

reporter   ~0011566

Create a pull request with the bugfix: https://github.com/OXID-eSales/oxideshop_ce/pull/372

anton.fedurtsya

2016-05-16 15:18

administrator   ~0011586

Thank you for the pull request. Merged to 5.2, 5.3 and Master.