VirtueMart Forum

VirtueMart 2 + 3 + 4 => Plugins: Payment, Shipment and others => Topic started by: thefbi on April 22, 2013, 23:20:24 PM

Title: Order status still pending after Paypal payment
Post by: thefbi on April 22, 2013, 23:20:24 PM
Hello,
i have VM 2.0.20b and Joomla 2.5.9.

I have read many posts in French and English for this problem, but not have find a solution...
The problem is the Paypal dont say to Joomla "Ok you can make the status to Confirmed" after payment. Emails of the site work, if i put Confirmed manually.
I have read this post : https://forum.virtuemart.net/index.php?topic=110463.0 and here from veeco :

1. Please access from your browser http://yourdomain.com/index.php?option=com_virtuemart&view=pluginresponse&task=pluginnotification&tmpl=component , is it accessible? there can be a problem here if you use 3rd party SEF since some member report that joomla redirect it to 404 when accessing this notification url.
==> That is OK, i dont have error, just a blank page

2. Paypal Plugin stored the raw IPN variables in '/log' folder.. please check if the data returned there ?
==> No data, only when i confirm manually...

3. Paypal Plugin also stored the raw IPN variables in '#_virtuemart_payment_plg_paypal' on column paypalresponse_raw
==> No data... but before 2 or 3 month, that was good...

So i dont understand what append ? Is there a configuration to make on the Paypal acount ? Have i to configure IPN ?

Thanks to help me on this before i gone totally crazy....

Regards, Frédéric
Title: Re: Order status still pending after Paypal payment
Post by: thanili on July 30, 2013, 20:47:29 PM
I have exactly the same issue and it is driving me crazy!

The only difference is that

a) i have checked paypal (joomla_root\logs) log file and i can find the record for the Completed transaction:

2013-07-30 13:42:21
message: plgVmConfirmedOrder order number: 1ba504

b) also have checked in the table 'XXXX_virtuemart_payment_plg_paypal' and all the 'paypal' fields e.g. paypalresponse_raw have zeros (0) ... !!!

did you manage to solved it? Any ideas here?
Title: Re: Order status still pending after Paypal payment
Post by: Maxim Pishnyak on July 30, 2013, 21:54:28 PM
http://forum.virtuemart.net/index.php?topic=116650.msg393648#msg393648
Title: Re: Order status still pending after Paypal payment
Post by: thanili on July 31, 2013, 13:14:17 PM
no luck!

Could we please verify that the URL after paypal redirection is complete and right?

http://www.artinfur.com/index.php?option=com_virtuemart&view=pluginresponse&task=pluginresponsereceived&on=e491010&pm=3&Itemid=0&tx=68G5700017369073G&st=Completed&amt=166%2e98&cc=EUR&cm=53efe0b1483043e1130f526e4365a7e1&item_number=

should item_number to be populated?
Title: Re: Order status still pending after Paypal payment
Post by: alatak on July 31, 2013, 20:15:03 PM
Hello
QuoteSo i dont understand what append ? Is there a configuration to make on the Paypal acount ? Have i to configure IPN ?
No you don't. The plugin does it.

So you don't get the IPN.
I'm going to PM you, and i will try to find out why .
The problem which was solved lately  and mentioned by Maxim was due to website on a sub directory.

If this is not your problem, then i have to check
Title: Re: Order status still pending after Paypal payment
Post by: thanili on August 01, 2013, 12:39:29 PM
Thanks Alatak!

i am waiting for your message!
Title: Re: Order status still pending after Paypal payment
Post by: alatak on August 01, 2013, 23:06:42 PM
Hello
I have been on your website
- added some log infos in the notification function: they do not appear . It means that the trigger is not triggerred
- i set the joomla debug to maximum, and call directly the notification call  http://yourdomain.com/index.php?option=com_virtuemart&view=pluginresponse&task=pluginnotification&tmpl=component
there are no fatal errors, and the infos are written in the log file
- i have tested with another sandbox email, and and the order status is not updated. Which means the notification is not received.

So i guess that it is a problem with your server stopping the IPN.
Can you check your server logs, and find this http://yourdomain.com/index.php?option=com_virtuemart&view=pluginresponse&task=pluginnotification&tmpl=component ?
Title: Re: Order status still pending after Paypal payment
Post by: thanili on August 02, 2013, 11:47:27 AM
Hello,

attached the access log file from the server ... i have completed an order just before a while using sandbox, but i can not find any line:

http://yourdomain.com/index.php?option=com_virtuemart&view=pluginresponse&task=pluginnotification&tmpl=component

the only relevant line i can find is this:

139.91.190.5 - - [02/Aug/2013:12:37:22 +0300] "GET /index.php?option=com%5fvirtuemart&view=pluginresponse&task=pluginresponsereceived&on=8c53017&pm=3&Itemid=0&tx=2M058292J75247041&st=Completed&amt=166%2e98&cc=EUR&cm=4c3a1c052fc58cbb33ae59fc95d86625&item_number= HTTP/1.0" 200 37526 "-" "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/28.0.1500.95 Safari/537.36"

anyway i will start communicating with my host provider and ask him about IPN paypal notifications... thanks anyway


[attachment cleanup by admin]
Title: Re: Order status still pending after Paypal payment
Post by: alatak on August 02, 2013, 11:53:52 AM
Hello
Quoteanyway i will start communicating with my host provider and ask him about IPN paypal notifications... thanks anyway
Yes that is the best.