If anyone can help resolve this issue I'd greatly appreciate it. Just upgraded our rewards points today to 2.1b on Zen Cart 1.5.1 and I am getting the following error:
Code:
[06-Aug-2013 01:24:05 America/New_York] 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 '11178''
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='11178''
AND p2c.products_id='11178''
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 /MASKED/includes/classes/db/mysql/query_factory.php on line 120
Thanks for your help!
Bookmarks