Warning: mysqli::query(): (42S22/1054): Unknown column 'p.date_available' in 'WHERE' in /var/www/vhosts/safetysignsandnotices.uk/httpdocs/system/library/db/mysqli.php on line 25
Fatal error: Uncaught Exception: Error: Unknown column 'p.date_available' in 'WHERE'<br />Error No: 1054<br />SELECT COUNT(DISTINCT ps.product_id) AS total FROM oc_product_special ps LEFT JOIN oc_product p ON (ps.product_id = p.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '1' AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) in /var/www/vhosts/safetysignsandnotices.uk/httpdocs/system/library/db/mysqli.php:49 Stack trace: #0 /var/www/vhosts/safetysignsandnotices.uk/httpdocs/system/library/db.php(45): DB\MySQLi->query() #1 /var/www/vhosts/safetysignsandnotices.uk/httpdocs/catalog/model/catalog/product.php(604): DB->query() #2 /var/www/vhosts/safetysignsandnotices.uk/httpdocs/system/engine/loader.php(248): ModelCatalogProduct->getTotalProductSpecials() #3 /var/www/vhosts/safetysignsandnotices.uk/httpdocs/system/engine/proxy.php(47): Loader->{closure}() #4 /var/www/vhosts/safetysignsandnotices.uk/httpdocs/catalog/controller/product/special.php(79): Proxy->__call() #5 /var/www/vhosts/safetysignsandnotices.uk/httpdocs/system/engine/action.php(79): ControllerProductSpecial->index() #6 /var/www/vhosts/safetysignsandnotices.uk/httpdocs/catalog/controller/startup/router.php(25): Action->execute() #7 /var/www/vhosts/safetysignsandnotices.uk/httpdocs/system/engine/action.php(79): ControllerStartupRouter->index() #8 /var/www/vhosts/safetysignsandnotices.uk/httpdocs/system/engine/router.php(67): Action->execute() #9 /var/www/vhosts/safetysignsandnotices.uk/httpdocs/system/engine/router.php(56): Router->execute() #10 /var/www/vhosts/safetysignsandnotices.uk/httpdocs/system/framework.php(178): Router->dispatch() #11 /var/www/vhosts/safetysignsandnotices.uk/httpdocs/system/startup.php(104): require_once('...') #12 /var/www/vhosts/safetysignsandnotices.uk/httpdocs/index.php(21): start() #13 {main} thrown in /var/www/vhosts/safetysignsandnotices.uk/httpdocs/system/library/db/mysqli.php on line 49