One of the modules which works fine under PHP 7.3 now gives me this error in 7.4:
Any idea how to resolve this?
ThirtyBeesDatabaseException
Unknown column 'pps.id_shop' in 'field list'
in file /home/librairiezbookstore.com/public_html/modules/ets_abandonedcart/controllers/admin/AdminEtsACDashboardController.php at line 256
SQL
SELECT SUM((tmp.price + tmp.attribute_price)* pcp.quantity)
FROM `tb_cart` c
LEFT JOIN `tb_cart_product` pcp ON pcp.id_cart = c.id_cart
LEFT JOIN (
SELECT p.id_product
, pps.id_shop
, pps.`price`
, pps.`ecotax`
, 0 as id_product_attribute, 0 as attribute_price
FROM `tb_product` p
) as tmp ON (pcp.id_product = tmp.id_product AND pcp.id_product_attribute = tmp.id_product_attribute AND tmp.id_shop = c.id_shop)
LEFT JOIN `tb_ets_abancart_tracking` eat ON (eat.id_cart = c.id_cart)
WHERE c.id_shop = 1 AND (eat.id_cart is NOT NULL OR eat.id_cart > 0) LIMIT 1
797:798: if (! is_array($result)) {
799: $result = false;
800: }
801:802: return $result;
803: }
804:805: /**
806: * Returns a value from the first row, first column of a SELECT query
807: *
808: * @param string|DbQuery $sql
809: * @param bool $useCache Deprecated, the internal query cache is no longer used
810: *
811: * @return mixed
812: * @throws PrestaShopException
813: */
814: public function getValue($sql, $useCache = true)
815: {
816: if (!$result = $this->getRow($sql, $useCache)) {
817: return false;
818: }
819:820: return array_shift($result);
821: }
822:823: /**
824: * Get number of rows for last result
825: *
826: * @return int
Question
movieseals
Hi!
I am testing TB 1.4 using PHP 7.4.
One of the modules which works fine under PHP 7.3 now gives me this error in 7.4:
Any idea how to resolve this?
Unknown column 'pps.id_shop' in 'field list'
SQL
Source file: /home/librairiezbookstore.com/public_html/modules/ets_abandonedcart/controllers/admin/AdminEtsACDashboardController.php
Stack trace
Link to comment
Share on other sites
2 answers to this question
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now