Jump to content

redearthdesign

Members
  • Content count

    6
  • Joined

  • Last visited

Profile Information

  • Real Name
    Emma McCauley
  1. redearthdesign

    ### POINTS AND REWARDS MODULE V1.00 ###

    I found two other places that need a space like above. Do a search in customer_points_pending.php, customer_points.php, and orders.php for 'where customers_id and change it to ' where customers_id with a space between the ' and the where. there are three in total. All else is still working smoothly. Best wishes, Emma
  2. redearthdesign

    ### POINTS AND REWARDS MODULE V1.00 ###

    Dear Deep-silver, The new contribution you posted Nov. 26, 2005 POINTS AND REWARDS MODULE V1.00 at http://www.oscommerce.com/community/contributions,3220 is excellent. Your instructions were easy to follow and everything is working great. There is only one place I found the need for a change aside from regular customizations. I got this 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 'customers_id = 2' at line 1 update customers set customers_shopping_points = customers_shopping_points + 1where customers_id = 2 ---- So I updated line 38 of catalog/admin/customers_points_pending.php and added a space between $customer_points['points_pending'] . ' and the word 'where' in the query. That was it, the rest was just right. Thanks for sharing all your hard work and for taking the time to write thorough helpful instructions. Best wishes, Emma
×