Using SOFORT Plugin generates 40 confirmation emails

[iamalive]

Hi

My client uses the SOFORT Plugin. The actual payment process works fine, but for some reason the confirmation email gets sent 40 times, which irritates customers no end, of course.

I have no idea how to fix this but can offer the following example report:

Benachrichtigungen zur Transaktion 126613-269897-56FD5CD6-1839 https://www.sofort.com/payment/img/details.gif

Sie können sich weitere technische Informationen zu einer Benachrichtigung ansehen, indem Sie auf Details klicken. Wenn Sie keine Einträge in der Liste sehen, waren zum Zeitpunkt der Transaktion keine Benachrichtigungen aktiviert.

Benachrichtigungen beendet:
Nein
Erfolgreich:
https://www.sofort.com/payment/img/bullet_ball_red.gif


ID
Typ
Name der Benachrichtigung
Zeitpunkt
Versuch
erfolgreich
219995118
XML HTTP Post
im Zahlungsaufruf mitgegeben
01.04.2016 08:46:24
32
https://www.sofort.com/payment/img/error.gif
https://www.sofort.com/payment/img/details.gif
Benachrichtigungs-Log in zeitlicher Abfolge (Fehler rot):
01.04.2016 08:46:22: Processing notification #219995118. Transaction 126613-269897-56FD5CD6-1839 for status "untraceable", reason "sofort_bank_account_needed"
01.04.2016 08:46:22: URL parsed: protocol:http user: pass: host:mydomain.ch port: path:/index.php query:option=com_virtuemart&view=pluginresponse&task=pluginnotification&tmpl=component&pm=5&on=VRD8044&security=RjvjnRWsfwjIn4CaoenDyOnZ&lang=de-DE anchor:
01.04.2016 08:46:22: Starting request to http://innoserve.ch/index.php with method POST
01.04.2016 08:46:22: Valid server remote IP: 194.150.248.242
01.04.2016 08:46:24: Response code of this request: 500
01.04.2016 08:46:24: Notification 219995118 failed
Antwort von Ihrem Webserver:
cache-control: public, max-age=2592000,no-transform
expires: Sun, 01 May 2016 06:46:25 GMT
content-type: text/html; charset=utf-8
content-length: 0
date: Fri, 01 Apr 2016 06:46:25 GMT
accept-ranges: bytes
server: LiteSpeed
x-frame-options: SAMEORIGIN
x-content-type-options: nosniff
x-xss-protection: 1; mode=block
connection: close

I hope you can help me sort this out.

Regards
David


System Info:

System Information
=============
php: Linux srv23.tophost.ch 2.6.32-531.29.2.lve1.3.11.1.el6.x86_64 #1 SMP Thu Dec 18 06:49:17 EST 2014 x86_64
dbversion: 5.5.48-cll
dbcollation: latin1_swedish_ci
dbconnectioncollation: utf8mb4_general_ci
phpversion: 5.5.33
server: LiteSpeed
sapi_name: litespeed
version: Joomla! 3.5.0 Stable [ Unicorn ] 21-March-2016 22:00 GMT
platform: Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT
useragent: Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/49.0.2623.110 Safari/537.36

[GJC Web Design]

I assume the problem is here:

01.04.2016 08:46:22: Starting request to http://innoserve.ch/index.php with method POST
01.04.2016 08:46:22: Valid server remote IP: 194.150.248.242
01.04.2016 08:46:24: Response code of this request: 500
01.04.2016 08:46:24: Notification 219995118 failed

the response to the IPN is a 500 error ..  so does SOFORT keep trying and is this triggering the email over and over?

If I try

http://innoserve.ch/de/?option=com_virtuemart&view=pluginresponse&task=pluginnotification&tmpl=component&pm=5&on=VRD8044&security=RjvjnRWsfwjIn4CaoenDyOnZ&lang=de-DE

I indeed get a 500 server error .. this needs to be fixed first (sometimes it is the pdf creation failing that throws this)

can u manually set an order to confirmed and does this produce a pdf?

If u try the url above does it trigger an email?

Is the verlauf of the order over and over again Confirmed?

The payment plugin should at least check the current state b4 setting .. I have seen a few payment plugs that don't and can lead to multiple emails/confirms

[iamalive]

Hi

Thanks for your reply.

I'm afraid I don't understand what I can/should do exactly. Especially about the 500 Error.

My Client just sent the following to me :

Habe seit gestern Nacht um 21:39 bisher 12 solche identische Fehlermeldungen erhalten.

Log-File (sofort.5.log.php) ist so:

#
#
2016-04-04 19:39:07 ERROR plgVmOnPaymentNotification: SOFORT notification return Error Error: :
2016-04-04 19:39:07 ERROR plgVmOnPaymentNotification: no transaction ID for order number VRD8044
2016-04-05 02:57:06 ERROR plgVmOnPaymentNotification: SOFORT notification return Error Error: :
2016-04-05 02:57:06 ERROR plgVmOnPaymentNotification: no transaction ID for order number VRD8044
2016-04-05 05:12:05 ERROR plgVmOnPaymentNotification: SOFORT notification return Error Error: :
2016-04-05 05:12:05 ERROR plgVmOnPaymentNotification: no transaction ID for order number VRD8044

I presume those messages were generated by your tests.

I have asked the client to confirm which mail was generated so frequently.

Regards
David

[erecan]

Hi

Thanks for your help with this.

I'm the client of "iamalive".
I would like to answer some of your questions as good as I can:
- Yes, SOFORT keep trying and is triggering the email over and over (40 times)
- Yes, I can set an order manually to confirmed (or to sent, etc.) . But I dont' know exactly what this produces. I think it sends an e-mail to the client if I choose the option: notify the customer
- What is triggered again and again is the "order is confirmed" mail of Virtuemart (with all the order details) which the customer receives 40 times and we receive 40 times too.

I hope this helps.

Best regards,
Ercan

[GJC Web Design]

Yes.. because your server when Sofort sends
http://innoserve.ch/de/?option=com_virtuemart&view=pluginresponse&task=pluginnotification&tmpl=component&pm=5&on=VRD8044&security=RjvjnRWsfwjIn4CaoenDyOnZ&lang=de-DE

sends back a 500 fatal server error instead of a 200 -- OK message

so it keeps trying

the problem is at your end with the 500 server error .. it needs fixing otherwise it will never work..

what the error is will be logged somewhere

[iamalive]

OK - Thanks for your input - much appreciated.
I'll tackle it with the hoster tomorrow - they are good at helping too :-)
Regards
David