[Skip to main content](#vessel-content) # Sort by Price for Variants - Error 1054 ## - **[neo191987](/forum/user/35364-neo191987 "View neo191987's Profile")** - [![neo191987's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar35364.jpg)](/forum/user/35364-neo191987 "View neo191987's Profile") Topic Author - [ Offline](/forum/user/35364-neo191987) Less More - Posts: 431 - Thank you received: 19 - - 8 years 8 months ago - 8 years 8 months ago [\#287465](#287465) by [neo191987](/forum/user/35364-neo191987 "View neo191987's Profile") *[Sort by Price for Variants - Error 1054](/forum/2-general-talk-about-hikashop/893728-sort-by-price-for-variants-error-1054#287465 "Hi. I'm very glad you added this feature, but there's a problem sorting out variants by price. Displays the following error: Error: 1054 Unknown column 'c.product_sort_price' in 'order clause'.")* was created by *[neo191987](/forum/user/35364-neo191987 "View neo191987's Profile")* Hi. I'm very glad you added this feature, but there's a problem sorting out variants by price. Displays the following error: Error: 1054 Unknown column 'c.product_sort_price' in 'order clause'. Last edit: 8 years 8 months ago by [neo191987](/forum/user/35364-neo191987 "View neo191987's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzg5MzcyOC1zb3J0LWJ5LXByaWNlLWZvci12YXJpYW50cy1lcnJvci0xMDU0P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")** - [![Mohamed Thelji's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6861.png)](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") - [ Offline](/forum/user/6861-mohamed-thelji) Less More - Posts: 12953 - Thank you received: 1778 - - - 8 years 8 months ago [\#287469](#287469) by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") Replied by *[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")* on topic *[Sort by Price for Variants - Error 1054](/forum/2-general-talk-about-hikashop/893728-sort-by-price-for-variants-error-1054#287469 "Hi. I'm very glad you added this feature, but there's a problem sorting out variants by price. Displays the following error: Error: 1054 Unknown column 'c.product_sort_price' in 'order clause'.")* Hello, Can you us the "Check database" button via "Hikashop->System->Configuration" and test it again ? Thank you. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzg5MzcyOC1zb3J0LWJ5LXByaWNlLWZvci12YXJpYW50cy1lcnJvci0xMDU0P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[neo191987](/forum/user/35364-neo191987 "View neo191987's Profile")** - [![neo191987's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar35364.jpg)](/forum/user/35364-neo191987 "View neo191987's Profile") Topic Author - [ Offline](/forum/user/35364-neo191987) Less More - Posts: 431 - Thank you received: 19 - - 8 years 8 months ago [\#287516](#287516) by [neo191987](/forum/user/35364-neo191987 "View neo191987's Profile") Replied by *[neo191987](/forum/user/35364-neo191987 "View neo191987's Profile")* on topic *[Sort by Price for Variants - Error 1054](/forum/2-general-talk-about-hikashop/893728-sort-by-price-for-variants-error-1054#287516 "Hi. I'm very glad you added this feature, but there's a problem sorting out variants by price. Displays the following error: Error: 1054 Unknown column 'c.product_sort_price' in 'order clause'.")* Hi, unfortunately without success. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzg5MzcyOC1zb3J0LWJ5LXByaWNlLWZvci12YXJpYW50cy1lcnJvci0xMDU0P3RtcGw9bWFya2Rvd24=) 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") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86289 - Thank you received: 14265 - - 8 years 8 months ago [\#287524](#287524) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Sort by Price for Variants - Error 1054](/forum/2-general-talk-about-hikashop/893728-sort-by-price-for-variants-error-1054#287524 "Hi. I'm very glad you added this feature, but there's a problem sorting out variants by price. Displays the following error: Error: 1054 Unknown column 'c.product_sort_price' in 'order clause'.")* Hi, Please edit the file /libraries/joomla/database/exception/executing.php and change the line: parent::__construct($message, $code, $previous); by: parent::__construct($message.' '.$query, $code, $previous); in order to get the full MySQL query so that we have a better understanding of the situation. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzg5MzcyOC1zb3J0LWJ5LXByaWNlLWZvci12YXJpYW50cy1lcnJvci0xMDU0P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[neo191987](/forum/user/35364-neo191987 "View neo191987's Profile")** - [![neo191987's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar35364.jpg)](/forum/user/35364-neo191987 "View neo191987's Profile") Topic Author - [ Offline](/forum/user/35364-neo191987) Less More - Posts: 431 - Thank you received: 19 - - 8 years 8 months ago [\#287582](#287582) by [neo191987](/forum/user/35364-neo191987 "View neo191987's Profile") Replied by *[neo191987](/forum/user/35364-neo191987 "View neo191987's Profile")* on topic *[Sort by Price for Variants - Error 1054](/forum/2-general-talk-about-hikashop/893728-sort-by-price-for-variants-error-1054#287582 "Hi. I'm very glad you added this feature, but there's a problem sorting out variants by price. Displays the following error: Error: 1054 Unknown column 'c.product_sort_price' in 'order clause'.")* Code: Unknown column 'c.product_sort_price' in 'order clause' SELECT v.*, c.* FROM adl_hikashop_variant AS v INNER JOIN adl_hikashop_characteristic AS c ON v.variant_characteristic_id = c.characteristic_id WHERE v.variant_product_id IN (1,2) ORDER BY v.ordering ASC, c.product_sort_price ASC Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzg5MzcyOC1zb3J0LWJ5LXByaWNlLWZvci12YXJpYW50cy1lcnJvci0xMDU0P3RtcGw9bWFya2Rvd24=) 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") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86289 - Thank you received: 14265 - - 8 years 8 months ago [\#287585](#287585) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Sort by Price for Variants - Error 1054](/forum/2-general-talk-about-hikashop/893728-sort-by-price-for-variants-error-1054#287585 "Hi. I'm very glad you added this feature, but there's a problem sorting out variants by price. Displays the following error: Error: 1054 Unknown column 'c.product_sort_price' in 'order clause'.")* Hi, Remove the code: Code: } elseif($sort == 'price') { $order = 'product_sort_price ASC'; in components/com_hikashop/views/product/view.html.php and that should fix the issue. The following user(s) said Thank You: [neo191987](/forum/user/35364-neo191987 "View neo191987's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzg5MzcyOC1zb3J0LWJ5LXByaWNlLWZvci12YXJpYW50cy1lcnJvci0xMDU0P3RtcGw9bWFya2Rvd24=) 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.231 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)