503 Service Unavailable error in save the Variant
9 years 8 months ago #261352
by sahab666
503 Service Unavailable error in save the Variant was created by sahab666
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
503
Service Unavailable
The server is temporarily busy, try again later
Please Log in or Create an account to join the conversation.
9 years 8 months ago #261353
by Jerome
Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.
Replied by Jerome on topic 503 Service Unavailable error in save the Variant
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,
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.
Please Log in or Create an account to join the conversation.
9 years 8 months ago #261371
by sahab666
Replied by sahab666 on topic 503 Service Unavailable error in save the Variant
error attached
Please Log in or Create an account to join the conversation.
9 years 7 months ago #261372
by Jerome
Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.
Replied by Jerome on topic 503 Service Unavailable error in save the Variant
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,
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.
Please Log in or Create an account to join the conversation.
9 years 7 months ago #262076
by sahab666
Replied by sahab666 on topic 503 Service Unavailable error in save the Variant
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
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.
9 years 7 months ago #262092
by nicolas
Replied by nicolas on topic 503 Service Unavailable error in save the Variant
Hi,
Thank you, that's a great help.
Try changing the line:
to:
in the file administrator/components/com_hikashop/classes/product.php
That should fix the problem.
Thank you, that's a great help.
Try changing the line:
Code:
$leftjoins[] = 'JOIN #__hikashop_variant AS v'.$k.' ON v'.$k.'.variant_characteristic_id = '.(int)$value_id;
Code:
$leftjoins[] = 'JOIN #__hikashop_variant AS v'.$k.' ON p.product_id = v.variant_product_id AND v'.$k.'.variant_characteristic_id = '.(int)$value_id;
That should fix the problem.
Please Log in or Create an account to join the conversation.
9 years 7 months ago #262099
by sahab666
Replied by sahab666 on topic 503 Service Unavailable error in save the Variant
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
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.
9 years 7 months ago #262109
by nicolas
Replied by nicolas on topic 503 Service Unavailable error in save the Variant
Hi,
Try with this line of code instead then:
Try with this line of code instead then:
Code:
$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.
9 years 7 months ago #262114
by sahab666
Replied by sahab666 on topic 503 Service Unavailable error in save the Variant
This code works fine now.
thank you
thank you
Please Log in or Create an account to join the conversation.
Time to create page: 0.220 seconds