Exception Occured.
Exception Message:
Could not sort products:
SELECT * FROM (
SELECT DISTINCT * FROM (
SELECT DISTINCT
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 tblProduct.Manufacturer_ID = 7
AND tblProduct.Hidden = '0'
ORDER BY Actual_Price DESC LIMIT 36
) AS foo ORDER BY Actual_Price ASC LIMIT -7
) AS bar ORDER BY Actual_Price DESC
.
In File:
/home/echosupplements/htdocs/controller/ManufacturerController.php
On Line:
314
Trace:
0 /home/echosupplements/htdocs/view/ManufacturerView.php(213): ManufacturerController->GetProductsIn(Object(ManufacturerModel), 12, 'Actual_Price', 'DESC', '3')
1 /home/echosupplements/htdocs/view/ManufacturerView.php(174): ManufacturerView->LoadAllProducts()
2 /home/echosupplements/htdocs/view/ManufacturerView.php(106): ManufacturerView->LoadMainContentColumn()
3 /home/echosupplements/htdocs/manufacturer.php(32): ManufacturerView->LoadDefault()
4 {main}