Views: 5,943
Totally Zenned
Can confirm it fixes issue, however, now I can see that super orders doesn't pull the payment data from payflow.
Sensei
MarkJ21:
I was having the exact same problem for weeks, went through everything with a fine tooth comb. Finally found the problem, it is in includes/modules/payment/paypalwpp.php lines 217-218 and 229-230, and the cause, wait for it, a curly bracket/brace being in the wrong place.
Use Winmerge to copy the curly bracket/brace layout on lines 218-219 and 229-230 from paypalwpp.php v1.5.1 to v1.5.3.
Works great now :smile:
Hmmmm. The move of that curly brace from v151 to v153 was to fix the logic so it would correctly disable the module if the order was for 0.00 or >10,000 regardless of the customer's billing address. In v151 it would only do those amount-checks if the address fell inside the specified zone, but they should always happen regardless of zone.
A test to see whether that's relevant to this situation would be to look at the PayPal Debug Logs to see whether there are messages logged about the module getting disabled because of those amount checks.
(I realize that those amount checks shouldn't trigger a "geographic" kind of alert to the customer, but that's what the lines quoted by MarkJ21 refer to, so would like to see some real logs to confirm this to be the cause.)
.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole
Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.
New Zenner
I don't have the logs anymore, in hindsight I wish I had kept them and I understand these would be useful to confirm the issue but basically this did fix my problem of constantly getting the "geographic" customer alert. My setup is a completely fresh install of v1.5.3 with new utf8 database, the paypalwpp.php file is completely original v1.5.3 except for the curly brace location as mentioned earlier, this was the difference between it working or getting the "geographic" alert on a new install.
New Zenner
FYI I can confirm exactly the same re. the curly brackets. My UK store (not a fresh install) was running happily on 1.5.1 but I got the geographic error via Paypal Express after upgrading to 1.5.3, re-structuring paypalwpp.php seems to have fixed it for now.
Totally Zenned
to generate those logs, I would have to inconvenience my customers.
New Zenner
I've put the curly braces back to where they should be. Here are the logs from my ZC1.5.3 site...
Paypal_CURL##########8h.log
2014-08-15 01:00:21
-------------------
(live transaction) --> https://payflowpro.paypal.com/transaction
Request Headers:
Array
(
[0] => Content-Type: text/namevalue
[1] => X-VPS-Timeout: 90
[2] => X-VPS-VIT-Client-Type: PHP/cURL
[3] => X-VPS-VIT-Integration-Product: PHP::Zen Cart(R) - PayPal/Payflow Pro
[4] => X-VPS-VIT-Integration-Version: 1.5.3
)
Request Parameters: {SetExpressCheckout}
Array
(
[AMT] => 2.50
[ITEMAMT] => 2.50
[L_NUMBER0] => 5060163931912
[L_NAME0] => NaturaCalc Limestone Flour 900g calcium source for horses [827]
[L_QTY0] => 1
[L_AMT0] => 2.50
[CURRENCYCODE] => GBP
[LOCALECODE] => GB
[GIFTMESSAGEENABLE] => 0
[GIFTRECEIPTEENABLE] => 0
[GIFTWRAPENABLE] => 0
[GIFTWRAPNAME] =>
[GIFTWRAPAMOUNT] => 0
[BUYEREMAILOPTINENABLE] => 0
[CUSTOMERSERVICENUMBER] =>
[BRANDNAME] => Right As Rein
[PAYMENTACTION] => Sale
[ALLOWNOTE] => 1
[LANDINGPAGE] => Billing
[NOSHIPPING] => 0
[ACTION] => S
[TENDER] => P
[TRXTYPE] => S
[RETURNURL[58]] => https://www.mydomain.co.uk/ipn_main_handler.php?type=ec
[CANCELURL[75]] => https://www.mydomain.co.uk/index.php?main_page=shopping_cart
[ec_cancel] => 1
[PAGESTYLE] => Primary
[REQUEST_ID] => 1408104020
[USER] => NZX3E6EUPT
[PWD] => ****************
[PARTNER] => paypaluk
[VENDOR] => NU5MNB210I
)
Response:
Array
(
[RESULT] => 0
[RESPMSG] => Approved
[TOKEN] => EC-6C669426ST099853X
[CORRELATIONID] => 2b27fac7932f0
[REQUEST_ID] => 1408104020
[CURL_ERRORS] =>
)
SetExpressCheckout, Elapsed: 1210ms -- Succeeded
Paypal_CURL##########c1B.log
2014-08-15 01:00:51
-------------------
(live transaction) --> https://payflowpro.paypal.com/transaction
Request Headers:
Array
(
[0] => Content-Type: text/namevalue
[1] => X-VPS-Timeout: 90
[2] => X-VPS-VIT-Client-Type: PHP/cURL
[3] => X-VPS-VIT-Integration-Product: PHP::Zen Cart(R) - PayPal/Payflow Pro
[4] => X-VPS-VIT-Integration-Version: 1.5.3
)
Request Parameters: {GetExpressCheckoutDetails}
Array
(
[TOKEN] => EC-6C669426ST099853X
[ACTION] => G
[TENDER] => P
[TRXTYPE] => S
[REQUEST_ID] => 1408104050
[USER] => NZX3E6EUPT
[PWD] => ****************
[PARTNER] => paypaluk
[VENDOR] => NU5MNB210I
)
Response:
Array
(
[RESULT] => 0
[RESPMSG] => Approved
[AVSADDR] => N
[AVSZIP] => N
[TOKEN] => EC-6C669426ST099853X
[PAYERID] => 8VKCVE6H4L8QQ
[CORRELATIONID] => 9dabc73da664
[EMAIL] => [email protected]
[PAYERSTATUS] => verified
[FIRSTNAME] => John
[LASTNAME] => Doe
[SHIPTOBUSINESS] => Name
[SHIPTOSTREET] => 1 High Street
[SHIPTOSTREET2] => Lovedean
[SHIPTOCITY] => Waterlooville
[SHIPTOSTATE] => Hampshire
[SHIPTOZIP] => PO1 1AA
[SHIPTOCOUNTRY] => GB
[SHIPTONAME] => Name
[COUNTRYCODE] => GB
[ADDRESSSTATUS] => N
[REQUEST_ID] => 1408104050
[CURL_ERRORS] =>
)
GetExpressCheckoutDetails, Elapsed: 1158ms -- Succeeded
paypalwpp____x8f.log
Aug-15-2014 13:00:20 (1408104020)
getLineItemDetails 7 - subtotal comparisons
BEFORE line-item calcs: Array
(
[AMT] => 2.5
[ITEMAMT] => 2.5
[TAXAMT] => 0
[SHIPPINGAMT] => 0
[SHIPDISCAMT] => 0
[HANDLINGAMT] => 0
[INSURANCEAMT] => 0
)
AFTER doing line-item calcs: Array
(
[AMT] => 2.5
[ITEMAMT] => 2.5
[TAXAMT] => 0
[SHIPPINGAMT] => 0
[SHIPDISCAMT] => 0
[HANDLINGAMT] => 0
[INSURANCEAMT] => 0
[L_NUMBER0] => 5060163931912
[L_NAME0] => NaturaCalc Limestone Flour 900g calcium source for horses [827]
[L_QTY0] => 1
[L_AMT0] => 2.5
)
=================================
Aug-15-2014 13:00:20 (1408104020)
getLineItemDetails 8
checking subtotals...
Array
(
[calculated total] => 2.50
[AMT] => 2.50
[ITEMAMT] => 2.50
)
-------------------
difference: 0 (abs+rounded: 0)
=================================
Aug-15-2014 13:00:20 (1408104020)
getLineItemDetails 10
subtotals balance - okay
=================================
Aug-15-2014 13:00:20 (1408104020)
ec_step1 - 1
Checking to see if we are in markflow
cart contents: physical
NOTE: $this->showPaymentPage = 1
Customer ID: 0
Session Data: Array
(
[securityToken] => xxxxxxxx
[customers_host_address] => host-2-100-154-3.as13285.net
[cartID] =>
[cart] => shoppingCart Object
(
[contents] => Array
(
[827] => Array
(
[qty] => 1
)
)
[total] => 2.5
[weight] => 900
[cartID] => 92217
[content_type] => physical
[free_shipping_item] => 0
[free_shipping_weight] => 0
[free_shipping_price] => 0
[download_count] => 0
[total_before_discounts] => 2.5
[display_debug_messages] =>
[flag_duplicate_msgs_set] =>
)
[language] => english
[languages_id] => 1
[languages_code] => en
[check_valid] => true
[currency] => GBP
[today_is] => 2014-08-15
[updateExpirations] => 1
[session_counter] => 1
[customers_ip_address] => 2.100.154.5
[new_products_id_in_cart] => 827
[valid_to_checkout] => 1
[cart_errors] =>
[payment] => paypalwpp
)
=================================
Aug-15-2014 13:00:20 (1408104020)
ec-step1-addr_check
cart content is not all virtual (or customer is not logged in) ... therefore will be submitting address details
=================================
Aug-15-2014 13:00:20 (1408104020)
getOverrideAddress - 4
not logged in and not in markflow mode - nothing to override
=================================
Aug-15-2014 13:00:20 (1408104020)
ec-step1-addr_check3
address details from override check: <NONE FOUND>
=================================
Aug-15-2014 13:00:20 (1408104020)
ec_step1 - 2 -submit
Array
(
[AMT] => 2.50
[ITEMAMT] => 2.50
[L_NUMBER0] => 5060163931912
[L_NAME0] => NaturaCalc Limestone Flour 900g calcium source for horses [827]
[L_QTY0] => 1
[L_AMT0] => 2.50
[CURRENCYCODE] => GBP
[LOCALECODE] => GB
[GIFTMESSAGEENABLE] => 0
[GIFTRECEIPTEENABLE] => 0
[GIFTWRAPENABLE] => 0
[GIFTWRAPNAME] =>
[GIFTWRAPAMOUNT] => 0
[BUYEREMAILOPTINENABLE] => 0
[CUSTOMERSERVICENUMBER] =>
[BRANDNAME] => Right As Rein
[PAYMENTACTION] => Sale
[ALLOWNOTE] => 1
[SOLUTIONTYPE] => Sole
[LANDINGPAGE] => Billing
[NOSHIPPING] => 0
[RETURNURL] => https://www.mydomain.co.uk/ipn_main_handler.php?type=ec
[CANCELURL] => https://www.mydomain.co.uk/index.php?main_page=shopping_cart&ec_cancel=1
)
=================================
paypalwpp_Paypal##########___HC4.log
Aug-15-2014 13:00:51 (1408104051)
ec_step2
Re-instantiating $order object.
=================================
Aug-15-2014 13:00:51 (1408104051)
ec_step2
Instantiated $order object contents: order Object
(
[info] => Array
(
[order_status] => 2
[currency] => GBP
[currency_value] => 1.00000000
[payment_method] => PayPal
[payment_module_code] => paypalwpp
[coupon_code] =>
[shipping_method] =>
[shipping_module_code] =>
[shipping_cost] => 0
[subtotal] => 2.5
[shipping_tax] => 0
[tax] => 0
[total] => 2.5
[tax_groups] => Array
(
[0] => 0
)
[comments] =>
[ip_address] => 2.100.154.5 - 2.100.154.5
)
[totals] => Array
(
)
[products] => Array
(
[0] => Array
(
[qty] => 1
[name] => NaturaCalc Limestone Flour 900g calcium source for horses
[model] => 5060163931912
[tax_groups] => Array
(
[0] => Sales Tax
)
[tax_description] => Sales Tax
[price] => 2.5000
[final_price] => 2.5
[onetime_charges] => 0
[weight] => 900
[products_priced_by_attribute] => 0
[product_is_free] => 0
[products_discount_type] => 0
[products_discount_type_from] => 0
[id] => 827
[rowClass] => rowEven
[tax] => 0
)
)
[customer] => Array
(
[firstname] =>
[lastname] =>
[company] =>
[street_address] =>
[suburb] =>
[city] =>
[postcode] =>
[state] =>
[zone_id] =>
[country] => Array
(
[id] =>
[title] =>
[iso_code_2] =>
[iso_code_3] =>
)
[format_id] => 0
[telephone] =>
[email_address] =>
)
[delivery] => Array
(
[firstname] =>
[lastname] =>
[company] =>
[street_address] =>
[suburb] =>
[city] =>
[postcode] =>
[state] =>
[zone_id] =>
[country] => Array
(
[id] =>
[title] =>
[iso_code_2] =>
[iso_code_3] =>
)
[country_id] =>
[format_id] => 0
)
[content_type] => physical
[email_low_stock] =>
[products_ordered_attributes] =>
[products_ordered] =>
[products_ordered_email] =>
[attachArray] =>
[billing] => Array
(
[firstname] =>
[lastname] =>
[company] =>
[street_address] =>
[suburb] =>
[city] =>
[postcode] =>
[state] =>
[zone_id] =>
[country] => Array
(
[id] =>
[title] =>
[iso_code_2] =>
[iso_code_3] =>
)
[country_id] =>
[format_id] => 0
)
)
=================================
Aug-15-2014 13:00:51 (1408104051)
ec_step2_finish - 1
START: paypal_ec_payer_info= Array
(
[payer_id] => 8VKCVE6H4L8QQ
[payer_email] => [email protected]
[payer_salutation] =>
[payer_gender] =>
[payer_firstname] => John
[payer_lastname] => Doe
[payer_business] =>
[payer_status] => verified
[ship_country_code] =>
[ship_address_status] => N
[ship_phone] =>
[order_comment] =>
[ship_name] => Name
[ship_street_1] => 1 High Street
[ship_street_2] => Lovedean
[ship_city] => Waterlooville
[ship_state] => Hampshire
[ship_postal_code] => PO1 1AA
[ship_country_name] => GB
)
=================================
Aug-15-2014 13:00:51 (1408104051)
ec_step2_finish - 2
country_id = 222 GB GB
address_format_id = 6
state_id = 245 (original state tested: Hampshire)
country1->fields['countries_id'] = 222
country2->fields['countries_id'] =
$order->customer = Array
(
[firstname] =>
[lastname] =>
[company] =>
[street_address] => 1 High Street
[suburb] => Lovedean
[city] => Waterlooville
[postcode] => PO1 1AA
[state] => Hampshire
[zone_id] => 245
[country] => Array
(
[id] => 222
[title] => GB
[iso_code_2] => GB
[iso_code_3] => GBR
)
[format_id] => 6
[telephone] =>
[email_address] => [email protected]
[name] => John Doe
)
=================================
Aug-15-2014 13:00:51 (1408104051)
update_status
Module disabled because purchase amount is set to 0.00.
order Object
(
[info] => Array
(
[order_status] => 2
[currency] => GBP
[currency_value] => 1.00000000
[payment_method] => PayPal
[payment_module_code] => paypalwpp
[coupon_code] =>
[shipping_method] =>
[shipping_module_code] =>
[shipping_cost] => 0
[subtotal] => 2.5
[shipping_tax] => 0
[tax] => 0
[total] =>
[tax_groups] => Array
(
[0] => 0
)
[comments] =>
[ip_address] => 2.100.154.5 - 2.100.154.5
)
[totals] => Array
(
)
[products] => Array
(
[0] => Array
(
[qty] => 1
[name] => NaturaCalc Limestone Flour 900g calcium source for horses
[model] => 5060163931912
[tax_groups] => Array
(
[0] => Sales Tax
)
[tax_description] => Sales Tax
[price] => 2.5000
[final_price] => 2.5
[onetime_charges] => 0
[weight] => 900
[products_priced_by_attribute] => 0
[product_is_free] => 0
[products_discount_type] => 0
[products_discount_type_from] => 0
[id] => 827
[rowClass] => rowEven
[tax] => 0
)
)
[customer] => Array
(
[firstname] =>
[lastname] =>
[company] =>
[street_address] => 1 High Street
[suburb] => Lovedean
[city] => Waterlooville
[postcode] => PO1 1AA
[state] => Hampshire
[zone_id] => 245
[country] => Array
(
[id] => 222
[title] => GB
[iso_code_2] => GB
[iso_code_3] => GBR
)
[format_id] => 6
[telephone] =>
[email_address] => [email protected]
[name] => John Doe
)
[delivery] => Array
(
[firstname] =>
[lastname] =>
[company] => Name
[street_address] => 1 High Street
[suburb] => Lovedean
[city] => Waterlooville
[postcode] => PO1 1AA
[state] => Hampshire
[zone_id] => 245
[country] => Array
(
[id] => 222
[title] => GB
[iso_code_2] => GB
[iso_code_3] => GBR
)
[country_id] => 222
[format_id] => 6
[name] => Name
)
[content_type] => physical
[email_low_stock] =>
[products_ordered_attributes] =>
[products_ordered] =>
[products_ordered_email] =>
[attachArray] =>
[billing] => Array
(
[firstname] =>
[lastname] =>
[company] =>
[street_address] => 1 High Street
[suburb] => Lovedean
[city] => Waterlooville
[postcode] => PO1 1AA
[state] => Hampshire
[zone_id] => 245
[country] => Array
(
[id] => 222
[title] => GB
[iso_code_2] => GB
[iso_code_3] => GBR
)
[country_id] =>
[format_id] => 6
[name] => John Doe
)
)
=================================
Aug-15-2014 13:00:51 (1408104051)
termEC-1
Killed the session vars as requested
=================================
Aug-15-2014 13:00:51 (1408104051)
termEC-2
BEFORE: $this->showPaymentPage = 1
Token Data:
=================================
Aug-15-2014 13:00:51 (1408104051)
termEC-3
AFTER: $this->showPaymentPage = 1
=================================
Aug-15-2014 13:00:51 (1408104051)
termEC-9
We are NOT logged in, so set snapshot to Shipping page, and redirect to login
=================================
Aug-15-2014 13:00:51 (1408104051)
termEC-10
Redirecting to login - Stack: login
Message: We are sorry for the inconvenience; however, at the present time we are unable to use PayPal to process orders from the geographic region you selected as your PayPal address. Please continue using normal checkout and select from the available payment methods to complete your order.
Session Data: Array
(
[securityToken] => xxxxxxxx
[customers_host_address] => host-2-100-154-3.as13285.net
[cartID] =>
[cart] => shoppingCart Object
(
[contents] => Array
(
[827] => Array
(
[qty] => 1
)
)
[total] => 2.5
[weight] => 900
[cartID] => 92217
[content_type] => physical
[free_shipping_item] => 0
[free_shipping_weight] => 0
[free_shipping_price] => 0
[download_count] => 0
[total_before_discounts] => 2.5
[display_debug_messages] =>
[flag_duplicate_msgs_set] =>
)
[language] => english
[languages_id] => 1
[languages_code] => en
[check_valid] => true
[navigation] => navigationHistory Object
(
[path] => Array
(
[0] => Array
(
[page] => products_all
[mode] => NONSSL
[get] => Array
(
[zenid] => lph3chphiht7rbu9cnich9q4v5
[disp_order] => 3
)
[post] => Array
(
)
)
[1] => Array
(
[page] => product_info
[mode] => NONSSL
[get] => Array
(
[action] => add_product
[products_id] => 827
[cPath] => 59_460
)
[post] => Array
(
)
)
[2] => Array
(
[page] => shopping_cart
[mode] => NONSSL
[get] =>
[post] => Array
(
)
)
[3] => Array
(
[page] => checkout_shipping
[mode] => SSL
[get] =>
[post] => Array
(
)
)
[4] => Array
(
[page] => login
[mode] => SSL
[get] =>
[post] => Array
(
)
)
[5] => Array
(
[page] => index
[mode] => SSL
[get] => Array
(
[type] => ec
[token] => EC-6C669426ST099853X
[PayerID] => 8VKCVE6H4L8QQ
)
[post] => Array
(
)
)
)
[snapshot] => Array
(
[page] => index
[mode] => SSL
[get] => Array
(
[type] => ec
[token] => EC-6C669426ST099853X
[PayerID] => 8VKCVE6H4L8QQ
)
[post] => Array
(
)
)
)
[currency] => GBP
[today_is] => 2014-08-15
[updateExpirations] => 1
[session_counter] => 1
[customers_ip_address] => 2.100.154.5
[new_products_id_in_cart] => 827
[valid_to_checkout] => 1
[cart_errors] =>
[payment] => paypalwpp
[messageToStack] => Array
(
[0] => Array
(
[class] => login
[text] => We are sorry for the inconvenience; however, at the present time we are unable to use PayPal to process orders from the geographic region you selected as your PayPal address. Please continue using normal checkout and select from the available payment methods to complete your order.
[type] => error
)
)
)
=================================
I hope that's enough for you Dr Byte
New Zenner
BUMP !
Could I have some feedback please.
FYI:- I'm getting this "We are sorry for the inconvenience; however, at the present time we are unable to use PayPal to process orders from the geographic region you selected as your PayPal address. Please continue using normal checkout and select from the available payment methods to complete your order." UK Customer, UK Store with V1.53, logs are above.
New Zenner
Thanks DB, I found changing PayPal Mode from Payflow UK to 1: Paypal resolved the problem.
Totally Zenned
greentrees, doesn't that mean you weren't using payflow any longer?
The full-time Zen Cart Guru. WizTech4ZC.com
New template for 2.0 viewable here: 2.0 Demo
Totally Zenned
Experiencing the same issues on a clean install of Zen 1.5.4.
Dr Byte:
Chris,
This is on a development server so you could have complete access both admin and ftp if you wanted to have a look. Send me a PM if that is of any interest to you. I can confirm that moving the bracket as suggested resolves the issue. Very strange ...
Let me know if you want to have a peek.
Nick
iszent.com
Totally Zenned
My client turned off the cardinal part in order for it to work.
The full-time Zen Cart Guru. WizTech4ZC.com
New template for 2.0 viewable here: 2.0 Demo
Totally Zenned
Delia,
That might well work. But it is not an ideal solution for a PCI compliant user. And this error is on a straight-out-of-the-box installation. I am sure that it is configuration/server dependent as not all people can be experiencing it otherwise the forum would be much noisier. But nonetheless we need to find a solution that does not involve disabling chunks of card security.
I can get it to work by editing the module as described above. But like others who look at this code I have to say that I am puzzled about how that change can actually resolve the issue. Dr Byte is much more knowledgeable than I am regarding the Paypal system so ...
Nick
iszent.com
Sensei
Can you try this fix, and report back if the problem still persists?
https://www.zen-cart.com/showthread.php?215694-Known-Bugs-%28and-fixes%29-with-v1-5-4&p=1283514#post1283514
.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole
Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.
Totally Zenned
Yup. That works fine.
Nick
iszent.com
Totally Zenned
Thanks - I couldn't find that post and after posting and PMs, no one told me.
The full-time Zen Cart Guru. WizTech4ZC.com
New template for 2.0 viewable here: 2.0 Demo
Tell staff why this post should be reviewed.