Fatal error: Uncaught PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'oakparquetflooring.product_manifacturers_list' doesn't exist in /home/sites/cms/vendor/zf1/zend-db/library/Zend/Db/Statement/Pdo.php:235
Stack trace:
#0 /home/sites/cms/vendor/zf1/zend-db/library/Zend/Db/Statement/Pdo.php(235): PDOStatement->execute()
#1 /home/sites/cms/vendor/zf1/zend-db/library/Zend/Db/Statement.php(303): Zend_Db_Statement_Pdo->_execute()
#2 /home/sites/cms/vendor/zf1/zend-db/library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute()
#3 /home/sites/cms/vendor/zf1/zend-db/library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query()
#4 /home/sites/cms/vendor/zf1/zend-db/library/Zend/Db/Adapter/Abstract.php(737): Zend_Db_Adapter_Pdo_Abstract->query()
#5 /home/sites/cms/vendor/libraries/DbConnection.php(93): Zend_Db_Adapter_Abstract->fetchAll()
#6 /home/sites/cms/src/Factory/DatabaseFactory.php(44): DbConnection->queryAll()
#7 /home/sites/cms/browse.php(682): FSC\Factory\DatabaseFactory->queryAll()
#8 /home/sites/oakparquetflooring.co.uk/web/live/index.php(272): require_once('...')
#9 {main}
Next Zend_Db_Statement_Exception: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'oakparquetflooring.product_manifacturers_list' doesn't exist, query was: SELECT
SQL_CALC_FOUND_ROWS
distinct(P.id), P.product_range_id, P.description, PC.name as cat_name,
IF(P.unit_size <=0, 1, P.unit_size) as unit_size, P.name, P.price_on_request,
IF(P.product_range_id IN('1','2', '4'),(PP.value/P.unit_size),PP.value) as price,
PP.value as total_price,
IF(P.product_range_id IN('1','2', '4'),(PP1.value/P.unit_size),PP1.value) as old_price,
PP1.value as old_total_price,
PUT.unit as unit, PPT.name as package_name, PML.name as manifacturer_name,
MIN(CASE WHEN IF1.file_type = 'i' AND IF1.status = 1 THEN IF1.filename END) as images,
COUNT(DISTINCT CASE WHEN IF2.file_type = 'i' AND IF2.status = 1 THEN IF2.id END) as total_images
FROM products as P
LEFT JOIN product_categories AS PC ON P.category_id=PC.id
LEFT JOIN product_specification_lines AS PSL ON PSL.inventory_id = P.id
LEFT JOIN product_prices AS PP1 ON P.id=PP1.inventory_id AND PP1.market_id='6' AND (PP1.channels IS NULL OR PP1.channels = '' OR PP1.channels LIKE '%[26]%')
LEFT JOIN product_unit_types_list AS PUT ON PUT.id=P.unit_type_id
LEFT JOIN product_package_types_list AS PPT ON PPT.id=P.package_type_id
LEFT JOIN product_manifacturers_list AS PML ON PML.id=P.manifacturer_id
LEFT JOIN inventory_files IF1 ON IF1.owner_id = P.id AND IF1.file_type = 'i' AND IF1.status = 1 AND IF1.priority = (SELECT MIN(priority) FROM inventory_files WHERE owner_id = P.id AND file_type = 'i' AND status = 1)
LEFT JOIN inventory_files IF2 ON IF2.owner_id = P.id AND IF2.file_type = 'i' AND IF2.status = 1
LEFT JOIN product_prices AS PP ON P.id=PP.inventory_id
WHERE PP.market_id='11'
AND P.product_status='1' AND P.time_deleted = 0 AND P.id IN (6529,6530,7290,7292,7297,14730,14733,14776)
GROUP BY P.id
HAVING price > 0
ORDER BY P.rating DESC LIMIT 25 in /home/sites/cms/vendor/zf1/zend-db/library/Zend/Db/Statement/Pdo.php:242
Stack trace:
#0 /home/sites/cms/vendor/zf1/zend-db/library/Zend/Db/Statement.php(303): Zend_Db_Statement_Pdo->_execute()
#1 /home/sites/cms/vendor/zf1/zend-db/library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute()
#2 /home/sites/cms/vendor/zf1/zend-db/library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query()
#3 /home/sites/cms/vendor/zf1/zend-db/library/Zend/Db/Adapter/Abstract.php(737): Zend_Db_Adapter_Pdo_Abstract->query()
#4 /home/sites/cms/vendor/libraries/DbConnection.php(93): Zend_Db_Adapter_Abstract->fetchAll()
#5 /home/sites/cms/src/Factory/DatabaseFactory.php(44): DbConnection->queryAll()
#6 /home/sites/cms/browse.php(682): FSC\Factory\DatabaseFactory->queryAll()
#7 /home/sites/oakparquetflooring.co.uk/web/live/index.php(272): require_once('...')
#8 {main}
thrown in /home/sites/cms/vendor/zf1/zend-db/library/Zend/Db/Statement/Pdo.php on line 242