Array
(
    [0] => 

Fatal Error

[1] =>

SQLSTATE[42S22]: Column not found: 1054 Unknown column '13500∩acity_range' in 'where clause'


SELECT 1 AS cnt FROM `stocklist` AS st INNER JOIN `makes` AS sm ON st.`makeid`=sm.`id` INNER JOIN `types` AS tt ON st.`typeid`=tt.`id` LEFT JOIN `phl_special_offer` AS spe ON st.`stock_no`=spe.`stock_no` AND spe.`featured`='1' LEFT JOIN `values` AS ex ON st.`stock_no`=ex.`stock_no` AND ex.`fieldid`='92' LEFT JOIN `values` AS lift ON st.`stock_no`=lift.`stock_no` AND lift.`fieldid`='31' LEFT JOIN `values` AS photos ON st.`stock_no`=photos.`stock_no` AND photos.`fieldid` IN (14,98,118,119) LEFT JOIN `values` AS video ON st.`stock_no`=video.`stock_no` AND video.`fieldid`='140' LEFT JOIN `stocklist_categories` AS sc ON sc.`id`=st.`root_category` WHERE st.`stock_status`='Stock' AND sc.`category`= 'VNA' AND lift.value BETWEEN 0 AND 13500∩acity_range=0 GROUP BY st.`stock_no` ORDER BY st.capacity ASC

[2] =>

/var/www/phl.co.uk/web/lib/dbWrappers/db_pdo.php(85)

[3] =>

Debug Backtrace

[4] => #0 /var/www/phl.co.uk/web/lib/CDatabase.php(496): db_pdo->exec_query(SELECT 1 AS cnt FROM `stocklist` AS st INNER JOIN `makes` AS sm ON st.`makeid`=sm.`id` INNER JOIN `types` AS tt ON st.`typeid`=tt.`id` LEFT JOIN `phl_special_offer` AS spe ON st.`stock_no`=spe.`stock_no` AND spe.`featured`='1' LEFT JOIN `values` AS ex ON st.`stock_no`=ex.`stock_no` AND ex.`fieldid`='92' LEFT JOIN `values` AS lift ON st.`stock_no`=lift.`stock_no` AND lift.`fieldid`='31' LEFT JOIN `values` AS photos ON st.`stock_no`=photos.`stock_no` AND photos.`fieldid` IN (14,98,118,119) LEFT JOIN `values` AS video ON st.`stock_no`=video.`stock_no` AND video.`fieldid`='140' LEFT JOIN `stocklist_categories` AS sc ON sc.`id`=st.`root_category` WHERE st.`stock_status`='Stock' AND sc.`category`= 'VNA' AND lift.value BETWEEN 0 AND 13500∩acity_range=0 GROUP BY st.`stock_no` ORDER BY st.capacity ASC , , Object(PDO)) #1 /var/www/phl.co.uk/web/lib/CDatabase.php(545): CDatabase->do_query(SELECT 1 AS cnt FROM `stocklist` AS st INNER JOIN `makes` AS sm ON st.`makeid`=sm.`id` INNER JOIN `types` AS tt ON st.`typeid`=tt.`id` LEFT JOIN `phl_special_offer` AS spe ON st.`stock_no`=spe.`stock_no` AND spe.`featured`='1' LEFT JOIN `values` AS ex ON st.`stock_no`=ex.`stock_no` AND ex.`fieldid`='92' LEFT JOIN `values` AS lift ON st.`stock_no`=lift.`stock_no` AND lift.`fieldid`='31' LEFT JOIN `values` AS photos ON st.`stock_no`=photos.`stock_no` AND photos.`fieldid` IN (14,98,118,119) LEFT JOIN `values` AS video ON st.`stock_no`=video.`stock_no` AND video.`fieldid`='140' LEFT JOIN `stocklist_categories` AS sc ON sc.`id`=st.`root_category` WHERE st.`stock_status`='Stock' AND sc.`category`= 'VNA' AND lift.value BETWEEN 0 AND 13500∩acity_range=0 GROUP BY st.`stock_no` ORDER BY st.capacity ASC , ) #2 /var/www/phl.co.uk/web/lib/fe/lib.php(549): CDatabase->getCol(SELECT 1 AS cnt FROM `stocklist` AS st INNER JOIN `makes` AS sm ON st.`makeid`=sm.`id` INNER JOIN `types` AS tt ON st.`typeid`=tt.`id` LEFT JOIN `phl_special_offer` AS spe ON st.`stock_no`=spe.`stock_no` AND spe.`featured`='1' LEFT JOIN `values` AS ex ON st.`stock_no`=ex.`stock_no` AND ex.`fieldid`='92' LEFT JOIN `values` AS lift ON st.`stock_no`=lift.`stock_no` AND lift.`fieldid`='31' LEFT JOIN `values` AS photos ON st.`stock_no`=photos.`stock_no` AND photos.`fieldid` IN (14,98,118,119) LEFT JOIN `values` AS video ON st.`stock_no`=video.`stock_no` AND video.`fieldid`='140' LEFT JOIN `stocklist_categories` AS sc ON sc.`id`=st.`root_category` WHERE st.`stock_status`='Stock' AND sc.`category`= 'VNA' AND lift.value BETWEEN 0 AND 13500∩acity_range=0 GROUP BY st.`stock_no` ORDER BY st.capacity ASC ) #3 /var/www/phl.co.uk/web/category_landing_pages.php(123): FEHelper::getPagedList(/vna-forklifts, 12, st.*,ex.`value` AS `extras`,CAST(lift.`value` AS UNSIGNED) AS `liftheight`,CAST(lift.`value` AS UNSIGNED) AS `lift`,st.`euromast` AS `mt`, sm.`make`, video.`value` AS `video`, tt.`type`, spe.`price` AS `discount`, GROUP_CONCAT(DISTINCT photos.`value` ORDER BY photos.`fieldid` SEPARATOR '||') AS `photos` , FROM `stocklist` AS st INNER JOIN `makes` AS sm ON st.`makeid`=sm.`id` INNER JOIN `types` AS tt ON st.`typeid`=tt.`id` LEFT JOIN `phl_special_offer` AS spe ON st.`stock_no`=spe.`stock_no` AND spe.`featured`='1' LEFT JOIN `values` AS ex ON st.`stock_no`=ex.`stock_no` AND ex.`fieldid`='92' LEFT JOIN `values` AS lift ON st.`stock_no`=lift.`stock_no` AND lift.`fieldid`='31' LEFT JOIN `values` AS photos ON st.`stock_no`=photos.`stock_no` AND photos.`fieldid` IN (14,98,118,119) LEFT JOIN `values` AS video ON st.`stock_no`=video.`stock_no` AND video.`fieldid`='140' LEFT JOIN `stocklist_categories` AS sc ON sc.`id`=st.`root_category` WHERE st.`stock_status`='Stock' AND sc.`category`= 'VNA' AND lift.value BETWEEN 0 AND 13500∩acity_range=0 GROUP BY st.`stock_no` ORDER BY st.capacity ASC , FROM `stocklist` AS st INNER JOIN `makes` AS sm ON st.`makeid`=sm.`id` INNER JOIN `types` AS tt ON st.`typeid`=tt.`id` LEFT JOIN `phl_special_offer` AS spe ON st.`stock_no`=spe.`stock_no` AND spe.`featured`='1' LEFT JOIN `values` AS ex ON st.`stock_no`=ex.`stock_no` AND ex.`fieldid`='92' LEFT JOIN `values` AS lift ON st.`stock_no`=lift.`stock_no` AND lift.`fieldid`='31' LEFT JOIN `values` AS photos ON st.`stock_no`=photos.`stock_no` AND photos.`fieldid` IN (14,98,118,119) LEFT JOIN `values` AS video ON st.`stock_no`=video.`stock_no` AND video.`fieldid`='140' WHERE st.`stock_status`='Stock' AND (CAST(lift.`value` AS UNSIGNED) BETWEEN '0' AND '13500' OR ISNULL(lift.`value`)) GROUP BY st.`stock_no` ORDER BY st.`stock_no` ASC) #4 /var/www/phl.co.uk/web/lib/SysUtils.php(6): include(/var/www/phl.co.uk/web/category_landing_pages.php) #5 /var/www/phl.co.uk/web/lib/fe/lib.php(501): ob_include(category_landing_pages.php, Array) #6 /var/www/phl.co.uk/web/lib/fe/lib.php(392): CFECustomPage->getBodyHTML() #7 /var/www/phl.co.uk/web/index.php(124): FrontControler->run() )
Array
LOOP COUNTER=0