Multiple "IPN validated" for same order [#2323901]

I have just set a web site with:

Drupal 7.31.
Commerce 7.x-1.9
PayPal WPS 7.x-2.3
...
Rules 7.x-2.7
...

and it rocks! People are happily ordering and paying for dancing courses through Paypal.

However, there is one order (that is paid - correct status in Drupal and received in Paypal), that is filling the logs:

IPN validated for Order 21 with ID [SAME ID].

Now 10 entries and counting. The last entry for that order currently is:

IPN processed for Order 21 with [SAME ID].

I'm not sure if it has stopped now or if it will continue.

Everyting works, it's just that my rule for the "When an order is first paid in full" event is triggered again and again.

Any clue about what is going on? (Maybe this is just a "PayPal WPS" issue? If so, feel free to send the issue there.)

Comments

Comment #1

hansfn CreditAttribution: hansfn commented 19 August 2014 at 12:20

Comment #2

hansfn CreditAttribution: hansfn commented 19 August 2014 at 12:23

Issue summary:

View changes

Comment #3

hansfn CreditAttribution: hansfn commented 19 August 2014 at 18:54

Looking carefully at the logs, I found:

[...]
Location: http://example.org/commerce_paypal/ipn/paypal_wps%7Ccommerce_payment_paypal_wps
[...]
Message: Recoverable fatal error: Object of class stdClass could not be converted to string i DatabaseStatementBase->execute() (line 2171 of /var/www/example.org/includes/database/database.inc).

Comment #4

rszrama CreditAttribution: rszrama commented 20 August 2014 at 17:38

Project:	Commerce Core	» Commerce PayPal
Version:	7.x-1.9	» 7.x-2.x-dev
Component:	Payment	» PayPal WPS

Hmm, even if it's being validated multiple times, it shouldn't be triggering the event multiple times... ahh, unless the error you're seeing in the logs occurs before the order is updated to indicate the event has already been triggered. Is this not resulting in multiple payment transactions being saved to the order?

Comment #5

hansfn CreditAttribution: hansfn commented 28 August 2014 at 22:48

You are correct that multiple payment transactions are saved to the order. At admin/commerce/orders/21/payment I see 11 "The payment has completed." statuses. I actually have one more order with these multiple payment transactions - 8 during 30 minutes. The other roughly 100 orders (since 18th of August) worked flawlessly.

Not sure if I can provide any more info to help resolve this issue.