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 = '1238' 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='1238' 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='1238' 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]
Paris Stone Embroidered Cotton Quilt
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.