Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

'paypal IPN' problem. Need help please!


jwen

Recommended Posts

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

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...