As I wrote in the title when the checkout is completed (all worked in Paypal Sandbox) the order status is pending..ALWAYS..any idea on how to fix it?

Comments

pucc’s picture

I also went to admin>reports>dblog but there aren't messages who tell me that the IPN doesn't work proprerly..I'm testing my site on localhost..please help..

tr’s picture

Category: bug » support
Status: Active » Postponed (maintainer needs more info)

Your title says sandbox doesn't work, but the body of your post says sandbox does work - which is it?

If you're testing on localhost, how can PayPal connect to your server to deliver the IPN?

Also, are you really using 7.x-3.1? The other issues you posted all say 7.x-3.0. As advised in that other issue, you should upgrade to 7.x-3.1.

pucc’s picture

Yes I'm using 7.x-3.1..I've upgraded the version..so I'm gonna try to use sandbox on a web host..I'm sorry but the documentation on the web is very confused because people says different things about how to use paypal sandbox..also on ubercart.org..and they says that it's possible to use it on localhost..so I was thinking that it was an ubercart's bug..However in version 7.x-3.0 the orders were always in checkout and when I finished to pay on paypal sandbox I was redirected to the cart page..with this new version I'm redirected to order's completion page and the orders are pending..also if there are lots of errors messages due to the widgets module (It's a known issue but nobody fixed it)..So..I let you know if everithing it's ok on the web host..thank you in advance..

pucc’s picture

And with "all worked in Paypal Sandbox" I meant that the payment is received on Paypal if I check the seller and the buyer profiles and emails..but it sounds like Paypal don't tell ubercat that everithing it's ok..and so the balance is not set to 0.0 and the orders are pending..I'm sorry if I don't express my self properly..but english is not my mother language :)

pucc’s picture

So I've tested it on my Web Host (altervista) that doesn't support SSL...and I read in a forum to force the https in http changing the variable $host before the line $response = drupal_http_request etc in paypal.pages.inc but the result remains the same..here's what is in the drupal's log:
Receiving IPN at URL for order 18.
Array
(
[mc_gross] => 240.00
[invoice] => 18-3df58e05fa81bdf7ba0c04c3ab756d80
[protection_eligibility] => Ineligible
[address_status] => unconfirmed
[item_number1] =>
[tax] => 0.00
[payer_id] => BHNZ8VSQLPMFJ
[address_street] => via trionfale 33
[payment_date] => 09:11:05 May 05, 2012 PDT
[option_selection1_1] => 1
[payment_status] => Completed
[charset] => windows-1252
[address_zip] => 00100
[mc_shipping] => 0.00
[mc_handling] => 0.00
[first_name] => lidia
[mc_fee] => 8.51
[address_country_code] => IT
[address_name] => marta titto
[notify_version] => 3.4
[custom] =>
[payer_status] => verified
[business] => lidia._1336059378_biz@gmail.com
[address_country] => Italy
[num_cart_items] => 1
[mc_handling1] => 0.00
[address_city] => roma
[verify_sign] => AFcWxV21C7fd0v3bYYYRCpSSRl31A7tCezeWrjBzGzXRsAE5GB8nmJKB
[payer_email] => lidia._1336126428_per@gmail.com
[mc_shipping1] => 0.00
[tax1] => 0.00
[option_name1_1] => Product count
[txn_id] => 8HA47971M94138018
[payment_type] => instant
[last_name] => rossi
[address_state] => RM
[item_name1] => Order 18 at Bed and Breakfast Domus Elettra
[receiver_email] => lidia._1336059378_biz@gmail.com
[payment_fee] =>
[quantity1] => 1
[receiver_id] => XCBFHHH298XNJ
[txn_type] => cart
[mc_gross_1] => 240.00
[mc_currency] => EUR
[residence_country] => IT
[test_ipn] => 1
[transaction_subject] => Shopping CartOrder 18 at Bed and Breakfast Domus Elettra
[payment_gross] =>
[ipn_track_id] => 6af3ddbb90c0
)

what am I suppose to do?

pucc’s picture

pucc’s picture

Category: support » bug
Status: Postponed (maintainer needs more info) » Active

