[Skip to main content](#vessel-content) # Product Category Keeps Disappearing ## - **[nickk](/forum/user/59388-nickk "View nickk's Profile")** - [![nickk's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/59388-nickk "View nickk's Profile") Topic Author - [ Offline](/forum/user/59388-nickk) Less More - Posts: 32 - Thank you received: 1 - - 6 years 4 months ago - 6 years 4 months ago [\#321734](#321734) by [nickk](/forum/user/59388-nickk "View nickk's Profile") *[Product Category Keeps Disappearing](/forum/25-install-update/900359-product-category-keeps-disappearing#321734 "-- HikaShop version -- : 4.3.0 -- Joomla version -- : 3.9.19 -- PHP version -- : 7.4.0 -- Browser(s) name and version -- : Firefox Developer 78.ob8 -- Error-message(debug-mod must be tuned on) -- : Blank Page I noticed that a product category on the front of the site was not displaying correctly, all 404 and 500 errors for page resources, but other product category pages were fine. See below. Problem - No Problem - I temporarily fixed it by clearing the products and re importing them from scratch. Today I look again and the problem is back. I've searched throughout this forum and can not find a solution. This is fairly time sensitive since it is our primary product line. Thanks for your help!")* was created by *[nickk](/forum/user/59388-nickk "View nickk's Profile")* -- HikaShop version -- : 4.3.0 -- Joomla version -- : 3.9.19 -- PHP version -- : 7.4.0 -- Browser(s) name and version -- : Firefox Developer 78.ob8 -- Error-message(debug-mod must be tuned on) -- : Blank Page I noticed that a product category on the front of the site was not displaying correctly, all 404 and 500 errors for page resources, but other product category pages were fine. See below. Problem - [ Beer](/shop-products/category/beer.html) No Problem - [ Soda](/shop-products/category/soda.html) I temporarily fixed it by clearing the products and re importing them from scratch. Today I look again and the problem is back. I've searched throughout this forum and can not find a solution. This is fairly time sensitive since it is our primary product line. Thanks for your help! [ ![ScreenShot2020-07-06at3.44.25PM.png](/forum/attachment/49993) ](/forum/attachment/49993 "...t3.44.25PM.png") - [ ![ScreenShot2020-07-06at3.44.25PM.png](/forum/attachment/49993) ](/forum/attachment/49993 "...t3.44.25PM.png") [ ](/forum/attachment/49993?download=1 "...t3.44.25PM.png") Last edit: 6 years 4 months ago by [nickk](/forum/user/59388-nickk "View nickk's Profile"). Reason: Fatal error: Allowed memory size of 805306368 bytes exhausted (tried to allocate 4096 bytes) in /.../.../public_html/libraries/joomla/database/driver/mysqli.php on line 891 Fatal error: All Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzkwMDM1OS1wcm9kdWN0LWNhdGVnb3J5LWtlZXBzLWRpc2FwcGVhcmluZz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Philip](/forum/user/34318-philip "View Philip's Profile")** - [![Philip's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar34318_2015-11-18-2.png)](/forum/user/34318-philip "View Philip's Profile") - [ Offline](/forum/user/34318-philip) Less More - Posts: 4820 - Thank you received: 652 - - 6 years 4 months ago - 6 years 4 months ago [\#321763](#321763) by [Philip](/forum/user/34318-philip "View Philip's Profile") Replied by *[Philip](/forum/user/34318-philip "View Philip's Profile")* on topic *[Product Category Keeps Disappearing](/forum/25-install-update/900359-product-category-keeps-disappearing#321763 "-- HikaShop version -- : 4.3.0 -- Joomla version -- : 3.9.19 -- PHP version -- : 7.4.0 -- Browser(s) name and version -- : Firefox Developer 78.ob8 -- Error-message(debug-mod must be tuned on) -- : Blank Page I noticed that a product category on the front of the site was not displaying correctly, all 404 and 500 errors for page resources, but other product category pages were fine. See below. Problem - No Problem - I temporarily fixed it by clearing the products and re importing them from scratch. Today I look again and the problem is back. I've searched throughout this forum and can not find a solution. This is fairly time sensitive since it is our primary product line. Thanks for your help!")* Hello, we are sorry but we aren't able to understand your issue, we use your **2 link urls** (Problem - Beer / No Problem - Soda) and we see exactly the same page... Expect the error message : "***Warning Page not found : beer***" Can you details more through **more explanation** what is your issue and show us with **screenshots** (and annotation). This will help us to better understand situation and better answer you. Regards Last edit: 6 years 4 months ago by [Philip](/forum/user/34318-philip "View Philip's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzkwMDM1OS1wcm9kdWN0LWNhdGVnb3J5LWtlZXBzLWRpc2FwcGVhcmluZz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nickk](/forum/user/59388-nickk "View nickk's Profile")** - [![nickk's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/59388-nickk "View nickk's Profile") Topic Author - [ Offline](/forum/user/59388-nickk) Less More - Posts: 32 - Thank you received: 1 - - 6 years 4 months ago [\#321770](#321770) by [nickk](/forum/user/59388-nickk "View nickk's Profile") Replied by *[nickk](/forum/user/59388-nickk "View nickk's Profile")* on topic *[Product Category Keeps Disappearing](/forum/25-install-update/900359-product-category-keeps-disappearing#321770 "-- HikaShop version -- : 4.3.0 -- Joomla version -- : 3.9.19 -- PHP version -- : 7.4.0 -- Browser(s) name and version -- : Firefox Developer 78.ob8 -- Error-message(debug-mod must be tuned on) -- : Blank Page I noticed that a product category on the front of the site was not displaying correctly, all 404 and 500 errors for page resources, but other product category pages were fine. See below. Problem - No Problem - I temporarily fixed it by clearing the products and re importing them from scratch. Today I look again and the problem is back. I've searched throughout this forum and can not find a solution. This is fairly time sensitive since it is our primary product line. Thanks for your help!")* Here is a category that is functioning properly: [ extonbeverage.com/shop-products/category/2345-soda.html](https://extonbeverage.com/shop-products/category/2345-soda.html) Here is the problem category: [ extonbeverage.com/shop-products/category/2123-beer.html](https://extonbeverage.com/shop-products/category/2123-beer.html) The first displays correctly, the second white screens. The error reads as provided above, 500 and 404s. I've attempted to remove and add canonical urls, but there is no effect. [ ![ScreenShot2020-07-07at9.40.29AM.png](/forum/attachment/50010) ](/forum/attachment/50010 "...t9.40.29AM.png") [ ![ScreenShot2020-07-07at9.40.03AM.png](/forum/attachment/50011) ](/forum/attachment/50011 "...t9.40.03AM.png") - [ ![ScreenShot2020-07-07at9.40.29AM.png](/forum/attachment/50010) ](/forum/attachment/50010 "...t9.40.29AM.png") [ ](/forum/attachment/50010?download=1 "...t9.40.29AM.png") - [ ![ScreenShot2020-07-07at9.40.03AM.png](/forum/attachment/50011) ](/forum/attachment/50011 "...t9.40.03AM.png") [ ](/forum/attachment/50011?download=1 "...t9.40.03AM.png") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzkwMDM1OS1wcm9kdWN0LWNhdGVnb3J5LWtlZXBzLWRpc2FwcGVhcmluZz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nickk](/forum/user/59388-nickk "View nickk's Profile")** - [![nickk's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/59388-nickk "View nickk's Profile") Topic Author - [ Offline](/forum/user/59388-nickk) Less More - Posts: 32 - Thank you received: 1 - - 6 years 4 months ago - 6 years 4 months ago [\#321771](#321771) by [nickk](/forum/user/59388-nickk "View nickk's Profile") Replied by *[nickk](/forum/user/59388-nickk "View nickk's Profile")* on topic *[Product Category Keeps Disappearing](/forum/25-install-update/900359-product-category-keeps-disappearing#321771 "-- HikaShop version -- : 4.3.0 -- Joomla version -- : 3.9.19 -- PHP version -- : 7.4.0 -- Browser(s) name and version -- : Firefox Developer 78.ob8 -- Error-message(debug-mod must be tuned on) -- : Blank Page I noticed that a product category on the front of the site was not displaying correctly, all 404 and 500 errors for page resources, but other product category pages were fine. See below. Problem - No Problem - I temporarily fixed it by clearing the products and re importing them from scratch. Today I look again and the problem is back. I've searched throughout this forum and can not find a solution. This is fairly time sensitive since it is our primary product line. Thanks for your help!")* I'm not sure if this is related, but looking at the db and the hikashop_product table, there are over 14,000,000 records. The cron is set to import from the POS every 5 minutes. Is it just adding new records rather than updating existing records and the website is timing out because it has to go through so many product records? I cleared the products via sql, and reimported the latest product update file and the page works again. Which is what happened last time. So I guess the question is: How do I keep the product update cron from adding new records, but instead just update products that are already in the db? Last edit: 6 years 4 months ago by [nickk](/forum/user/59388-nickk "View nickk's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzkwMDM1OS1wcm9kdWN0LWNhdGVnb3J5LWtlZXBzLWRpc2FwcGVhcmluZz90bXBsPW1hcmtkb3du) 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: 86358 - Thank you received: 14293 - - 6 years 4 months ago [\#321777](#321777) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Product Category Keeps Disappearing](/forum/25-install-update/900359-product-category-keeps-disappearing#321777 "-- HikaShop version -- : 4.3.0 -- Joomla version -- : 3.9.19 -- PHP version -- : 7.4.0 -- Browser(s) name and version -- : Firefox Developer 78.ob8 -- Error-message(debug-mod must be tuned on) -- : Blank Page I noticed that a product category on the front of the site was not displaying correctly, all 404 and 500 errors for page resources, but other product category pages were fine. See below. Problem - No Problem - I temporarily fixed it by clearing the products and re importing them from scratch. Today I look again and the problem is back. I've searched throughout this forum and can not find a solution. This is fairly time sensitive since it is our primary product line. Thanks for your help!")* Hi, The website is not timing out on my end, but the pages are sure loading slowly. Having 14 millions products entries is indeed a problem and will considerably slow the page processing as MySQL will take more time retrieving the products. So there must be a problem with the import. Maybe something has to be changed in the CSV or in the settings of the plugin. Now regarding the URLs, it seems that the issue is that you've activated the "force canonical URLs on listing" setting in the HikaShop configuration and that you have invalid canonical URLs. The simple solution in the short term so that it works fine is to turn off that setting. Then, you can clear the products you have in the hikashop_product table, fix the problem with the import, and then properly set the canonical URLs before activating the setting again. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzkwMDM1OS1wcm9kdWN0LWNhdGVnb3J5LWtlZXBzLWRpc2FwcGVhcmluZz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nickk](/forum/user/59388-nickk "View nickk's Profile")** - [![nickk's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/59388-nickk "View nickk's Profile") Topic Author - [ Offline](/forum/user/59388-nickk) Less More - Posts: 32 - Thank you received: 1 - - 6 years 4 months ago [\#321854](#321854) by [nickk](/forum/user/59388-nickk "View nickk's Profile") Replied by *[nickk](/forum/user/59388-nickk "View nickk's Profile")* on topic *[Product Category Keeps Disappearing](/forum/25-install-update/900359-product-category-keeps-disappearing#321854 "-- HikaShop version -- : 4.3.0 -- Joomla version -- : 3.9.19 -- PHP version -- : 7.4.0 -- Browser(s) name and version -- : Firefox Developer 78.ob8 -- Error-message(debug-mod must be tuned on) -- : Blank Page I noticed that a product category on the front of the site was not displaying correctly, all 404 and 500 errors for page resources, but other product category pages were fine. See below. Problem - No Problem - I temporarily fixed it by clearing the products and re importing them from scratch. Today I look again and the problem is back. I've searched throughout this forum and can not find a solution. This is fairly time sensitive since it is our primary product line. Thanks for your help!")* The problem appears to be that the Mass Actions I have set to update certain products characteristics and add in the variants, is the challenge. Every time it runs it adds in the new variants, the count is up to 16 per product needing the options, at 100+ products needing the options, that adds up quickly. Is there a way to keep that mass action from running on products that already have the characteristic variants? Joomla errors when I attempt to add a filter for the characteristic, see screenshot. [ ![ScreenShot2020-07-09at8.50.06AM.png](/forum/attachment/50021) ](/forum/attachment/50021 "...t8.50.06AM.png") - [ ![ScreenShot2020-07-09at8.50.06AM.png](/forum/attachment/50021) ](/forum/attachment/50021 "...t8.50.06AM.png") [ ](/forum/attachment/50021?download=1 "...t8.50.06AM.png") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzkwMDM1OS1wcm9kdWN0LWNhdGVnb3J5LWtlZXBzLWRpc2FwcGVhcmluZz90bXBsPW1hcmtkb3du) 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: 86358 - Thank you received: 14293 - - 6 years 4 months ago [\#321859](#321859) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Product Category Keeps Disappearing](/forum/25-install-update/900359-product-category-keeps-disappearing#321859 "-- HikaShop version -- : 4.3.0 -- Joomla version -- : 3.9.19 -- PHP version -- : 7.4.0 -- Browser(s) name and version -- : Firefox Developer 78.ob8 -- Error-message(debug-mod must be tuned on) -- : Blank Page I noticed that a product category on the front of the site was not displaying correctly, all 404 and 500 errors for page resources, but other product category pages were fine. See below. Problem - No Problem - I temporarily fixed it by clearing the products and re importing them from scratch. Today I look again and the problem is back. I've searched throughout this forum and can not find a solution. This is fairly time sensitive since it is our primary product line. Thanks for your help!")* Hi, This error is just for the refreshing of the number of elements matching the filter. I think you can ignore it. But we've added a patch on our end for that. Download again the install package of the latest version of HikaShop on our website and install it on yours and it will add the patch for that issue. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzkwMDM1OS1wcm9kdWN0LWNhdGVnb3J5LWtlZXBzLWRpc2FwcGVhcmluZz90bXBsPW1hcmtkb3du) 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.060 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)