sofort.com not changing status to confirmed

[Uke]

Joomla! 2.5.14 Virtuemart V2.0.24

Hello!

I have tested the new sofort banking module that comes with V2.0.24. Everything was fine, only the order status is not changing to "confirmed" after payment was done.

In the sofort.com backend i have this link for notification:

https://www.matuschka-shop.de/index.php?option=com_virtuemart&view=pluginresponse&task=pluginnotification&tmpl=component&on=-USER_VARIABLE_0-&pm=-USER_VARIABLE_1-

Maybe this option shoud be disabled? Payment pending (screenshot)

The sofort.com log for the notfication is:

Notification log over period of time (errors red):

    07.10.2013 01:18:57: Processing notification #90194340. Transaction 73359-166901-5251EE4C-1060 for status "untraceable", reason "sofort_bank_account_needed"
    07.10.2013 01:18:57: URL parsed: protocol:https user: pass: host:dev.matuschka-shop.de port: path:/shop/shopping-cart/pluginresponse/pluginnotification query:tmpl=component&security=5M01aQIN6BUwktXCQHKiXEgS&on=o_131022 anchor:
    07.10.2013 01:18:57: Starting request to https://dev.matuschka-shop.de/shop/shopping-cart/pluginresponse/pluginnotification with method POST
    07.10.2013 01:18:57: Valid server remote IP: 62.146.22.104
    07.10.2013 01:18:59: Response code of this request: 200
    07.10.2013 01:18:59: Notification 90194340 successful

Response on your web server:

date: Sun, 06 Oct 2013 23:18:57 GMT
server: Apache/2.0.63 (Unix)
x-powered-by: PHP/5.2.17
p3p: CP="NOI ADM DEV PSAi COM NAV OUR OTRo STP IND DEM"
cache-control: no-cache
pragma: no-cache
content-length: 2600
content-type: text/html; charset=utf-8

NO BODY DOWNLOADED

I now use my old SofortClassic Module which works ok, but it have a problem that when customer cancell the payment it returns to the shop and the cart is empty - which is shit. With the new module it returns to shop and cart is untouched.

Thanks in advance for help.

[attachment cleanup by admin]

[Uke]

Does someone use the plugin for sofort banking and have the same problem with "pending orders" or i am the only one with this problem?

[alatak]

Hello

In the sofort.com backend i have this link for notification:

https://www.matuschka-shop.de/index.php?option=com_virtuemart&view=pluginresponse&task=pluginnotification&tmpl=component&on=-USER_VARIABLE_0-&pm=-USER_VARIABLE_1-

You dn't need to do that. The plugin send the correct URL .
The manual is here https://www.sofort.com/integrationCenter-eng-DE/content/view/full/4947

[Uke]

Hello,

After updating Joomla and Virtuemart my older Sofort.com module now also not working. Order status in backend is "pending" and is not changed to "confirmed" after successful payment. Customer see that payment is completed on plugin response. 

I now started again to test the newer module with same result. All orders "pending". I also have deleted the notification link on sofort.com backend like you wrote alatak.

Testet everything many times, dont know what is wrong.

My Versions:

Joomla 2.5.20
Virtuemart 2.6.5

Please someone help me. Thanks.

Uke

[alatak]

Hello
Did you check that you do receive an IPN ? You can check that on your host access log

[Uke]

Hello,

In the access_log i found this:

193.104.xx.xxx - - [04/Jun/2014:17:22:24 +0200] "POST /index.php?option=com_virtuemart&view=pluginresponse&task=pluginnotification&tmpl=component&&security=xxxxx&on=1406039&lang= HTTP/1.1" 200 2784 "-" "Payment Network AG notification-request"

In Sofort.com Backend this log:

Notification log over period of time (errors red):

    04.06.2014 17:22:24: Processing notification #117730737. Transaction 73359-166901-538F396A-XXXX for status "pending", reason "not_credited_yet"
    04.06.2014 17:22:24: URL parsed: protocol:https user: pass: host:www.matuschka-shop.de port: path:/index.php query:option=com_virtuemart&view=pluginresponse&task=pluginnotification&tmpl=component&&security=xxxxx&on=1406039&lang= anchor:
    04.06.2014 17:22:24: Starting request to https://www.matuschka-shop.de/index.php with method POST
    04.06.2014 17:22:24: Valid server remote IP: 62.146.xx.xxx
    04.06.2014 17:22:26: Response code of this request: 200
    04.06.2014 17:22:26: Notification 117730737 successful

Response on your web server:

date: Wed, 04 Jun 2014 15:22:24 GMT
server: Apache/2.0.63 (Unix)
p3p: CP="NOI ADM DEV PSAi COM NAV OUR OTRo STP IND DEM"
cache-control: no-cache
pragma: no-cache
content-length: 2784
content-type: text/html; charset=utf-8



NO BODY DOWNLOADED

Could this double & in the Link be a problem?

...tmpl=component&&security...

I now see in the com_virtuemart.log.php the following error that is from my older sofort.com module:

2014-06-04 09:39:27 ERROR vmError: VmTableData::store failed - Duplicate entry '255' for key 1 SQL=INSERT INTO `rq5io_virtuemart_payment_plg_sofortclassic` (`id`,`virtuemart_order_id`,`order_number`,`virtuemart_paymentmethod_id`,`payment_name`,`payment_order_total`,`payment_currency`,`sofort_transaction_id`,`created_on`,`created_by`,`modified_on`,`modified_by`) VALUES ('0','2257','1406034','8','<span class=\"vmpayment_name\">Sofortüberweisung.de</span><span class=\"vmpayment_description\"><p><img alt=\"Sofort\" src=\"https://www.matuschka-shop.de/images/stories/virtuemart/payment/200x75.jpg\" style=\"padding-top:10px; padding-bottom:5px;\"></img></p>\r
<p>Zahlung mit dem Online-Zahlungsservice SOFORT Ãœberweisung.</p></span>','37.82','47','0','2014-06-04 09:39:27','0','2014-06-04 09:39:27','0')

I checked the database and the field "id" was set up with type "tinyint(1)" what?

Changed field "id" to INT(11) and tested once again to pay a order with sofort.com and it works now.

Dont know why someone have set up "id" with tinyint(1) but ok.

Still dont know why the latest sofort.com module is not working but for now i am happy that i found the reason.

Please tell me if you have some hints about the new module, i like to use it as long it was released with virtuemart but had no success with it.

Greetings, Uke

[alatak]

Hello

Changed field "id" to INT(11) and tested once again to pay a order with sofort.com and it works now.

OK, thanks for finding. But in the code i have the id is set to INT 11

Code Select Expand

function getTableSQLFields
...
'id' => 'int(11) UNSIGNED NOT NULL AUTO_INCREMENT',
...