Database Error Expression #32 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'advent_db.tbl_categories_languages.clang_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by on SELECT * FROM tbl_products INNER JOIN tbl_productcategorylink ON p_id=pcl_p_id INNER JOIN tbl_categories ON pcl_cat_id=cat_id INNER JOIN tbl_categories_languages ON cat_id=clang_cat_id WHERE p_id = '2675' AND p_live = 'y' AND cat_live = 'y' AND clang_live = 'y' GROUP BY cat_id ORDER BY cat_id DESC LIMIT 1



DEBUG BACKTRACE:
#0 Database.m_error() called at [/home/advent/public_html/classes/db/database.class.php:48]
#1 Database.selectOne() called at [/home/advent/public_html/classes/ecommerce/products.class.php:2337]
#2 Products.sqlGetLiveCatByProdId() called at [/home/advent/public_html/classes/ecommerce/products.class.php:2203]
#3 Products.m_getProductDetailsHref() called at [/home/advent/public_html/classes/ecommerce/products.class.php:145]
#4 Products.getProductDataById() called at [/home/advent/public_html/classes/ecommerce/products.class.php:73]
#5 Products.remeberLastViewedProducts() called at [/home/advent/public_html/classes/parser/skinparser.class.php:327]
#6 SkinParser.produceElement() called at [/home/advent/public_html/classes/parser/generalparser.class.php:139]
#7 GeneralParser.m_produceElement() called at [/home/advent/public_html/classes/parser/generalparser.class.php:26]
#8 GeneralParser.matchCallback() called at [:]
#9 preg_replace_callback() called at [/home/advent/public_html/classes/parser/generalparser.class.php:110]
#10 GeneralParser.parse() called at [/home/advent/public_html/classes/parser/generalparser.class.php:105]
#11 GeneralParser.parseFile() called at [/home/advent/public_html/classes/parser/skinparser.class.php:613]
#12 SkinParser.parseFile() called at [/home/advent/public_html/classes/parser/skinlogic.class.php:109]
#13 SkinLogic.m_parseSkin() called at [/home/advent/public_html/classes/parser/skinlogic.class.php:42]
#14 SkinLogic.produceMarkupDefault() called at [/home/advent/public_html/index.php:12]
#15 include() called at [/home/advent/public_html/clean_url.php:501]

Database Error Expression #23 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'advent_db.tbl_products_languages.plang_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by on SELECT STRAIGHT_JOIN SQL_CALC_FOUND_ROWS * FROM tbl_products INNER JOIN tbl_products_languages ON p_id=plang_p_id INNER JOIN tbl_prodversions ON p_id=pv_p_id LEFT JOIN tbl_productcategorylink ON p_id=pcl_p_id LEFT JOIN tbl_categories ON pcl_cat_id=cat_id LEFT JOIN tbl_categories_languages ON cat_id=clang_cat_id LEFT JOIN tbl_linkproductsbrands ON p_id=lkpbr_p_id LEFT JOIN tbl_brands ON lkpbr_brand_id=brand_id LEFT JOIN tbl_brands_languages ON brand_id=blang_brand_id WHERE p_id='2675' AND plang_language = 'en' AND pv_live = 'yes' and p_live = 'y' and plang_live = 'y' GROUP BY p_id LIMIT 1



DEBUG BACKTRACE:
#0 Database.m_error() called at [/home/advent/public_html/classes/db/database.class.php:48]
#1 Database.selectOne() called at [/home/advent/public_html/classes/ecommerce/products.class.php:2610]
#2 Products.sqlGetProductDetailsById() called at [/home/advent/public_html/classes/ecommerce/products.class.php:542]
#3 Products.items() called at [/home/advent/public_html/classes/common/epaginatedlist.class.php:254]
#4 EPaginatedList.item_sequence() called at [/home/advent/public_html/classes/common/epaginatedlist.class.php:203]
#5 EPaginatedList.item() called at [/home/advent/public_html/classes/parser/skinparser.class.php:327]
#6 SkinParser.produceElement() called at [/home/advent/public_html/classes/parser/generalparser.class.php:139]
#7 GeneralParser.m_produceElement() called at [/home/advent/public_html/classes/parser/generalparser.class.php:26]
#8 GeneralParser.matchCallback() called at [:]
#9 preg_replace_callback() called at [/home/advent/public_html/classes/parser/generalparser.class.php:110]
#10 GeneralParser.parse() called at [/home/advent/public_html/classes/parser/generalparser.class.php:105]
#11 GeneralParser.parseFile() called at [/home/advent/public_html/classes/parser/skinparser.class.php:613]
#12 SkinParser.parseFile() called at [/home/advent/public_html/classes/parser/skinlogic.class.php:109]
#13 SkinLogic.m_parseSkin() called at [/home/advent/public_html/classes/parser/skinlogic.class.php:42]
#14 SkinLogic.produceMarkupDefault() called at [/home/advent/public_html/index.php:12]
#15 include() called at [/home/advent/public_html/clean_url.php:501]