so now I'm on a web server and I have ssl enabled..all my pages are under https...my site is not protected with a password..I'm not in maintenance mode...all on my web site is fine..but:
The orders are still in pending..and in the db the table uc_payment_paypal_ipn is empty...so I think it's not a support request..it's a bug report..

longwave’s picture

Category: bug » support
Status: Active » Postponed (maintainer needs more info)

If you are seeing the "Receiving IPN" message on your web server please paste the IPN details here.

If you are not seeing that message, IPNs are not getting through to your site and there is something wrong with either your site or PayPal configuration.

pucc’s picture

I see the receiving ipn message in the logs.
Here it is:
Receiving IPN at URL for order 32.
Array
(
[mc_gross] => 240.00
[invoice] => 32-7f876620d3a1d9e55b511b9351eebf83
[protection_eligibility] => Ineligible
[address_status] => unconfirmed
[item_number1] =>
[tax] => 0.00
[payer_id] => BHNZ8VSQLPMFJ
[address_street] => via trionfale 68
[payment_date] => 06:00:32 May 09, 2012 PDT
[option_selection1_1] => 1
[payment_status] => Completed
[charset] => windows-1252
[address_zip] => 00100
[mc_shipping] => 0.00
[mc_handling] => 0.00
[first_name] => lidia
[mc_fee] => 8.51
[address_country_code] => IT
[address_name] => lara nardi
[notify_version] => 3.4
[custom] =>
[payer_status] => verified
[business] => lidia._1336059378_biz@gmail.com
[address_country] => Italy
[num_cart_items] => 1
[mc_handling1] => 0.00
[address_city] => roma
[verify_sign] => ANqh-4XJe2LO1RM.qDa6T01OLQ3gABQSNShB488He0UFNYkcgcJReTi6
[payer_email] => lidia._1336126428_per@gmail.com
[mc_shipping1] => 0.00
[tax1] => 0.00
[option_name1_1] => Product count
[txn_id] => 4F105691EA181640T
[payment_type] => instant
[last_name] => rossi
[address_state] => RM
[item_name1] => Order 32 at Bed and Breakfast Domus Elettra
[receiver_email] => lidia._1336059378_biz@gmail.com
[payment_fee] =>
[quantity1] => 1
[receiver_id] => XCBFHHH298XNJ
[txn_type] => cart
[mc_gross_1] => 240.00
[mc_currency] => EUR
[residence_country] => IT
[test_ipn] => 1
[transaction_subject] => Shopping CartOrder 32 at Bed and Breakfast Domus Elettra
[payment_gross] =>
[ipn_track_id] => 55620f3e45520
)

pucc’s picture

It seems like there's something wrong in paypal.pages.inc

MitJ’s picture

Hi,
I have getting same problem.I have upgraded ubercart module from 7.x- 3.0 to 3.1.all orders are going through PayPal sandbox,getting emails and redirect to order completed page as well.

But Report does not shows the completed status.Product checkout status still showing Pending.

Please let me know if anyone have suggestions or solution on this.

Thank you,
MitJ

pucc’s picture

Wonderfull...thought I was the only one :) now I feel a little bit less lonely XD

pucc’s picture

Could someone help here? I'm not able to find a solution to my problem..I'm only receiving in my logs the message that I've posted..it seems like that the if and else that checks if the response is valid or not isn't execute because I've no other watchdog messages in my logs..and my table uc_payment_paypal_ipn is empty...maybe it's a problem with the sandbox and on the live site it's all ok?

jmlavarenne’s picture

Is your 'data' field from the uc_payment_receipts set to 'NOT NULL'? If it is, try removing the NOT NULL constraint.

see http://drupal.org/node/1593618

pucc’s picture

Thank you, but this isn't my problem...I have also try the payment on paypal live site but it doesn't work..I don't know what I've to do..

pucc’s picture

Status: Postponed (maintainer needs more info) » Closed (fixed)

finally ubercart is not working with paypal sandbox..on the live site it works but please don't leave in blank the ipn's url!!!!!!

Anonymous’s picture