SELECT
p.id,
p.timestamp,
IFNULL(rc.id, p.idTC) as idtc,
p.price as typePrice,
IFNULL(rc.price+rc.ecotax, p.price)+0 AS price,
IFNULL(rc.price2, p.price2)+0 AS price2,
p.unite,
rc.unite as uniteRef,
p.idTVA,
p.contrainteProduit,
p.ean,
IF(p.warranty='', a.warranty, p.warranty) AS warranty,
IF(pfr.delai_livraison='', a.delai_livraison, pfr.delai_livraison) AS delivery_time,
p.title_tag,
p.meta_desc_tag,
p.shipping_fee,
p.video_code,
p.docs,
p.price_microdata,
pfr.name,
pfr.ref_name,
pfr.active,
(SELECT COUNT(id) FROM products_fr WHERE ref_name = pfr.ref_name) AS same_ref_name_count,
pfr.alias,
pfr.fastdesc,
pfr.descc,
pfr.descd,
pfr.deleted,
pfr.google_text,
pfr.unavailable,
pfr.q_mkt_desc,
pfr.title_keyword_1,
pfr.title_keyword_2,
ffr3.id AS cat3_id,
ffr3.ref_name AS cat3_ref_name,
ffr3.name AS cat3_name,
ffr2.id AS cat2_id,
ffr2.ref_name AS cat2_ref_name,
ffr2.name AS cat2_name,
ffr1.id AS cat1_id,
ffr1.ref_name AS cat1_ref_name,
ffr1.name AS cat1_name,
(SELECT GROUP_CONCAT(CONCAT(idFamily) ORDER BY orderFamily ASC) FROM products_families WHERE idProduct = p.id) AS cat3_ids,
a.id AS adv_id,
a.nom1 AS adv_name,
a.category AS adv_cat,
a.help_show AS adv_help_show,
a.help_msg AS adv_help_msg,
a.catalog_code AS adv_catalog_code,
a.idCommercial,
a.actif AS adv_active,
a.display_logo,
a.logo,
IF(a.contraintePrix>0 AND IFNULL(rc.price2, p.price2)>0, a.contraintePrix, 0) AS adv_min_amount,
IFNULL(rc.price, p.price) > 0 AS hasPrice,
IFNULL(rc.price, p.price) > 0 AND a.category = 1 AS saleable,
IF(IFNULL(rc.price+rc.ecotax, p.price) < fdp.fdp_franco, fdp.fdp, 0) AS fdp,
(p.as_estimate + a.as_estimate) as product_as_estimate,
pdt_desc.description as product_description
FROM products p
INNER JOIN products_fr pfr ON p.id = pfr.id
INNER JOIN advertisers a ON p.idAdvertiser = a.id
LEFT JOIN references_content rc ON p.id = rc.idProduct AND rc.classement = 1 AND rc.vpc = 1 AND rc.deleted = 0
LEFT JOIN families_fr ffr3 ON ffr3.id = 4350
LEFT JOIN families f3 ON f3.id = ffr3.id
LEFT JOIN families_fr ffr2 ON ffr2.id = f3.idParent
LEFT JOIN families f2 ON f2.id = ffr2.id
LEFT JOIN families_fr ffr1 ON ffr1.id = f2.idParent
LEFT JOIN products_fr_accessories_description pdt_desc ON p.id = pdt_desc.product_id
STRAIGHT_JOIN (
SELECT
SUM(IF(config_name='fdp', config_value, 0)) AS fdp,
SUM(IF(config_name='fdp_franco', config_value, 0)) AS fdp_franco
FROM config
WHERE config_name IN ('fdp', 'fdp_franco')
) fdp
WHERE p.id = 4143233
( ! ) Warning: mysqli_error() expects exactly 1 parameter, 0 given in /data/technico/includes/fr/classV3/CDBHandle.php on line 73 |
Call Stack |
# | Time | Memory | Function | Location |
1 | 0.0000 | 414680 | {main}( ) | .../product.html:0 |
2 | 0.0751 | 994152 | DBHandle->query( $query = '\n SELECT\n p.id,\n p.timestamp,\n IFNULL(rc.id, p.idTC) as idtc,\n\tp.price as typePrice,\n IFNULL(rc.price+rc.ecotax, p.price)+0 AS price,\n IFNULL(rc.price2, p.price2)+0 AS price2,\n p.unite,\n\trc.unite as uniteRef,\n p.idTVA,\n p.contrainteProduit,\n p.ean,\n IF(p.warranty=\'\', a.warranty, p.warranty) AS warranty,\n IF(pfr.delai_livraison=\'\', a.delai_livraison, pfr.delai_livraison) AS delivery_time,\n p.title_tag,\n p.meta_desc_tag,\n p.shipping_fee,\n p', $file = '/data/technico/www/fr/product.html', $line = 265 ) | .../product.html:265 |
3 | 0.0775 | 997272 | mysqli_error
( ) | .../CDBHandle.php:73 |
( ! ) Fatal error: Uncaught Exception: [2025-08-28 14:39:09]
SELECT
p.id,
p.timestamp,
IFNULL(rc.id, p.idTC) as idtc,
p.price as typePrice,
IFNULL(rc.price+rc.ecotax, p.price)+0 AS price,
IFNULL(rc.price2, p.price2)+0 AS price2,
p.unite,
rc.unite as uniteRef,
p.idTVA,
p.contrainteProduit,
p.ean,
IF(p.warranty='', a.warranty, p.warranty) AS warranty,
IF(pfr.delai_livraison='', a.delai_livraison, pfr.delai_livraison) AS delivery_time,
p.title_tag,
p.meta_desc_tag,
p.shipping_fee,
p.video_code,
p.docs,
p.price_microdata,
pfr.name,
pfr.ref_name,
pfr.active,
(SELECT COUNT(id) FROM products_fr WHERE ref_name = pfr.ref_name) AS same_ref_name_count,
pfr.alias,
pfr.fastdesc,
pfr.descc,
pfr.descd,
pfr.deleted,
pfr.google_text,
pfr.unavailable,
pfr.q_mkt_desc,
pfr.title_keyword_1,
pfr.title_keyword_2,
ffr3.id AS cat3_id,
ffr3.ref_name AS cat3_ref_name,
ffr3.name AS cat3_name,
ffr2.id AS cat2_id,
ff in /data/technico/includes/fr/classV3/CDBHandle.php on line 75 |
( ! ) Exception: [2025-08-28 14:39:09]
SELECT
p.id,
p.timestamp,
IFNULL(rc.id, p.idTC) as idtc,
p.price as typePrice,
IFNULL(rc.price+rc.ecotax, p.price)+0 AS price,
IFNULL(rc.price2, p.price2)+0 AS price2,
p.unite,
rc.unite as uniteRef,
p.idTVA,
p.contrainteProduit,
p.ean,
IF(p.warranty='', a.warranty, p.warranty) AS warranty,
IF(pfr.delai_livraison='', a.delai_livraison, pfr.delai_livraison) AS delivery_time,
p.title_tag,
p.meta_desc_tag,
p.shipping_fee,
p.video_code,
p.docs,
p.price_microdata,
pfr.name,
pfr.ref_name,
pfr.active,
(SELECT COUNT(id) FROM products_fr WHERE ref_name = pfr.ref_name) AS same_ref_name_count,
pfr.alias,
pfr.fastdesc,
pfr.descc,
pfr.descd,
pfr.deleted,
pfr.google_text,
pfr.unavailable,
pfr.q_mkt_desc,
pfr.title_keyword_1,
pfr.title_keyword_2,
ffr3.id AS cat3_id,
ffr3.ref_name AS cat3_ref_name,
ffr3.name AS cat3_name,
ffr2.id AS cat2_id,
ffr2.ref_name AS cat2_ref_name,
ffr2.name AS cat2_name,
ffr1.id AS cat1_id,
ffr1.ref_name AS cat1_ref_name,
ffr1.name AS cat1_name,
(SELECT GROUP_CONCAT(CONCAT(idFamily) ORDER BY orderFamily ASC) FROM products_families WHERE idProduct = p.id) AS cat3_ids,
a.id AS adv_id,
a.nom1 AS adv_name,
a.category AS adv_cat,
a.help_show AS adv_help_show,
a.help_msg AS adv_help_msg,
a.catalog_code AS adv_catalog_code,
a.idCommercial,
a.actif AS adv_active,
a.display_logo,
a.logo,
IF(a.contraintePrix>0 AND IFNULL(rc.price2, p.price2)>0, a.contraintePrix, 0) AS adv_min_amount,
IFNULL(rc.price, p.price) > 0 AS hasPrice,
IFNULL(rc.price, p.price) > 0 AND a.category = 1 AS saleable,
IF(IFNULL(rc.price+rc.ecotax, p.price) < fdp.fdp_franco, fdp.fdp, 0) AS fdp,
(p.as_estimate + a.as_estimate) as product_as_estimate,
pdt_desc.description as product_description
FROM products p
INNER JOIN products_fr pfr ON p.id = pfr.id
INNER JOIN advertisers a ON p.idAdvertiser = a.id
LEFT JOIN references_content rc ON p.id = rc.idProduct AND rc.classement = 1 AND rc.vpc = 1 AND rc.deleted = 0
LEFT JOIN families_fr ffr3 ON ffr3.id = 4350
LEFT JOIN families f3 ON f3.id = ffr3.id
LEFT JOIN families_fr ffr2 ON ffr2.id = f3.idParent
LEFT JOIN families f2 ON f2.id = ffr2.id
LEFT JOIN families_fr ffr1 ON ffr1.id = f2.idParent
LEFT JOIN products_fr_accessories_description pdt_desc ON p.id = pdt_desc.product_id
STRAIGHT_JOIN (
SELECT
SUM(IF(config_name='fdp', config_value, 0)) AS fdp,
SUM(IF(config_name='fdp_franco', config_value, 0)) AS fdp_franco
FROM config
WHERE config_name IN ('fdp', 'fdp_franco')
) fdp
WHERE p.id = 4143233 => - Fichier : /data/technico/www/fr/product.html - Ligne : 265 in /data/technico/includes/fr/classV3/CDBHandle.php on line 75 |
Call Stack |
# | Time | Memory | Function | Location |
1 | 0.0000 | 414680 | {main}( ) | .../product.html:0 |
2 | 0.0751 | 994152 | DBHandle->query( $query = '\n SELECT\n p.id,\n p.timestamp,\n IFNULL(rc.id, p.idTC) as idtc,\n\tp.price as typePrice,\n IFNULL(rc.price+rc.ecotax, p.price)+0 AS price,\n IFNULL(rc.price2, p.price2)+0 AS price2,\n p.unite,\n\trc.unite as uniteRef,\n p.idTVA,\n p.contrainteProduit,\n p.ean,\n IF(p.warranty=\'\', a.warranty, p.warranty) AS warranty,\n IF(pfr.delai_livraison=\'\', a.delai_livraison, pfr.delai_livraison) AS delivery_time,\n p.title_tag,\n p.meta_desc_tag,\n p.shipping_fee,\n p', $file = '/data/technico/www/fr/product.html', $line = 265 ) | .../product.html:265 |