Sort by Price for Variants - Error 1054

neo191987
Topic Author
Offline

8 years 7 months ago - 8 years 7 months ago #287465 by neo191987

Sort by Price for Variants - Error 1054 was created by neo191987

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 7 months ago by neo191987.

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

Mohamed Thelji
Offline

8 years 7 months ago #287469 by Mohamed Thelji

Replied by Mohamed Thelji on topic Sort by Price for Variants - Error 1054

Hello,

Can you us the "Check database" button via "Hikashop->System->Configuration" and test it again ?

Thank you.

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

neo191987
Topic Author
Offline

8 years 7 months ago #287516 by neo191987

Replied by neo191987 on topic Sort by Price for Variants - Error 1054

Hi, unfortunately without success.

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

nicolas
Away

8 years 7 months ago #287524 by nicolas

Replied by nicolas on topic Sort by Price for Variants - Error 1054

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 or Create an account to join the conversation.

neo191987
Topic Author
Offline

8 years 7 months ago #287582 by neo191987

Replied by neo191987 on topic Sort by Price for Variants - Error 1054

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 or Create an account to join the conversation.

nicolas
Away

8 years 7 months ago #287585 by nicolas

Replied by nicolas on topic Sort by Price for Variants - Error 1054

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

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

Time to create page: 0.261 seconds