People Also Bought
A Database Error Occurred
Error Number: 1055
Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'ringshe_database.vo.option_name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SELECT p.pname, vt.name AS variant_type, vo.option_name AS variant_option_name, vo.option_description AS variant_option_description, pvc.id as pvcid, pvc.price, pvc.final_price, pvc.offer, pvc.stock, pvc.store_stock, pvc.sku, pvc.status AS combination_status, pvm.variant_type_id as vtid FROM product_variant_mappings pvm JOIN product p ON p.id = pvm.product_id JOIN variant_types vt ON pvm.variant_type_id = vt.id JOIN variant_options vo ON vo.variant_type_id = vt.id JOIN product_variant_combinations pvc ON pvc.product_id = pvm.product_id JOIN product_variant_details pvd ON pvd.combination_id = pvc.id WHERE pvm.product_id = '136' AND vt.name = 'Ring Size' AND vo.id = pvd.variant_option_id GROUP BY pvc.id ORDER BY vt.display_order, vo.display_order
Filename: views/Home/details.php
Line Number: 652