Reward Points Module for ZC v13x

[devus]

We recently upgraded to zen-cart 1.51 (new install with ported database from old site).

Reward points is installed but doesn't seem to be working properly. Points are not getting moved from pending to earned, plus a lot of customers seem to have 200 pending points for no particular reason. No points are awarded for new accounts.

I am seeing this error in the logs which seems to be related. The products_id field is not formatted correctly.

Any ideas as to the cause?

[25-Mar-2013 12:21:19 Europe/London] PHP Fatal error:  1064: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 '1215"''
                AND ((prp.scope_id=p.products_id AND prp.scope='2') 
                OR (p.pro' at line 3 :: SELECT prp.point_ratio*p.products_price AS reward_points, prp.point_ratio, p.products_price, p.products_priced_by_attribute 
                FROM reward_master prp, products p, products_to_categories p2c 
                WHERE p.products_id='1215"''
                AND p2c.products_id='1215"''
                AND ((prp.scope_id=p.products_id AND prp.scope='2') 
                OR (p.products_id=p2c.products_id AND prp.scope_id=p2c.categories_id AND prp.scope='1')
                OR (prp.scope='0'))
                ORDER BY prp.scope DESC LIMIT 1; in <site>/includes/classes/db/mysql/query_factory.php on line 120 

Chris