Exception Occured.
Exception Message:
Could not sort products:
SELECT * FROM (
SELECT * FROM (
SELECT
tblCategory_Products.Product_ID,
tblProduct_Text.Display_Name,
tblProduct.Actual_Price
FROM
tblCategory_Products
INNER JOIN tblProduct
ON tblProduct.Product_ID = tblCategory_Products.Product_ID
INNER JOIN tblProduct_Text
ON tblProduct.Product_ID = tblProduct_Text.Product_ID
WHERE
(
tblCategory_Products.Category_ID = 158
OR
tblCategory_Products.Category_ID IN
(SELECT tblCategory.Category_ID FROM tblCategory WHERE tblCategory.Parent_Category_ID = 158)
)
AND tblProduct.Hidden = '0'
ORDER BY Actual_Price DESC, tblProduct_Text.Display_Name DESC
LIMIT 24
) AS foo ORDER BY Actual_Price ASC, Display_Name ASC LIMIT -2
) AS bar ORDER BY Actual_Price DESC, Display_Name DESC
.
In File:
/home/echosupplements/htdocs/controller/CategoryController.php
On Line:
339
Trace:
0 /home/echosupplements/htdocs/view/CategoryView.php(228): CategoryController->GetTopLevelCategoryProducts(Object(CategoryModel), 12, 'Actual_Price', 'DESC', '2')
1 /home/echosupplements/htdocs/view/CategoryView.php(182): CategoryView->LoadProducts()
2 /home/echosupplements/htdocs/view/CategoryView.php(95): CategoryView->LoadMainContentColumn()
3 /home/echosupplements/htdocs/category.php(27): CategoryView->LoadDefault()
4 {main}