[Skip to main content](#vessel-content) # Bug in Hikashop 1.6 in breadcrumb.php ## - **[tefun](/forum/user/6343-tefun "View tefun's Profile")** - [![tefun's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6343.jpg)](/forum/user/6343-tefun "View tefun's Profile") Topic Author - [ Offline](/forum/user/6343-tefun) Less More - Posts: 148 - Thank you received: 4 - - - - [](http://tuzhilkin.kz) - 14 years 3 weeks ago [\#70854](#70854) by [tefun](/forum/user/6343-tefun "View tefun's Profile") *[Bug in Hikashop 1.6 in breadcrumb.php](/forum/3-bug-report/70854-bug-in-hikashop-1-6-in-breadcrumb-php#70854 "Hi, www.hikashop.com/en/forum/5-support-en-f...ied-for-foreach.html Can you explane me on English please My problem Warning: Invalid argument supplied for foreach() in Z:\home\abt\www\administrator\components\com_hikashop\types\breadcrumb.php on line 17 Warning: Invalid argument supplied for foreach() in Z:\home\abt\www\administrator\components\com_hikashop\types\breadcrumb.php on line 26 [image]Warning: Invalid argument supplied for foreach() in Z:\home\abt\www\administrator\components\com_hikashop\views\product\tmpl\category.php on line 46 [image]")* was created by *[tefun](/forum/user/6343-tefun "View tefun's Profile")* Hi, [ www.hikashop.com/en/forum/5-support-en-f...ied-for-foreach.html](http://www.hikashop.com/en/forum/5-support-en-francais-french-support-/68698-warning-invalid-argument-supplied-for-foreach.html) Can you explane me on English please My problem Warning: Invalid argument supplied for foreach() in Z:\home\abt\www\administrator\components\com_hikashop\types\breadcrumb.php on line 17 Warning: Invalid argument supplied for foreach() in Z:\home\abt\www\administrator\components\com_hikashop\types\breadcrumb.php on line 26 [ ![[IMG](http://SSmaker.ru/fc985d06.png) ](http://SSmaker.ru/)Warning: Invalid argument supplied for foreach() in Z:\home\abt\www\administrator\components\com_hikashop\views\product\tmpl\category.php on line 46 [ ![[IMG](http://SSmaker.ru/effbdfff.png) ](http://SSmaker.ru/) Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83MDg1NC1idWctaW4taGlrYXNob3AtMTYtaW4tYnJlYWRjcnVtYnBocD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86541 - Thank you received: 14304 - - 14 years 3 weeks ago [\#70893](#70893) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Bug in Hikashop 1.6 in breadcrumb.php](/forum/3-bug-report/70854-bug-in-hikashop-1-6-in-breadcrumb-php#70893 "Hi, www.hikashop.com/en/forum/5-support-en-f...ied-for-foreach.html Can you explane me on English please My problem Warning: Invalid argument supplied for foreach() in Z:\home\abt\www\administrator\components\com_hikashop\types\breadcrumb.php on line 17 Warning: Invalid argument supplied for foreach() in Z:\home\abt\www\administrator\components\com_hikashop\types\breadcrumb.php on line 26 [image]Warning: Invalid argument supplied for foreach() in Z:\home\abt\www\administrator\components\com_hikashop\views\product\tmpl\category.php on line 46 [image]")* Please try to change the line: $query = 'SELECT DISTINCT b.* FROM '.hikashop_table(end($this->tables)).' AS a LEFT JOIN '. hikashop_table(end($this->tables)).' AS b ON a.category_left >= b.category_left WHERE '. 'b.category_right >= a.category_right '.$and.$where.' ORDER BY b.category_left'; to: $query = 'SELECT b.* FROM '.hikashop_table(end($this->tables)).' AS a LEFT JOIN '. hikashop_table(end($this->tables)).' AS b ON a.category_left >= b.category_left WHERE '. 'b.category_right >= a.category_right '.$and.$where.' GROUP BY b.category_id ORDER BY b.category_left'; in the file administrator/components/com_hikashop/classes/category.php and that should solve the problem. The following user(s) said Thank You: [tefun](/forum/user/6343-tefun "View tefun's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83MDg1NC1idWctaW4taGlrYXNob3AtMTYtaW4tYnJlYWRjcnVtYnBocD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[tefun](/forum/user/6343-tefun "View tefun's Profile")** - [![tefun's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6343.jpg)](/forum/user/6343-tefun "View tefun's Profile") Topic Author - [ Offline](/forum/user/6343-tefun) Less More - Posts: 148 - Thank you received: 4 - - - - [](http://tuzhilkin.kz) - 14 years 3 weeks ago [\#71047](#71047) by [tefun](/forum/user/6343-tefun "View tefun's Profile") Replied by *[tefun](/forum/user/6343-tefun "View tefun's Profile")* on topic *[Re: Bug in Hikashop 1.6 in breadcrumb.php](/forum/3-bug-report/70854-bug-in-hikashop-1-6-in-breadcrumb-php#71047 "Hi, www.hikashop.com/en/forum/5-support-en-f...ied-for-foreach.html Can you explane me on English please My problem Warning: Invalid argument supplied for foreach() in Z:\home\abt\www\administrator\components\com_hikashop\types\breadcrumb.php on line 17 Warning: Invalid argument supplied for foreach() in Z:\home\abt\www\administrator\components\com_hikashop\types\breadcrumb.php on line 26 [image]Warning: Invalid argument supplied for foreach() in Z:\home\abt\www\administrator\components\com_hikashop\views\product\tmpl\category.php on line 46 [image]")* Thanks, it is help me) Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83MDg1NC1idWctaW4taGlrYXNob3AtMTYtaW4tYnJlYWRjcnVtYnBocD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[holylander](/forum/user/10831-holylander "View holylander's Profile")** - [![holylander's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/10831-holylander "View holylander's Profile") - [ Offline](/forum/user/10831-holylander) Less More - Posts: 1 - Thank you received: 0 - - 14 years 1 week ago [\#73789](#73789) by [holylander](/forum/user/10831-holylander "View holylander's Profile") Replied by *[holylander](/forum/user/10831-holylander "View holylander's Profile")* on topic *[Re: Bug in Hikashop 1.6 in breadcrumb.php](/forum/3-bug-report/70854-bug-in-hikashop-1-6-in-breadcrumb-php#73789 "Hi, www.hikashop.com/en/forum/5-support-en-f...ied-for-foreach.html Can you explane me on English please My problem Warning: Invalid argument supplied for foreach() in Z:\home\abt\www\administrator\components\com_hikashop\types\breadcrumb.php on line 17 Warning: Invalid argument supplied for foreach() in Z:\home\abt\www\administrator\components\com_hikashop\types\breadcrumb.php on line 26 [image]Warning: Invalid argument supplied for foreach() in Z:\home\abt\www\administrator\components\com_hikashop\views\product\tmpl\category.php on line 46 [image]")* Thank you very much for your help ! it worked like a charm Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83MDg1NC1idWctaW4taGlrYXNob3AtMTYtaW4tYnJlYWRjcnVtYnBocD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop Install & Update Product & Category Display Content Creation Sales and Orders Orders management Reports & Statistics Customers Checkout Payment Methods Shipping Methods Import & Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel & Slider Mass Actions Filters & Search Discount & Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.065 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)