Blank page for products with big amount of variant

  • Posts: 2
  • Thank you received: 0
11 years 5 months ago #150128

-- url of the page with the problem -- : www.plastronunique.nl/themes/jooTheme/in...633-strass-frontriem
-- HikaShop version -- :HikaShop Essential: 2.3.0
-- Joomla version -- : Joomla! 3.2.3
-- PHP version -- : 5.3.28
-- Browser(s) name and version -- : Gogole Chrome Version 32.0.1700.107
-- Error-message(debug-mod must be tuned on) -- : Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 32 bytes) in /customers/d/8/f/plastronunique.nl/httpd.www/themes/jooTheme/libraries/joomla/database/driver/mysqli.php on line 567

Hallo Everybody,

I'm new on HikaShop and I have a trouble that is really tricky.

I created a new shop, it's still unpublished, and added everything following the HikaShop Documentation.

It happens that for some product I see a blank page instead of the product page, and switching on the Joomla Debug this is the error that I get:

Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 32 bytes) in /customers/d/8/f/plastronunique.nl/httpd.www/themes/jooTheme/libraries/joomla/database/driver/mysqli.php on line 567

This is the product page:
www.plastronunique.nl/themes/jooTheme/in...633-strass-frontriem

The blank page appears on different PCs and with different browsers, also with Firefox and IE11.

I noted that the products with blank page are the ones with more charateristics matching. For example the one in this page has 5 charateristics, and each one has several variants, for 1799 total matches.

The same Charateristics used in other products have no issues when they have less then 300 matches.

The trouble is that I cannot remove variants, nor I can split them in different ways :(

Any suggestion on how to solve this limitation on managing a great number of variants??

Thanks in advance for your help. Have a great weekend.

Roxanne Valeria

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

  • Posts: 26270
  • Thank you received: 4044
  • MODERATOR
11 years 5 months ago #150136

Hi,

If you have a big number of variant, the best is to remove some characteristics and use "options" instead.

To solve the issue, there is nothing special to do in HikaShop, you should increase the memory limitation in your server.
You already have a 128MB limitation which is already pretty high but you have to understand that you server have to load the 1799 products in his memory to generate the page, it can be CPU & memory consuming.
Your error occurred in the Mysqli driver, it means that your server was retrieving the data from the database (and we can't know the amount of data it already retrieve, it can be 99% like it can be 20%).

We will investigate the problem but for most cases we saw, using "options" was a good solution, for the customer side like for the administration side (managing 1799 variants could be very very complex and time consuming).

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.
The following user(s) said Thank You: Roxanne

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

  • Posts: 2
  • Thank you received: 0
11 years 5 months ago #150140

Thanks Jerome,

We didn't think to move some charateristics to options because we thought about options as variants with prices, and charateristics as variants without price.

If no matters that options have no price adding, we'll try by sure yur suggestion.

Thank you very much for you help and your fast reply!
Have a good night and great weekend!

Regards, Roxanne Valeria

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

Time to create page: 0.055 seconds
Powered by Kunena Forum