[Skip to main content](#vessel-content) # Back end categories explorer ## - **[gili](/forum/user/6876-gili "View gili's Profile")** - [![gili's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6876-gili "View gili's Profile") Topic Author - [ Offline](/forum/user/6876-gili) Less More - Posts: 51 - Thank you received: 0 - - 13 years 7 months ago [\#95368](#95368) by [gili](/forum/user/6876-gili "View gili's Profile") *[Back end categories explorer](/forum/2-general-talk-about-hikashop/79456-back-end-categories-explorer#95368 "hello when i activate Back end categories explorer and go to see the products the page goes blank .. and i have a report of memory error when i deactivate it everything is fine i have more than 240000 products in the db thank you")* was created by *[gili](/forum/user/6876-gili "View gili's Profile")* hello when i activate Back end categories explorer and go to see the products the page goes blank .. and i have a report of memory error when i deactivate it everything is fine i have more than 240000 products in the db thank you Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzc5NDU2LWJhY2stZW5kLWNhdGVnb3JpZXMtZXhwbG9yZXI/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[Xavier](/forum/user/4105-xavier "View Xavier's Profile")** - [![Xavier's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar4105.png)](/forum/user/4105-xavier "View Xavier's Profile") - [ Offline](/forum/user/4105-xavier) Less More - Posts: 13201 - Thank you received: 2322 - - - - [](http://www.kidiweb.fr) - 13 years 7 months ago [\#95418](#95418) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[Back end categories explorer](/forum/2-general-talk-about-hikashop/79456-back-end-categories-explorer#95418 "hello when i activate Back end categories explorer and go to see the products the page goes blank .. and i have a report of memory error when i deactivate it everything is fine i have more than 240000 products in the db thank you")* Hi, Have you imported products and categories via a csv file ? If it is, maybe it was not correctly formatted and that's why the error appear. Have you enabled the Joomla debug mode, set the error reporting to maximum ? An error is returned ? The following user(s) said Thank You: [gili](/forum/user/6876-gili "View gili's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzc5NDU2LWJhY2stZW5kLWNhdGVnb3JpZXMtZXhwbG9yZXI/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[gili](/forum/user/6876-gili "View gili's Profile")** - [![gili's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6876-gili "View gili's Profile") Topic Author - [ Offline](/forum/user/6876-gili) Less More - Posts: 51 - Thank you received: 0 - - 13 years 7 months ago - 13 years 7 months ago [\#95550](#95550) by [gili](/forum/user/6876-gili "View gili's Profile") Replied by *[gili](/forum/user/6876-gili "View gili's Profile")* on topic *[Back end categories explorer](/forum/2-general-talk-about-hikashop/79456-back-end-categories-explorer#95550 "hello when i activate Back end categories explorer and go to see the products the page goes blank .. and i have a report of memory error when i deactivate it everything is fine i have more than 240000 products in the db thank you")* hello i have imported them through a script directly to db cause i had to take them from another website i enabled debug mode in joomla but it does not show any errors since it shows a white page thanx Error 324 (net::ERR_EMPTY_RESPONSE): The server closed the connection without sending any data. (This is the error chrome gave me) Last edit: 13 years 7 months ago by [gili](/forum/user/6876-gili "View gili's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzc5NDU2LWJhY2stZW5kLWNhdGVnb3JpZXMtZXhwbG9yZXI/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) 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") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86321 - Thank you received: 14279 - - 13 years 7 months ago [\#95588](#95588) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Back end categories explorer](/forum/2-general-talk-about-hikashop/79456-back-end-categories-explorer#95588 "hello when i activate Back end categories explorer and go to see the products the page goes blank .. and i have a report of memory error when i deactivate it everything is fine i have more than 240000 products in the db thank you")* And do you have any error logged in the PHP error log of your server ? The category explorer has to load all the categories of your website. So if you have a lot of categories, it can potentially means too much data for the server to handle and thus there is an option to deactivate it in the configuration. I'm afraid that if you have a lot of categories, we won't be able to help much. The following user(s) said Thank You: [gili](/forum/user/6876-gili "View gili's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzc5NDU2LWJhY2stZW5kLWNhdGVnb3JpZXMtZXhwbG9yZXI/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[gili](/forum/user/6876-gili "View gili's Profile")** - [![gili's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6876-gili "View gili's Profile") Topic Author - [ Offline](/forum/user/6876-gili) Less More - Posts: 51 - Thank you received: 0 - - 13 years 7 months ago [\#95590](#95590) by [gili](/forum/user/6876-gili "View gili's Profile") Replied by *[gili](/forum/user/6876-gili "View gili's Profile")* on topic *[Back end categories explorer](/forum/2-general-talk-about-hikashop/79456-back-end-categories-explorer#95590 "hello when i activate Back end categories explorer and go to see the products the page goes blank .. and i have a report of memory error when i deactivate it everything is fine i have more than 240000 products in the db thank you")* hello i have only 371 categories (the brands are around 2000 and work ok) Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzc5NDU2LWJhY2stZW5kLWNhdGVnb3JpZXMtZXhwbG9yZXI/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[Xavier](/forum/user/4105-xavier "View Xavier's Profile")** - [![Xavier's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar4105.png)](/forum/user/4105-xavier "View Xavier's Profile") - [ Offline](/forum/user/4105-xavier) Less More - Posts: 13201 - Thank you received: 2322 - - - - [](http://www.kidiweb.fr) - 13 years 7 months ago [\#95635](#95635) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[Back end categories explorer](/forum/2-general-talk-about-hikashop/79456-back-end-categories-explorer#95635 "hello when i activate Back end categories explorer and go to see the products the page goes blank .. and i have a report of memory error when i deactivate it everything is fine i have more than 240000 products in the db thank you")* Hi, The brands are too in the categories listing, because it's a kind of category. Thanks to give us the error logged in the PHP error log. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzc5NDU2LWJhY2stZW5kLWNhdGVnb3JpZXMtZXhwbG9yZXI/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[gili](/forum/user/6876-gili "View gili's Profile")** - [![gili's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6876-gili "View gili's Profile") Topic Author - [ Offline](/forum/user/6876-gili) Less More - Posts: 51 - Thank you received: 0 - - 13 years 7 months ago [\#95636](#95636) by [gili](/forum/user/6876-gili "View gili's Profile") Replied by *[gili](/forum/user/6876-gili "View gili's Profile")* on topic *[Back end categories explorer](/forum/2-general-talk-about-hikashop/79456-back-end-categories-explorer#95636 "hello when i activate Back end categories explorer and go to see the products the page goes blank .. and i have a report of memory error when i deactivate it everything is fine i have more than 240000 products in the db thank you")* i dont know how to find the php error log can u help ? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzc5NDU2LWJhY2stZW5kLWNhdGVnb3JpZXMtZXhwbG9yZXI/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) 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") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86321 - Thank you received: 14279 - - 13 years 7 months ago [\#95650](#95650) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Back end categories explorer](/forum/2-general-talk-about-hikashop/79456-back-end-categories-explorer#95650 "hello when i activate Back end categories explorer and go to see the products the page goes blank .. and i have a report of memory error when i deactivate it everything is fine i have more than 240000 products in the db thank you")* It depends on how is setup your server. You should ask your hosting company. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzc5NDU2LWJhY2stZW5kLWNhdGVnb3JpZXMtZXhwbG9yZXI/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[gili](/forum/user/6876-gili "View gili's Profile")** - [![gili's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6876-gili "View gili's Profile") Topic Author - [ Offline](/forum/user/6876-gili) Less More - Posts: 51 - Thank you received: 0 - - 13 years 7 months ago [\#95663](#95663) by [gili](/forum/user/6876-gili "View gili's Profile") Replied by *[gili](/forum/user/6876-gili "View gili's Profile")* on topic *[Back end categories explorer](/forum/2-general-talk-about-hikashop/79456-back-end-categories-explorer#95663 "hello when i activate Back end categories explorer and go to see the products the page goes blank .. and i have a report of memory error when i deactivate it everything is fine i have more than 240000 products in the db thank you")* [Thu Mar 21 19:09:46 2013] [error] [client 178.59.197.244] PHP Fatal error: Allowed memory size of 343932928 bytes exhausted (tried to allocate 8388608 bytes) in /home/ubookftp/www.ubook.gr/libraries/joomla/database/database/mysql.php on line 712, referer: [ ubook.gr/administrator/index.php?option=...ashop&ctrl=dashboard](http://ubook.gr/administrator/index.php?option=com_hikashop&ctrl=dashboard) this is the error from error_log Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzc5NDU2LWJhY2stZW5kLWNhdGVnb3JpZXMtZXhwbG9yZXI/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) 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") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86321 - Thank you received: 14279 - - 13 years 7 months ago [\#95667](#95667) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Back end categories explorer](/forum/2-general-talk-about-hikashop/79456-back-end-categories-explorer#95667 "hello when i activate Back end categories explorer and go to see the products the page goes blank .. and i have a report of memory error when i deactivate it everything is fine i have more than 240000 products in the db thank you")* That Fatal error is for the dashboard page of HikaShop. Do you have other Fatal errors (the ones related to the categories/products listing where the categories explorer is used) in your error log ? The following user(s) said Thank You: [gili](/forum/user/6876-gili "View gili's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzc5NDU2LWJhY2stZW5kLWNhdGVnb3JpZXMtZXhwbG9yZXI/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[gili](/forum/user/6876-gili "View gili's Profile")** - [![gili's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6876-gili "View gili's Profile") Topic Author - [ Offline](/forum/user/6876-gili) Less More - Posts: 51 - Thank you received: 0 - - 13 years 7 months ago [\#95682](#95682) by [gili](/forum/user/6876-gili "View gili's Profile") Replied by *[gili](/forum/user/6876-gili "View gili's Profile")* on topic *[Back end categories explorer](/forum/2-general-talk-about-hikashop/79456-back-end-categories-explorer#95682 "hello when i activate Back end categories explorer and go to see the products the page goes blank .. and i have a report of memory error when i deactivate it everything is fine i have more than 240000 products in the db thank you")* i have sent you the link to the log .. in your inbox !!! Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzc5NDU2LWJhY2stZW5kLWNhdGVnb3JpZXMtZXhwbG9yZXI/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) 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") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86321 - Thank you received: 14279 - - 13 years 7 months ago [\#95696](#95696) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Back end categories explorer](/forum/2-general-talk-about-hikashop/79456-back-end-categories-explorer#95696 "hello when i activate Back end categories explorer and go to see the products the page goes blank .. and i have a report of memory error when i deactivate it everything is fine i have more than 240000 products in the db thank you")* It's that one: [Thu Mar 21 07:34:58 2013] [error] [client 178.59.197.244] PHP Fatal error: Allowed memory size of 343932928 bytes exhausted (tried to allocate 8388608 bytes) in /home/ubookftp/www.ubook.gr/libraries/joomla/database/database/mysql.php on line 712, referer: [ ubook.gr/administrator/index.php?option=...ikashop&ctrl=product](http://ubook.gr/administrator/index.php?option=com_hikashop&ctrl=product) So it means that the memory is getting filled completely before it can display anything. So it's not an error, just that the data is too much to handle. Maybe some kind of optimization in HikaShop could be possible but we won't be able to look at that before next week. Is that a brand new install of HikaShop 2.1.1 or was it updated from a previous version ? With the 2.1.1, if you have a fresh install, you have improvments in the database to optimize queries for lot of data like here. Maybe that could help ? Actually, we've only added some strategic indexes in some tables. That would already be a good start I think. You can compare the back/tables.sql file of the install package with the tables structure on your website to add the indexes if it's not a fresh install of the latest version and thus get these improvements. The following user(s) said Thank You: [gili](/forum/user/6876-gili "View gili's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzc5NDU2LWJhY2stZW5kLWNhdGVnb3JpZXMtZXhwbG9yZXI/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[gili](/forum/user/6876-gili "View gili's Profile")** - [![gili's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6876-gili "View gili's Profile") Topic Author - [ Offline](/forum/user/6876-gili) Less More - Posts: 51 - Thank you received: 0 - - 13 years 7 months ago [\#96120](#96120) by [gili](/forum/user/6876-gili "View gili's Profile") Replied by *[gili](/forum/user/6876-gili "View gili's Profile")* on topic *[Back end categories explorer](/forum/2-general-talk-about-hikashop/79456-back-end-categories-explorer#96120 "hello when i activate Back end categories explorer and go to see the products the page goes blank .. and i have a report of memory error when i deactivate it everything is fine i have more than 240000 products in the db thank you")* hello i reinstalled as u said but nothing has changed what i noticed though is that i have around 100000 categories ... and this is what causes the problem any suggestion ????? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzc5NDU2LWJhY2stZW5kLWNhdGVnb3JpZXMtZXhwbG9yZXI/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) 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") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86321 - Thank you received: 14279 - - 13 years 7 months ago [\#96128](#96128) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Back end categories explorer](/forum/2-general-talk-about-hikashop/79456-back-end-categories-explorer#96128 "hello when i activate Back end categories explorer and go to see the products the page goes blank .. and i have a report of memory error when i deactivate it everything is fine i have more than 240000 products in the db thank you")* Hi, From what you're saying, there is nothing we can do. The category explorer has to load all the categories to be able to display the category tree. Loading 100000 categories at once is not possible. You'll have to keep it deactivated or reduce a lot the amount of categories you're using. The following user(s) said Thank You: [gili](/forum/user/6876-gili "View gili's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzc5NDU2LWJhY2stZW5kLWNhdGVnb3JpZXMtZXhwbG9yZXI/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) 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.105 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)