Failure Product after large number of Variants

  • Posts: 24
  • Thank you received: 1
6 years 9 months ago #275387

-- HikaShop version -- : 3.1.1
-- Joomla version -- : 3.7.4
-- PHP version -- : 5.6

Hi All,

I Tested something with large number of variants, issue now is i cannot open this product anymore, then i get a 500 Server Error
PHP Error is telling me following

**
Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 56 bytes) in /home/vhosts/houtvanappel.nl/httpdocs/libraries/joomla/database/driver/mysqli.php on line 886
**

I can add other products and everything, but this specific product causes this error, how can i remove this product, select and delte doesnt work, gives same error...

Please Log in or Create an account to join the conversation.

  • Posts: 26024
  • Thank you received: 4005
  • MODERATOR
6 years 9 months ago #275411

Hello,

How many variants do you have for your product ?

Please understand that, more you have variant and more memory it will require for your server to handle them all.
So if you want to interact with huge number of variants ; you need to increase your server memory limit.

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

  • Posts: 24
  • Thank you received: 1
6 years 9 months ago #275444

Do i need to upgrade the limit of the SQL?

It happend by accident, its over 2000 variants if i guess.
but i cannot delete the product anymore, because of getting 500 server error.
how to delete this one?

Please Log in or Create an account to join the conversation.

  • Posts: 26024
  • Thank you received: 4005
  • MODERATOR
6 years 9 months ago #275447

Hello,

The memory limit issue you have is regarding PHP.

2000 is indeed way too much for variants and you can use "options" of "custom fields" in order to avoid having so many items.
If you got more than 100 variants, we consider that you can use another feature to avoid having so many entries to manage (prices, images, etc).

If you can't delete them from the backend product page, I'm afraid that you'll need to do it manually via PHPMyAdmin.
You have to delete elements in the table "hikashop_product" which have the "product_type" "variant" and the "product_parent_id" of the product causing issues.
And you also need to clean up the table "hikashop_variant" and maybe the table "hikashop_price" if you added prices to these variants.

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

Time to create page: 0.063 seconds
Powered by Kunena Forum