[Skip to main content](#vessel-content) # 503 Service Unavailable error in save the Variant ## - **[sahab666](/forum/user/33916-sahab666 "View sahab666's Profile")** - [![sahab666's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/33916-sahab666 "View sahab666's Profile") Topic Author - [ Offline](/forum/user/33916-sahab666) Less More - Posts: 6 - Thank you received: 0 - - [](http://www.1farsh.com/%D8%AA%D8%A7%D8%A8%D9%84%D9%) - 9 years 8 months ago [\#261352](#261352) by [sahab666](/forum/user/33916-sahab666 "View sahab666's Profile") *[503 Service Unavailable error in save the Variant](/forum/25-install-update/888662-503-service-unavailable-error-in-save-the-variant#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")* was created by *[sahab666](/forum/user/33916-sahab666 "View sahab666's Profile")* 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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg4ODY2Mi01MDMtc2VydmljZS11bmF2YWlsYWJsZS1lcnJvci1pbi1zYXZlLXRoZS12YXJpYW50P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 9 years 8 months ago [\#261353](#261353) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[503 Service Unavailable error in save the Variant](/forum/25-install-update/888662-503-service-unavailable-error-in-save-the-variant#261353 "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")* 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. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg4ODY2Mi01MDMtc2VydmljZS11bmF2YWlsYWJsZS1lcnJvci1pbi1zYXZlLXRoZS12YXJpYW50P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[sahab666](/forum/user/33916-sahab666 "View sahab666's Profile")** - [![sahab666's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/33916-sahab666 "View sahab666's Profile") Topic Author - [ Offline](/forum/user/33916-sahab666) Less More - Posts: 6 - Thank you received: 0 - - [](http://www.1farsh.com/%D8%AA%D8%A7%D8%A8%D9%84%D9%) - 9 years 8 months ago [\#261371](#261371) by [sahab666](/forum/user/33916-sahab666 "View sahab666's Profile") Replied by *[sahab666](/forum/user/33916-sahab666 "View sahab666's Profile")* on topic *[503 Service Unavailable error in save the Variant](/forum/25-install-update/888662-503-service-unavailable-error-in-save-the-variant#261371 "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")* error attached - [ ![error-503.jpg](/forum/attachment/36088) ](/forum/attachment/36088 "error-503.jpg") [ ](/forum/attachment/36088?download=1 "error-503.jpg") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg4ODY2Mi01MDMtc2VydmljZS11bmF2YWlsYWJsZS1lcnJvci1pbi1zYXZlLXRoZS12YXJpYW50P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 9 years 8 months ago [\#261372](#261372) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[503 Service Unavailable error in save the Variant](/forum/25-install-update/888662-503-service-unavailable-error-in-save-the-variant#261372 "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")* 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. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg4ODY2Mi01MDMtc2VydmljZS11bmF2YWlsYWJsZS1lcnJvci1pbi1zYXZlLXRoZS12YXJpYW50P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[sahab666](/forum/user/33916-sahab666 "View sahab666's Profile")** - [![sahab666's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/33916-sahab666 "View sahab666's Profile") Topic Author - [ Offline](/forum/user/33916-sahab666) Less More - Posts: 6 - Thank you received: 0 - - [](http://www.1farsh.com/%D8%AA%D8%A7%D8%A8%D9%84%D9%) - 9 years 8 months ago [\#262076](#262076) by [sahab666](/forum/user/33916-sahab666 "View sahab666's Profile") Replied by *[sahab666](/forum/user/33916-sahab666 "View sahab666's Profile")* on topic *[503 Service Unavailable error in save the Variant](/forum/25-install-update/888662-503-service-unavailable-error-in-save-the-variant#262076 "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")* 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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg4ODY2Mi01MDMtc2VydmljZS11bmF2YWlsYWJsZS1lcnJvci1pbi1zYXZlLXRoZS12YXJpYW50P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86290 - Thank you received: 14268 - - 9 years 8 months ago [\#262092](#262092) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[503 Service Unavailable error in save the Variant](/forum/25-install-update/888662-503-service-unavailable-error-in-save-the-variant#262092 "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")* Hi, 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; to: 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; in the file administrator/components/com_hikashop/classes/product.php That should fix the problem. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg4ODY2Mi01MDMtc2VydmljZS11bmF2YWlsYWJsZS1lcnJvci1pbi1zYXZlLXRoZS12YXJpYW50P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[sahab666](/forum/user/33916-sahab666 "View sahab666's Profile")** - [![sahab666's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/33916-sahab666 "View sahab666's Profile") Topic Author - [ Offline](/forum/user/33916-sahab666) Less More - Posts: 6 - Thank you received: 0 - - [](http://www.1farsh.com/%D8%AA%D8%A7%D8%A8%D9%84%D9%) - 9 years 8 months ago [\#262099](#262099) by [sahab666](/forum/user/33916-sahab666 "View sahab666's Profile") Replied by *[sahab666](/forum/user/33916-sahab666 "View sahab666's Profile")* on topic *[503 Service Unavailable error in save the Variant](/forum/25-install-update/888662-503-service-unavailable-error-in-save-the-variant#262099 "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")* 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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg4ODY2Mi01MDMtc2VydmljZS11bmF2YWlsYWJsZS1lcnJvci1pbi1zYXZlLXRoZS12YXJpYW50P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86290 - Thank you received: 14268 - - 9 years 8 months ago [\#262109](#262109) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[503 Service Unavailable error in save the Variant](/forum/25-install-update/888662-503-service-unavailable-error-in-save-the-variant#262109 "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")* Hi, 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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg4ODY2Mi01MDMtc2VydmljZS11bmF2YWlsYWJsZS1lcnJvci1pbi1zYXZlLXRoZS12YXJpYW50P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[sahab666](/forum/user/33916-sahab666 "View sahab666's Profile")** - [![sahab666's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/33916-sahab666 "View sahab666's Profile") Topic Author - [ Offline](/forum/user/33916-sahab666) Less More - Posts: 6 - Thank you received: 0 - - [](http://www.1farsh.com/%D8%AA%D8%A7%D8%A8%D9%84%D9%) - 9 years 8 months ago [\#262114](#262114) by [sahab666](/forum/user/33916-sahab666 "View sahab666's Profile") Replied by *[sahab666](/forum/user/33916-sahab666 "View sahab666's Profile")* on topic *[503 Service Unavailable error in save the Variant](/forum/25-install-update/888662-503-service-unavailable-error-in-save-the-variant#262114 "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")* This code works fine now. thank you Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg4ODY2Mi01MDMtc2VydmljZS11bmF2YWlsYWJsZS1lcnJvci1pbi1zYXZlLXRoZS12YXJpYW50P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop- Install & Update- Product & Category Display- Content Creation- Sales and Orders- - Orders management- - Reports & Statistics- Customers- Checkout- Payment Methods- Shipping Methods- Import & Export (CSV, XLS…)- Specific Features- - Affilation- - Taxes- - Wishlist- - Vote- - Carousel & Slider- - Mass Actions- - Filters & Search- - Discount & Coupon- - Feature Request- Integrations- Showcase- General Talk about HikaShop- Development- - HikaShop 3.0 Beta- Translation- Commercial Jobs HikaShop Components- HikaMarket- - Market: Feature requests- - Market: How to?- - Market: Bug Report- HikaSerial- - General talk about HikaSerial- - Serial: Bug Report- - Serial: How to?- - Support en Français de HikaSerial (French Support)- - HikaSubscription- HikaAuction- - Auction: Feature requests- - Auction: How to?- - Auction: Bug report Hikashop around the world- Support en Français (French Support)- Russian- - FAQ. Курс выживания с Hikashop. Частые вопросы и о- - Расширения Hikashop- - Наши сайты на Hikashop- 日本語版サポート(Japanese Support)- Thai- German Archives- Bug Report- How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.291 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)