jwen Posted October 31, 2005 Share Posted October 31, 2005 Got a problem when display information of "paypal IPN" under "admin -> Customers". It displays the followings: PayPal Instant Payment Notifications 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 p.txn_id, p.parent_txn_id, p.paypal_id, p.txn_type, p.payment_type, p.payment_status, p.pending_reason, p.mc_currency, p.mc_fee, p.payer_status, p.mc_currency, p.date_added, p.mc_gross, p.payment_date from paypal as p order by p.paypal_id DESC limit -20, 20 please anyone help! Thanks a lot! Regards, jay Link to comment Share on other sites More sharing options...
MarcoZorro Posted October 31, 2005 Share Posted October 31, 2005 Hmm looks like you are not using the oscommerce ipn module.. I would recommend it over all the other ipn contributions as it works out of the box and requires no changes to any files. Link to comment Share on other sites More sharing options...
jwen Posted October 31, 2005 Author Share Posted October 31, 2005 Im using Paypal_Shopping_Cart_IPN v3.15. will u show me how to do now please? I got no idea about it. Link to comment Share on other sites More sharing options...
swopedesign Posted October 31, 2005 Share Posted October 31, 2005 The download comes with an online HTML manual which includes installation, configuration and FAQs. You should use that manual. Im using Paypal_Shopping_Cart_IPN v3.15. will u show me how to do now please? I got no idea about it. Link to comment Share on other sites More sharing options...
MarcoZorro Posted October 31, 2005 Share Posted October 31, 2005 Im using Paypal_Shopping_Cart_IPN v3.15. will u show me how to do now please? I got no idea about it. I dont use that version of paypal ipn... to much hassle to install and too many problems so I cant help you sorry. Link to comment Share on other sites More sharing options...
jwen Posted October 31, 2005 Author Share Posted October 31, 2005 Thank you two anyway! I tried reinstall it but nothing seems change. Do i have to give up now? Link to comment Share on other sites More sharing options...
Guest Posted October 31, 2005 Share Posted October 31, 2005 Hmm looks like you are not using the oscommerce ipn module.. I would recommend it over all the other ipn contributions as it works out of the box and requires no changes to any files. Could you please provide a specific contribution name or link to the contribution you are recommending? Thanks! Link to comment Share on other sites More sharing options...
MarcoZorro Posted October 31, 2005 Share Posted October 31, 2005 Could you please provide a specific contribution name or link to the contribution you are recommending? http://www.oscommerce.com/community/contributions,2679 Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.