Notice: Undefined index: pl in /home/caddo/public_html/caddo/application/gekosale/core.class.php on line 171
Notice: Undefined index: photoid in /home/caddo/public_html/caddo/application/gekosale/router.class.php on line 270
Notice: Undefined index: photoid in /home/caddo/public_html/caddo/application/gekosale/router.class.php on line 271
Notice: Undefined index: favicon in /home/caddo/public_html/caddo/application/gekosale/router.class.php on line 278
Notice: Undefined index: faceboookappid in /home/caddo/public_html/caddo/application/gekosale/router.class.php on line 279
Notice: Undefined index: enableregistration in /home/caddo/public_html/caddo/application/gekosale/router.class.php on line 280
Notice: Undefined index: gacode in /home/caddo/public_html/caddo/application/gekosale/router.class.php on line 294
Notice: Undefined index: gapages in /home/caddo/public_html/caddo/application/gekosale/router.class.php on line 295
Notice: Undefined index: gatransactions in /home/caddo/public_html/caddo/application/gekosale/router.class.php on line 296
Notice: Undefined index: enablerating in /home/caddo/public_html/caddo/application/gekosale/router.class.php on line 297
Notice: Undefined index: enableopinions in /home/caddo/public_html/caddo/application/gekosale/router.class.php on line 298
Notice: Undefined index: enabletags in /home/caddo/public_html/caddo/application/gekosale/router.class.php on line 299
Notice: Undefined index: confirmorder in /home/caddo/public_html/caddo/application/gekosale/router.class.php on line 300
Notice: Undefined index: enablerss in /home/caddo/public_html/caddo/application/gekosale/router.class.php on line 301
Notice: Undefined index: catalogmode in /home/caddo/public_html/caddo/application/gekosale/router.class.php on line 302
Notice: Undefined index: cartredirect in /home/caddo/public_html/caddo/application/gekosale/router.class.php on line 304
Could not execute query [Native Error: Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'caddo_expresbud.CT.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by] [User Info:
SELECT
C.idcategory AS id,
C.categoryid AS parent,
C.photoid,
CT.name AS label,
CT.description,
CT.shortdescription,
CT.seo,
COUNT(DISTINCT PC.productid) AS totalproducts
FROM
category C
INNER JOIN viewcategory CV ON CV.categoryid = idcategory
LEFT JOIN categorytranslation CT ON C.idcategory = CT.categoryid AND CT.languageid = NULL
LEFT JOIN categorypath CP ON CP.ancestorcategoryid = C.idcategory
LEFT JOIN productcategory PC ON CP.categoryid = PC.categoryid AND PC.categoryid IN (SELECT categoryid FROM viewcategory WHERE viewid = 0)
LEFT JOIN product P ON P.idproduct = PC.productid
LEFT JOIN producerview PV ON PV.producerid = P.producerid
WHERE
CV.viewid = 0 AND C.enable = 1
AND IF(P.producerid IS NOT NULL, PV.viewid = 0, 1) AND
P.enable = 1
GROUP BY id ORDER BY C.distinction ASC
]
Warning: session_write_close(): Session callback expects true/false return value in Unknown on line 0
Warning: session_write_close(): Failed to write session data (user). Please verify that the current setting of session.save_path is correct (/opt/alt/php44/var/lib/php/session) in Unknown on line 0