Latest News: (loading..)

bizzygroup

Members
  • Content count

    4
  • Joined

  • Last visited

1 Follower

About bizzygroup

Profile Information

  • Real Name
    Zak Francis
  1. 7/22/08 Let me know how this works for you. I am having paypal issues as well.
  2. 7/22/08 Hi There- I have recently added the paypal payment option to my website. However it is not working and is costing me money!! When a customer pays with paypal, We do not get an e-mail notification that there is a pending order AND we the order is not saved. So we actually have to contact the customer in order to find out what they ordered. When we go into the order module, the paypal orders are not even listed, and there is an error that reads the following... 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 '-20, 20' at line 1 select o.orders_id, o.customers_name, o.customers_id, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from orders o left join orders_total ot on (o.orders_id = ot.orders_id), orders_status s where o.customers_id = '17' and o.orders_status = s.orders_status_id and s.language_id = '1' and ot.class = 'ot_total' order by orders_id DESC limit -20, 20 Can someone help? Thank you LeAndra Designer