Paypal is not updating status in database after completion of payment.

Hi,

This is Gagan, I am facing one problem in my clients website. When payment is completed through paypal. After that this is not updating status in database. Please help me . How I can do this. and I do not know where I can found that file in which i will have to update some code.

Let me explain whole project or database Status:

Here is one project in which when payment is completed through paypal there is one table in database name i.e. payments this have these columns name payment_id ,member_id , product_id ,begin_date ,expire_date , paysys_id ,receipt_id ,amount ,completed ,remote_addr etc. Here completed column name automatically come 0 that is fine when a user pays through paypal but when payment is completed then this completed column are not updating his value to 1. This should be automatically changed to 1.But that is not happening.

I think may be problem is in this file but i am not sure. ( I do not i am right or not ) in this path ---- amember\plugins\db\mysql\mysql.inc.php

I need your help.

Please help me to solve this. If you have any other query regarding this and then please tell me.

Thanks,








data

Are you getting a record of the transaction in amember- error log?

David

Status is not change when payment received through paypal??

thanks david for reply,

Yes i have error_log table in database in which transaction are stored.

Please help me to sort out this problem.I want to sort our very soon.

Because you know status is not changing automatically in table when payment get completed. I had to changed it manually.

Please help me.
thanks

Yes I am getting this value for one record which do not update status . In url field i am getting this value---

and error which i am getting i.e. this

I do not know how this can be solved .Please help me.
thanks

Hi Alexander,

Thanks for reply,

I have also send mail regarding this issue. My Ticket ID is AGI-51356-451. You can see this issue in very details. I have also send this issue in this email id support@cgi-central.net.

SO please check this issue .

Thanks

Getting Same Error recently

Hello,

I am also getting same error and PayPal is not updating database, started happening over weekend I think... Here is a screenshot:

Time URL Remote IP Message
11/02/2009 05:01:08 /twfx-members/plugins/payment/paypal_r/ipnr.php 66.211.170.66 paypal_r ERROR: amount passed is [77], should be [0]
mc_gross => 77.00
invoice => 2411-XNG
protection_eligibility => Ineligible
payer_id => QRKRX2SG9STVJ
tax => 0.00
payment_date => 02:00:54 Nov 02, 2009 PST
payment_status => Completed
charset => windows-1252
first_name => JULIUS
mc_fee => 3.30
notify_version => 2.8
custom =>
payer_status => unverified
business => payments@tradewindowfx.com
quantity => 1
verify_sign => AFcWxV21C7fd0v3bYYYRCpSSRl31AxMq-S4FeUqaGSQsdteXX1K8uGTe
payer_email => jtafura@hotmail.com
txn_id => 0LY85396HR947570F
payment_type => instant
last_name => TAFURA
receiver_email => payments@tradewindowfx.com
payment_fee => 3.30
receiver_id => Z5SRLR2KMJCRU
txn_type => web_accept
item_name => 1 Year Forex Signals & Education
mc_currency => USD
item_number =>
residence_country => GB
handling_amount => 0.00
transaction_subject => 1 Year Forex Signals & Education
payment_gross => 77.00
shipping => 0.00