503 Service Unavailable error in save the Variant

  • Posts: 6
  • Thank you received: 0
7 years 3 months ago #261352

When i updating from 2.6.4 to 3 version when save the Variant getting the attached error.
503
Service Unavailable

The server is temporarily busy, try again later

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

  • Posts: 26030
  • Thank you received: 4006
  • MODERATOR
7 years 3 months ago #261353

Hi,

As usual for such kind of error ; you have to take a look in your PHP error log in order to get the real error (and detailed) message.
You can also try to activate temporally the debug mode in your Joomla global configuration or force temporally the error reporting to maximum (still related to Joomla global config).

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: 6
  • Thank you received: 0
7 years 3 months ago #261371

error attached

Attachments:

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

  • Posts: 26030
  • Thank you received: 4006
  • MODERATOR
7 years 3 months ago #261372

Hi,

I am sorry but it does not indicate an error.
We just see that a page is processing by HikaShop but nothing is showing that there is an error or a problem.
So there is no related "error message" to that 503 page.

Please check your PHP error log.

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: 6
  • Thank you received: 0
7 years 3 months ago #262076

When i save the Variant getting the error

MySQL client ran out of memory SQL=SELECT p.* FROM #__hikashop_product AS p JOIN #__hikashop_variant AS v0 ON v0.variant_characteristic_id = 13 JOIN #__hikashop_variant AS v1 ON v1.variant_characteristic_id = 1 WHERE p.product_parent_id = 1770

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

  • Posts: 81677
  • Thank you received: 13100
  • MODERATOR
7 years 3 months ago #262092

Hi,

Thank you, that's a great help.
Try changing the line:

$leftjoins[] = 'JOIN #__hikashop_variant AS v'.$k.' ON v'.$k.'.variant_characteristic_id = '.(int)$value_id;
to:
$leftjoins[] = 'JOIN #__hikashop_variant AS v'.$k.' ON p.product_id = v.variant_product_id AND v'.$k.'.variant_characteristic_id = '.(int)$value_id;
in the file administrator/components/com_hikashop/classes/product.php
That should fix the problem.

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

  • Posts: 6
  • Thank you received: 0
7 years 3 months ago #262099

When i save the Variant getting the error

1054 Unknown column 'v.variant_product_id' in 'on clause' SQL=SELECT p.* FROM #__hikashop_product AS p JOIN #__hikashop_variant AS v0 ON p.product_id = v.variant_product_id AND v0.variant_characteristic_id = 13 JOIN #__hikashop_variant AS v1 ON p.product_id = v.variant_product_id AND v1.variant_characteristic_id = 1 WHERE p.product_parent_id = 1770

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

  • Posts: 81677
  • Thank you received: 13100
  • MODERATOR
7 years 3 months ago #262109

Hi,

Try with this line of code instead then:

$leftjoins[] = 'JOIN #__hikashop_variant AS v'.$k.' ON p.product_id = v'.$k.'.variant_product_id AND v'.$k.'.variant_characteristic_id = '.(int)$value_id;

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

  • Posts: 6
  • Thank you received: 0
7 years 3 months ago #262114

This code works fine now.
thank you

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

Time to create page: 0.070 seconds
Powered by Kunena Forum