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|
|Product Version||4.9.3 / 5.2.3|
|Target Version||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.|
|PHP Version||Not defined|
|MySQL 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.|