Fatal Error message

  • Posts: 241
  • Thank you received: 5
9 years 7 months ago #197794

-- HikaShop version -- : 2.3.5
-- Joomla version -- : 3.3.6
-- Browser(s) name and version -- : chrome

I created a product and when trying to view on the frontend, I got a fatal error message (first screenshot).

I asked my hosting company to increased the amount of memory which the PHP processed of my server can use to 512MB... but no change.

I tried to delete the product and get the error in the second screenshot.

Attachments:

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

  • Posts: 82906
  • Thank you received: 13378
  • MODERATOR
9 years 7 months ago #197810

Hi,

The errors are from either the query handling library of Joomla or the transliteration system for URLs library of Joomla.
So it's hard to conclude on anything useful.
I've checked some of your products on your website and they do display properly. So there must be something with that product.
Could you provide a screenshot of the options of that product so that we can see what you did ?

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

  • Posts: 241
  • Thank you received: 5
9 years 7 months ago #198149

Unfortunately I deleted the product..after much delay and increasing the PHP memory to the max on my server.

However there is a stange item: as you will see in the screenshot attached, it seems that the replacement product (Select Shirt) is right at the place where we deleted there is a significant jump in product number (from 3800 to 52864).

I have no idea what caused this but want to bring it to your attention.

Thanks much.

Attachments:

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

  • Posts: 82906
  • Thank you received: 13378
  • MODERATOR
9 years 7 months ago #198161

Hi,

Thank you for your feedback.

This indicates that you added lot of characteristics to the product and the system had to add plenty of variants to the database for that product. That's probably why the product page crashed.

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

  • Posts: 241
  • Thank you received: 5
9 years 7 months ago #199012

We did not add ~50k variants however so this seems to be a bug.

More importantly, after deleting the variant and working over the past week, anything hikashop related has been VERY slow and almost impossible to add / manage products.

Not sure what is causing this but any help would be greatly appreciated.

Thanks for all you guys do!

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

  • Posts: 26159
  • Thank you received: 4028
  • MODERATOR
9 years 7 months ago #199141

Hi,

www.hikashop.com/support/support/documen...g.html#main_advanced

Generate variants automatically : When activated, HikaShop will generate automatically all the possible variants of a product when you add characteristics to it and save the product. When turned off, HikaShop won't generate the variants automatically and you'll have to add them yourself via the "manage variants" button of the product after adding the characteristics. It can be useful to turn off that option when you have a lot of variants possible with the characteristics but that you only need a handful of them in each product.

If you have that option activated ; it could explain why you have so many 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.

  • Posts: 241
  • Thank you received: 5
9 years 7 months ago #199206

Thank you for the response and I was VERY hopeful this would solve the issue.

Unfortunately it only made matters worse. When I would add variants and click "manage variants" the usual 90-120 second hang would happen and now this time I would get blank variants when the screen finally displayed (screenshot).

Any help would be great as creating products takes way too long right now and i worry there may be a larger issue happening as well which I can't understand.

Attachments:

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

  • Posts: 82906
  • Thank you received: 13378
  • MODERATOR
9 years 7 months ago #199215

Hi,

When you turn on that option, the variants of the product are generated automatically when you save a product with characteristics attached to it. If you make a mistake and add too many characteristics and/or characteristics with too many values, the system could end up generating a hell of a lot more variants than your server can handle, resulting in that fatal error you had.
When you turn off that option, the variants are not generated, and it's up to you to create them with the "new" button on that variants listing.

Turning off that option is not the solution to your problem. Jerome simply wanted to tell you that the root of the issue came from the fact that the system had generated too many variants because of how you added the characteristics to (some of) the products.
The issue is that you must have been doing something wrong with the characteristics which ended up with the system generating so many variants for your products that the website is getting slow.

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

  • Posts: 241
  • Thank you received: 5
9 years 7 months ago #199355

Ok. Thank you for the detailed explanation.

The issue still persists however and has persisted even after deleting the product / characteristics, etc.. which by the way had 8 variants (not 50k).

Either way, we can't really save, manage variants, change order status, etc on our events (products) without waiting 90-120 sec and the only component where this happens is hikashop.

Is there a solution / troubleshooting tips you might suggest? Thanks.

Last edit: 9 years 7 months ago by cberry1971.

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

  • Posts: 82906
  • Thank you received: 13378
  • MODERATOR
9 years 7 months ago #199377

Hi,

First, look at the table hikashop_product in the database via your phpmyadmin.
If you have 1000 products with 8 variants each, you should have 9000 entries in it (1000 main products and 8000 variants). I suspect that you must have hundred of thousands of entries in it that were generated by the system for your products, with most of them not being used at all.
So you'll have to understand which one as not used and remove them.

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

  • Posts: 241
  • Thank you received: 5
9 years 7 months ago #199716

1. I see that there are 3049 products in the table hikashop_product

2. there are 645 main products (i.e. not variants)

3. there are 2386 variants (category or shirt size for our events) in average of (2386 / 645 = 3.69) variants per main product

4. I see that product_id has jumped from 3800 to 52866 (I suppose that that happened when we were trying to create shirt size for a event... which only had 3 shirt variants)


what happened exactly:
->when we were trying to add that shirt size product and its variants (different shit sizes), hikashop should give the product id of this new product (shirt size) the next product id that it is not available in the table which should be 3801 but hikashop has jumped from 3801 to 52864

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

  • Posts: 82906
  • Thank you received: 13378
  • MODERATOR
9 years 7 months ago #199784

Hi,

So the problem is not with that table. It's probably another one.
Look at the other HikaShop tables and see if you have any with lots of entries.

HikaShop didn't jump from 3801 to 52864. All the ids from 3802 to 52863 were created by HikaShop at some point when you configured your products and it generated the variants. They were then removed when you deleted the product(s) and its (their) variants. but the new ids keep on incrementing. That's all there is to it. Having a big id for a product won't slow down the process.
What will is if there is a lot of data to process. So somewhere, you must have something with a lot of data.

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

  • Posts: 241
  • Thank you received: 5
9 years 7 months ago #199925

I have looked in other hikashop tables and there is no problem at all or size issues.

Any other ideas as to what could cause the major hangs when working with products on the backend?

We have found a temporary fix which is clearing our browser cache when it starts acting up.. then no problems for part of the day, then major problems again.. wash, rinse, repeat.

Thanks.

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

  • Posts: 82906
  • Thank you received: 13378
  • MODERATOR
9 years 7 months ago #199926

Hi,

So you're saying that it is only slow in the backend and only after using the backend for all the day, and that after flushing the browser cache, it gets fast again ?
I've never heard of that. What do you do during that whole day in your backend ? Only creating products ?
If you logout/login of the backend, do you have that fixed too ?
Or could the issue actually come from your browser ? Could you try with another one ?

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

  • Posts: 241
  • Thank you received: 5
9 years 7 months ago #200098

Yes.. the cache clear seems to fix things.

I will try the logout / login and circle back if that is the fix.

I will also try the other browser (switch from Chrome to Safari) and see if that helps.

Thanks.

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

Time to create page: 0.092 seconds
Powered by Kunena Forum