1525 - Incorrect DATE value: '0000-00-00'
select sale_specials_condition, sale_deduction_value, sale_deduction_type, sale_categories_all, sale_pricerange_from, sale_pricerange_to from salemaker_sales where sale_status = '1' and groups_id = '0' and (sale_date_start <= now() or sale_date_start = '0000-00-00') and (sale_deduction_value > 0) and (sale_date_end >= now() or sale_date_end = '0000-00-00')
Filename: /includes/functions/specials.php Line: 22
3065 - Expression #1 of ORDER BY clause is not in SELECT list, references column 'qmbugtmu_lallabnew.prp.sort_order' which is not in SELECT list; this is incompatible with DISTINCT
SELECT distinct prp.properties_id, prp.properties_type, p2p.set_value, prd.properties_name FROM properties_to_products p2p, properties prp, properties_description prd WHERE p2p.products_id IN ('10069','10070','10071') and p2p.properties_id = prp.properties_id AND prp.mode LIKE '%filter%' AND prp.properties_type IN ( 0, 2, 3, 4 ) AND p2p.set_value <> '' AND prd.properties_id=prp.properties_id AND prd.language_id ='1' AND p2p.language_id ='1' ORDER BY prp.sort_order, prp.properties_id, p2p.set_value
Filename: /templates/creator/content/index_products.tpl.php Line: 161
|