Duplicate records for PayPal recurring payments

Discussion in 'Troubleshooting' started by arsenitim, Oct 28, 2011.

  1. arsenitim

    arsenitim New Member

    Joined:
    Jan 24, 2011
    Messages:
    2
    Hi everyone!

    We're having a strange issue. Some of our PayPal transactions are getting duplicate records.
    Here is an example:
    [​IMG]

    In database the records are identical, except:
    `payment_id`(consequent IDs)
    `expire_date` ('2012-12-31' vs '2011-10-20')
    `time` ('2011-09-21 05:39:55' vs '2011-10-21 07:18:29')
    `tm_added` ('2011-09-21 05:39:55' vs '2011-09-21 05:39:56')
    `tm_completed` ('2011-09-21 05:39:55' vs '2011-09-21 05:39:56')

    the `data` field is 100% identical.

    Some PayPal users have these extra records, some don't.
    Some have two extra records for same day.
    It looks like that started in september (not 100% sure)

    What could cause that? Would it be safe to just delete all extra records from DB manually after next billing cycle?
  2. davidm1

    davidm1 aMember User & Partner

    Joined:
    May 16, 2006
    Messages:
    4,437
    Ive seen that a few times- i think its caused by paypals IPN hitting amember twice. So 2 records are created. (alex can confirm)

    I have had a problem in the past versions of amember where it caused a problem of having a payment that didnt expire, that should have, as 1 of the payments got canceled but the other didnt- but i think this got fixed with a newer version (maybe 3.1x on)- i used a mysql query to find these duplicates, then manually removed.

    David

Share This Page