Jump to content

Archived

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

jwen

'paypal IPN' problem. Need help please!

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

Share this post


Link to post
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.

Share this post


Link to post
Share on other sites
Guest
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!

Share this post


Link to post
Share on other sites

×