Fatal error: Uncaught Dibi\DriverException: Unknown column 'esp.our_price_chf' in 'field list' in /var/www/reifenlab.eu/www/vendor/dibi/dibi/src/Dibi/Drivers/MySqliDriver.php:177
Stack trace:
#0 /var/www/reifenlab.eu/www/vendor/dibi/dibi/src/Dibi/Drivers/MySqliDriver.php(152): Dibi\Drivers\MySqliDriver::createException()
#1 /var/www/reifenlab.eu/www/vendor/dibi/dibi/src/Dibi/Connection.php(288): Dibi\Drivers\MySqliDriver->query()
#2 /var/www/reifenlab.eu/www/vendor/dibi/dibi/src/Dibi/Connection.php(223): Dibi\Connection->nativeQuery()
#3 /var/www/reifenlab.eu/www/src/pages/ecommerce/fce/fce_prices.php(182): Dibi\Connection->query()
#4 /var/www/reifenlab.eu/www/src/pages/ecommerce/fce/fce_products_suppliers.php(31): getTyrePrice()
#5 /var/www/reifenlab.eu/www/src/pages/ecommerce/fce/fce_product.php(54): getProductByEAN()
#6 /var/www/reifenlab.eu/www/src/pages/ecommerce/product/product_intro_functions.php(47): getProductPageData()
#7 /var/www/reifenlab.eu/www/src/pages/ecommerce/product.php(30): include_once('...')
#8 /var/www/reifenlab.eu/www/src/pages/router_shop.php(450): include('...')
#9 /var/www/reifenlab.eu/www/router.php(67): include('...')
#10 /var/www/reifenlab.eu/www/index.php(6): include('...')
#11 {main}
SQL:
SELECT
esp.`our_price_chf` as base_price,
esp.`our_price_with_tax_chf` as price_with_tax,
CASE WHEN 0 = 1 THEN 0 ELSE
CASE
WHEN 'de' = 'cz' THEN esp.supplier_shipping_price_cz_czk
WHEN 'de' = 'sk' THEN esp.supplier_shipping_price_sk_czk
WHEN 'de' = 'de' THEN esp.supplier_shipping_price_de_czk
WHEN 'de' = 'pl' THEN esp.supplier_shipping_price_pl_czk
WHEN 'de' = 'hu' THEN esp.supplier_shipping_price_hu_czk
WHEN 'de' = 'fr' THEN esp.supplier_shipping_price_fr_czk
ELSE esp.supplier_shipping_price_cz_czk
END
END as shipping_cost,
esp.quantity,
esp.supplier_id,
esp.supplier_inner_id,
esp.currency as supplier_currency,
esp.supplier_tyre_full_name,
esp.demo,
s.name as supplier_name,
s.full_name as supplier_full_name
FROM ecommerce_supplier_products esp
JOIN ecommerce_suppliers s ON esp.supplier_id = s.id
WHERE esp.ean = '3528705023881'
AND esp.quantity > 0
AND s.active = 1
AND esp.`our_price_chf` > 0
AND esp.`our_price_with_tax_chf` > 0 AND (esp.dot_year IS NULL OR esp.dot_year = 0 OR esp.dot_year = '')
ORDER BY (esp.`our_price_with_tax_chf` +
CASE WHEN 0 = 1 THEN 0 ELSE
CASE
WHEN 'de' = 'cz' THEN esp.supplier_shipping_price_cz_czk
WHEN 'de' = 'sk' THEN esp.supplier_shipping_price_sk_czk
WHEN 'de' = 'de' THEN esp.supplier_shipping_price_de_czk
WHEN 'de' = 'pl' THEN esp.supplier_shipping_price_pl_czk
WHEN 'de' = 'hu' THEN esp.supplier_shipping_price_hu_czk
WHEN 'de' = 'fr' THEN esp.supplier_shipping_price_fr_czk
ELSE esp.supplier_shipping_price_cz_czk
END
END) ASC
LIMIT 1
thrown in /var/www/reifenlab.eu/www/vendor/dibi/dibi/src/Dibi/Drivers/MySqliDriver.php on line 177