The Note, DVD

user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'weight' at line 13 query: SELECT d.* FROM uc_discounts d LEFT JOIN uc_discounts_products dp ON d.discount_id=dp.discount_id LEFT JOIN uc_discounts_terms dt ON d.discount_id=dt.discount_id LEFT JOIN uc_discounts_skus ds ON d.discount_id=ds.discount_id LEFT JOIN uc_discounts_classes dcl ON d.discount_id=dcl.discount_id WHERE d.requires_code=0 AND (d.has_role_filter=0 OR d.discount_id IN(SELECT dr.discount_id FROM uc_discounts_roles dr, users_roles ur WHERE (dr.role_id=ur.rid AND ur.uid=0) OR dr.role_id=-1 OR dr.role_id=1)) AND (d.filter_type<>1 OR dp.product_id IN(-1,583)) AND (d.filter_type<>2 OR dt.term_id IN(-1,46,44,2,12,71,102,101,100)) AND (d.filter_type<>3 OR ds.sku IN('','043396266261')) AND (d.filter_type<>4 OR dcl.class IN('','product')) AND (d.has_expiration=0 OR d.expiration>1283546512) ORDER BY d.1 weight in /home/northsac/public_html/sites/all/modules/uc_discounts_alt/uc_discounts/uc_discounts.module on line 1675.