Database Error Expression #23 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'advent_db.tbl_products_languages.plang_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by on SELECT SQL_CALC_FOUND_ROWS * FROM tbl_products INNER JOIN tbl_products_languages ON p_id=plang_p_id INNER JOIN tbl_prodversions ON p_id=pv_p_id INNER JOIN tbl_relatedproductslink ON p_id=lpp_id_son LEFT JOIN tbl_productcategorylink ON p_id=pcl_p_id LEFT JOIN tbl_categories ON pcl_cat_id=cat_id LEFT JOIN tbl_categories_languages ON cat_id=clang_cat_id LEFT JOIN tbl_linkproductsbrands ON p_id=lkpbr_p_id LEFT JOIN tbl_brands ON lkpbr_brand_id=brand_id LEFT JOIN tbl_brands_languages ON brand_id=blang_brand_id LEFT JOIN tbl_linkfiles ON plang_id=lf_id AND lf_table='tbl_products_languages' LEFT JOIN tbl_files ON lf_file_id=file_id WHERE (lf_id IS NULL AND file_nameid IS NULL OR file_nameid='plang_main_picture_') AND lpp_id_parent='2675' AND plang_language = '' AND pv_live='yes' AND p_live='y' AND plang_live='y' GROUP BY p_id ORDER BY plang_orderbyvalue DESC LIMIT 0,3



DEBUG BACKTRACE:
#0 NewDatabase.m_error() called at [/home/advent/public_html/classes/db/newdatabase.class.php:81]
#1 NewDatabase.selectMany() called at [/home/advent/public_html/classes/db/newdatabase.class.php:94]
#2 NewDatabase.selectManyGetNr() called at [/home/advent/public_html/classes/ecommerce/products.class.php:2955]
#3 Products.sqlGetRelatedProductsByProductIdGetNr() called at [/home/advent/public_html/classes/ecommerce/products.class.php:471]
#4 Products.items() called at [/home/advent/public_html/classes/common/epaginatedlist.class.php:254]
#5 EPaginatedList.item_sequence() called at [/home/advent/public_html/classes/common/epaginatedlist.class.php:203]
#6 EPaginatedList.item() called at [/home/advent/public_html/classes/parser/skinparser.class.php:327]
#7 SkinParser.produceElement() called at [/home/advent/public_html/classes/parser/generalparser.class.php:139]
#8 GeneralParser.m_produceElement() called at [/home/advent/public_html/classes/parser/generalparser.class.php:26]
#9 GeneralParser.matchCallback() called at [:]
#10 preg_replace_callback() called at [/home/advent/public_html/classes/parser/generalparser.class.php:110]
#11 GeneralParser.parse() called at [/home/advent/public_html/classes/parser/generalparser.class.php:71]
#12 GeneralParser.staticElement() called at [/home/advent/public_html/classes/parser/generalparser.class.php:29]
#13 GeneralParser.matchCallback() called at [:]
#14 preg_replace_callback() called at [/home/advent/public_html/classes/parser/generalparser.class.php:110]
#15 GeneralParser.parse() called at [/home/advent/public_html/classes/parser/generalparser.class.php:105]
#16 GeneralParser.parseFile() called at [/home/advent/public_html/classes/parser/skinparser.class.php:613]
#17 SkinParser.parseFile() called at [/home/advent/public_html/classes/parser/skinlogic.class.php:109]
#18 SkinLogic.m_parseSkin() called at [/home/advent/public_html/classes/parser/skinlogic.class.php:42]
#19 SkinLogic.produceMarkupDefault() called at [/home/advent/public_html/index.php:12]
#20 include() called at [/home/advent/public_html/clean_url.php:501]
Adventino
skip to navigation

The products or page you are trying to view does not exist. Please call us on 01529 307812 or email for further information.