warning: You have an error in your SQL syntax

I have just upgraded to the new version: Ubercart Discounts (Alternative) 6.x-2.x-dev (2010-Aug-16), then got the following warnings for my product page:
---------------------------------------------------

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,11)) AND (d.filter_type<>2 OR dt.term_id IN(-1,2)) AND (d.filter_type<>3 OR ds.sku IN('','INV-DH-Window-0726')) AND (d.filter_type<>4 OR dcl.class IN('','product')) AND (d.has_expiration=0 OR d.expiration>1282122182) ORDER BY d.1 weight in /home/chineseknot/www/gbtestbk/sites/all/modules/uc_discounts_alt/uc_discounts/uc_discounts.module on line 1675.

----------------------------------------------------------

It seems the problem is related with the "weight"? Any help would be appreciated. If I disable the Codeless Discounts Field, then the warning is gone. But I really needed this module for my store. Previous version worked, I don't know why the new version didn't work.

Thanks.