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 *, MATCH(`plang_name`) AGAINST ('LSA') + MATCH(`plang_desc`) AGAINST ('LSA') + MATCH(`plang_strapline`) AGAINST ('LSA') + MATCH(`plang_information`) AGAINST ('LSA') AS `score` FROM `tbl_products` INNER JOIN `tbl_products_languages` ON `plang_p_id` = `p_id` INNER JOIN `tbl_linkfiles` ON `plang_id` = `lf_id` AND `lf_table` = 'tbl_products_languages' INNER JOIN `tbl_files` ON `lf_file_id` = `file_id` AND `file_nameid` = 'plang_main_picture_' WHERE MATCH(`plang_name`, `plang_desc`, `plang_strapline`, `plang_information`) AGAINST ('LSA' IN BOOLEAN MODE) AND `p_live` = 'y' AND `plang_live` = 'y' GROUP BY `p_id` ORDER BY `score` DESC LIMIT 0,12



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:2778]
#3 Products.sqlGetProductsBySearchStringGetNr() called at [/home/advent/public_html/classes/ecommerce/products.class.php:499]
#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:14]
#6 EPaginatedList.prepareItems() 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:105]
#12 GeneralParser.parseFile() called at [/home/advent/public_html/classes/parser/skinparser.class.php:613]
#13 SkinParser.parseFile() called at [/home/advent/public_html/classes/parser/skinparser.class.php:495]
#14 SkinParser.produceElement() called at [/home/advent/public_html/classes/parser/generalparser.class.php:139]
#15 GeneralParser.m_produceElement() called at [/home/advent/public_html/classes/parser/generalparser.class.php:26]
#16 GeneralParser.matchCallback() called at [:]
#17 preg_replace_callback() called at [/home/advent/public_html/classes/parser/generalparser.class.php:110]
#18 GeneralParser.parse() called at [/home/advent/public_html/classes/parser/generalparser.class.php:105]
#19 GeneralParser.parseFile() called at [/home/advent/public_html/classes/parser/skinparser.class.php:613]
#20 SkinParser.parseFile() called at [/home/advent/public_html/classes/parser/skinlogic.class.php:109]
#21 SkinLogic.m_parseSkin() called at [/home/advent/public_html/classes/parser/skinlogic.class.php:42]
#22 SkinLogic.produceMarkupDefault() called at [/home/advent/public_html/index.php:12]
#23 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 STRAIGHT_JOIN *,cl1.clang_name as cat_name1, cl2.clang_name as cat_name2 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 c1 ON pcl_cat_id=c1.cat_id LEFT JOIN tbl_categories_languages cl1 ON c1.cat_id=cl1.clang_cat_id LEFT JOIN tbl_categories c2 ON c1.cat_mothercat=c2.cat_id LEFT JOIN tbl_categories_languages cl2 ON c2.cat_id=cl2.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 (plang_name LIKE '%LSA%') AND plang_language = '' AND pv_live = 'yes' AND p_live = 'y' AND plang_live = 'y' GROUP BY p_id ORDER BY p_id DESC LIMIT 0,12



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:2828]
#3 Products.sqlGetProductsBySearchStringGetNr() called at [/home/advent/public_html/classes/ecommerce/products.class.php:499]
#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:14]
#6 EPaginatedList.prepareItems() 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:105]
#12 GeneralParser.parseFile() called at [/home/advent/public_html/classes/parser/skinparser.class.php:613]
#13 SkinParser.parseFile() called at [/home/advent/public_html/classes/parser/skinparser.class.php:495]
#14 SkinParser.produceElement() called at [/home/advent/public_html/classes/parser/generalparser.class.php:139]
#15 GeneralParser.m_produceElement() called at [/home/advent/public_html/classes/parser/generalparser.class.php:26]
#16 GeneralParser.matchCallback() called at [:]
#17 preg_replace_callback() called at [/home/advent/public_html/classes/parser/generalparser.class.php:110]
#18 GeneralParser.parse() called at [/home/advent/public_html/classes/parser/generalparser.class.php:105]
#19 GeneralParser.parseFile() called at [/home/advent/public_html/classes/parser/skinparser.class.php:613]
#20 SkinParser.parseFile() called at [/home/advent/public_html/classes/parser/skinlogic.class.php:109]
#21 SkinLogic.m_parseSkin() called at [/home/advent/public_html/classes/parser/skinlogic.class.php:42]
#22 SkinLogic.produceMarkupDefault() called at [/home/advent/public_html/index.php:12]
#23 include() called at [/home/advent/public_html/clean_url.php:501]
Adventino
skip to navigation

Search results for 'LSA'


No products found.