PayPal problem

[Guest]

I installed the PayPal_Shopping_Cart_IPN module, but there is a one problem in the client menu (BOX_CUSTOMERS_PAYPAL)

 

-----------------------------------------------------------------

PayPal Instant Payment Notifications Status

 

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

 

 

anyone can solve the problem?

 

Thanks

[♥Vger]

Read the '1064' error link below my name.

 

Vger

[Guest]

Read the '1064' error link below my name.

 

Vger

 

I resolved the problem. Thank you very much.

:thumbsup:

[Guest]

I installed the PayPal_Shopping_Cart_IPN module, but there is a one problem in the client menu (BOX_CUSTOMERS_PAYPAL)

 

-----------------------------------------------------------------

PayPal Instant Payment Notifications Status

 

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

 

 

anyone can solve the problem?

 

Thanks

 

What is the PayPal_Shopping_Cart_IPN Module?? is that the one thru the Admin panel for Payment options??

 

Hey on my Check out, it does not even show any options... whats the deal? one time it actually when through and sent me to PayPal. But even if i choose any other options, then payment selection says

 

" Payment Method

 

This is currently the only payment method available to use on this order. "

 

I didnt really tweak anything... besides from the Admin panel to setup this..

 

Please help this rookie!!

 

Here is where you can see my store.. http://gotlocalmusic.com/osCommerce/index.php