This transaction is invalid - Paypal express

Hi Ajeh,

Everything appears fine with his address. I only edited the stuff in your quote because of privacy reasons.

This particular customer says he pays with PayPal all the time on other websites, so he's not new to the process.

I am at a loss. I have the latest ZenCart, the latest PPEC patch from 2/8/07, and now I am getting absolutely no PayPal orders. I cannot test it myself because PayPal won't allow you to buy something from yourself. However, if I pretend to checkout and select the PayPal Express option, it does take me to the PayPal login page.

So I don't know. I turned off debugging because I was literally getting 100+ emails per transaction. I will turn it back on if there is a particular message you want me to get for you.

• Jeff

Ajeh:

Jeff ... can you check this guys customer records and make sure all settings are correct?
'SHIPTONAME' => 'Harold JXXbs',
'SHIPTOSTREET' => '1XXX2 Addison St.',
'SHIPTOSTREET2' => '',
'SHIPTOCITY' => 'North Hollywood',
'SHIPTOZIP' => '91607',
'SHIPTOSTATE' => 'CA',
'SHIPTOCOUNTRY' => 'US',
'EMAIL' => '[email protected]',

You have an upgraded site if I am not mistaken and we just want to check you don't have a customer with a goober address with invalid data or ids ... :)

Just had another failure. Here is the exact subject line for EACH email message that I have, in case you want to see a certain one:\

09:02:46 AM   	   	PayPal Debug log - GetTransactionDetails
09:04:54 AM   	   	PayPal Debug log - GetTransactionDetails
09:05:04 AM   	   	PayPal Debug log - GetTransactionDetails
09:05:11 AM   	   	PayPal Debug log - GetTransactionDetails

The very last email that we got (listed above) looks like this:

2007-02-15 09:05:11

(live transaction) --> https://api-3t.paypal.com/nvp
Request Headers: array (
0 => 'Content-Type: text/namevalue',
1 => 'X-VPS-Timeout: 45',
2 => 'X-VPS-VIT-Client-Type: PHP/cURL',
3 => 'X-VPS-VIT-Integration-Product: PHP::Zen Cart - WPP-NVP',
4 => 'X-VPS-VIT-Integration-Version: 0.1',
)

Request Parameters: {GetTransactionDetails} array (
'TRANSACTIONID' => '9DE9347643781643K',
'METHOD' => 'GetTransactionDetails',
'USER' => 'customerservice_api1.mjmmagic.com',
'PWD' => '****************',
'VERSION' => '2.3',
'SIGNATURE' => '****************************************************vHb3',
)

Response: array (
'TIMESTAMP' => '2007-02-15T17:05:16Z',
'CORRELATIONID' => '3a023eb65fe8',
'ACK' => 'Success',
'VERSION' => '2.300000',
'BUILD' => '1.0006',
'RECEIVEREMAIL' => '[email protected]',
'RECEIVERID' => 'XY7XF94D5AWKQ',
'EMAIL' => '[email protected]',
'PAYERID' => 'S7CD9WJ9JWK2A',
'PAYERSTATUS' => 'verified',
'FIRSTNAME' => 'kim',
'LASTNAME' => 'doe',
'COUNTRYCODE' => 'US',
'NAME' => 'kim doe',
'SHIPTOSTREET' => '123 cumpston street',
'SHIPTOCITY' => 'n hollywood',
'SHIPTOSTATE' => 'CA',
'SHIPTOCOUNTRYCODE' => 'US',
'SHIPTOCOUNTRYNAME' => 'United States',
'SHIPTOZIP' => '91601',
'ADDRESSID' => 'PayPal',
'ADDRESSSTATUS' => 'Confirmed',
'TRANSACTIONID' => '9DE9347643781643K',
'TRANSACTIONTYPE' => 'expresscheckout',
'PAYMENTTYPE' => 'instant',
'ORDERTIME' => '2007-02-12T23:17:57Z',
'AMT' => '14.11',
'CURRENCYCODE' => 'USD',
'FEEAMT' => '0.71',
'TAXAMT' => '0.00',
'PENDINGREASON' => 'None',
'REASONCODE' => 'None',
'SALESTAX' => '0.00',
'L_QTY0' => '1',
)

Like the others, we do not get this order. Nothing is put in our paypal account, and nothing comes to Zencart.

Here's another one with the subject line of termEC-10

Subject: termEC-10

Redirecting to checkout_payment - Stack: checkout_payment
Message: We were not able to process your order. Please try again, select an
alternate payment method, or contact the store owner for assistance.
(Invalid Parameter)
Session Data: Array
(
[customers_host_address] => modemcable171.36-57-74.mc.videotron.ca
[cartID] =>
[cart] => shoppingcart Object
(
[observers] => Array
(
)

        [contents] => Array
            (
                [6] => Array
                    (
                        [qty] => 1
                    )

            )

        [total] => 3.95
        [weight] => 0.15
        [cartID] =>
        [content_type] => physical
        [free_shipping_item] => 0
        [free_shipping_weight] => 0
        [free_shipping_price] => 0
    )

[navigation] => navigationhistory Object
    (
        [observers] => Array
            (
            )

        [path] => Array
            (
                [0] => Array
                    (
                        [page] => index
                        [mode] => SSL
                        [get] => Array
                            (
                                [type] => ec
                                [token] => EC-0CB60468SB455715E
                                [PayerID] => 2WGDL9JMFD58S
                            )

                        [post] => Array
                            (
                            )

                    )

                [1] => Array
                    (
                        [page] => checkout_shipping
                        [mode] => SSL
                        [get] =>
                        [post] => Array
                            (
                            )

                    )

                [2] => Array
                    (
                        [page] => checkout_payment
                        [mode] => SSL
                        [get] =>
                        [post] => Array
                            (
                            )

                    )

                [3] => Array
                    (
                        [page] => checkout_confirmation
                        [mode] => SSL
                        [get] =>
                        [post] => Array
                            (
                            )

                    )

                [4] => Array
                    (
                        [page] => checkout_process
                        [mode] => SSL
                        [get] =>
                        [post] => Array
                            (
                            )

                    )

            )

        [snapshot] => Array
            (
            )

    )

[check_valid] => true
[language] => english
[languages_id] => 1
[languages_code] => en
[currency] => USD
[updateExpirations] => 1
[session_counter] => 1
[customers_ip_address] => 74.57.36.171
[new_products_id_in_cart] =>
[valid_to_checkout] => 1
[cart_errors] =>
[cart_country_id] => 38
[country_info] => Array
    (
        [countries_name] => Canada
        [countries_iso_code_2] => CA
        [countries_iso_code_3] => CAN
    )

[cart_zone] => 76
[cart_zip_code] => j9h2n8
[cart_sid] => zones_zones
[payment] => paypalwpp
[customer_guest_id] => 2969
[customer_id] => 2969
[customer_default_address_id] => 3874
[customer_first_name] => arthur
[customer_country_id] => 38
[customer_zone_id] => 76
[sendto] => 3874
[billto] => 3874
[shipping] => Array
    (
        [id] => zones_zones
        [title] => Special Rates (Shipping to CA)
        [cost] => 0
    )

[cot_gv] => 0
[comments] =>
[messageToStack] => Array
    (
        [0] => Array
            (
                [class] => checkout_payment
                [text] => We were not able to process your order. Please

try again, select an alternate payment method, or contact the store owner
for assistance. (Invalid Parameter)
[type] => error
)

    )

)

I don't know if this makes any difference, but even on a failed transaction an account is created.

The account is missing the * required phone number.

Hmmm, I wonder if you are onto something here. I just noticed an automatically created account as well, where the phone number and the date of birth are missing, both required fields.

burk:

I don't know if this makes any difference, but even on a failed transaction an account is created.

The account is missing the * required phone number.

If this helps, here is where the process seems to go FUBAR. This is a direct quote from one of our customers:

"it brings me to the paypal site and then it tells me all the info like who im
buying it from (MJM Magic) and stuff like that, and then i click pay now and it
re-directs me to the MJM Magic website saying the invalid parimeter.. this never happend before i've ordered from you guys plenty of times."

I'm guessing that the problem is in passing the country. IIRC, PayPal doesn't pass the country at all times when it's the US for a US account ... it used to. With IPN the country is already in zencart.

Just remembered a few months ago a question on one of the eBay boards - "where is Saskatchewan?", apparently PayPal didn't pass Canada in the notification.

Jeff_Mash:

Subject: PayPal Debug log - DoExpressCheckoutPayment

'SHIPTOCOUNTRY' => '',

'ACK' => 'Failure',
'L_ERRORCODE0' => '81210',
'L_SHORTMESSAGE0' => 'Invalid Parameter',
'L_LONGMESSAGE0' => 'Country : Invalid Parameter',
'L_SEVERITYCODE0' => 'Error',

This appears to have been caused by a PayPal system update with a keyword change from SHIPTOCOUNTRY to SHIPTOCOUNTRYCODE
The fix is posted here:
http://www.zen-cart.com/forum/showthread.php?p=330003#post330003

Yep the update seems to be working!! Woot :D

Another small error customers might get is if they provide an address that doesnt match up to the one on paypal... also make sure its the primary address on your site... Anyway Thanks for the patch Drbyte

Hi DrByte

I have applied the patch look at ever1 else’s faults but still the problem hasn’t been solved for me… I’m wondering if you mite have any ideas or can see any reasons in my debug posts that mite help me work this out.

Thanks
n350zz

n350zz:

Hi :D

I also get a lot of emails (eleven in total)… I have listed all eleven as plain txt files in a zip folder.

Thanks
n350zz

Your site is attempting to communicate with PayPal using an SSL connection (as required by PayPal, since you're sharing sensitive data with them), but your server cannot use SSL over CURL unless your webhost recompiles it to support SSL.
The specific message, according to your logs, is:

(1) libcurl was built with SSL disabled, https: not supported!
You will need to resolve that problem on your host's server, or select another hosting company, before you can use this payment option.

DrByte:

This appears to have been caused by a PayPal system update with a keyword change from SHIPTOCOUNTRY to SHIPTOCOUNTRYCODE
The fix is posted here:
http://www.zen-cart.com/forum/showthread.php?p=330003#post330003

I just wanted to say that after applying this patch to fix the country code, I am getting the paypal orders again with no complaints of failures. I will keep knocking on wood, keeping my fingers crossed, rubbing my rabbit's foot, etc!

Thanks for the continual top-notch support!

Oh praise the coding gods and goddess ...
:onfire: :onfire: :onfire:

Thanks DrByte

One last thing I have spoken to my web host and he’s telling me I need to purchase an SSL certificate for my web site privately and then install it into my control panel, but reading your reply I’m not shore if your telling me the same thing or suggesting that the cURL is installed with SSL disabled and my host needs to reconfigure the cURL settings 2 include SSL to get things working.

Sorry if I sound a bit stupid but I’m really new to this
Thanks
Rich (n350zz)

Rich,
Your host will have to answer that question for you too.
It's possible that installing SSL to your domain may be sufficient to have their CURL application work, but I doubt it. The error message suggests that CURL is not "compiled" or "built" with SSL support, and thus cannot offer you any SSL/HTTPS communication support ... making it useless for sensitive data.

The "libcurl" error message discussed earlier does not necessarily mean that you need to install SSL to make things work. libcurl isn't "in" your own site ... it's part of the hosting server you're "on"... and if it's not setup right, you can't use it.

Don't let them make you buy a hugely expensive certificate either. Don't be afraid to shop around. They may charge to install it, but it only takes a minute to do it, so shouldn't need to be a huge cost. (now i'm digressing ... you can read more about SSL certs in other threads here, or elsewhere on the web)

I'm not sure if this is a red herring or not, but I had one United Kingdom customer tell me that when checking out using the ORANGE PayPal Express button on the shopping cart page, things work find.....but if she tries to checkout using the PayPal Express payment option on Step 2 of the checkout process, it doesn't work.

I can't verify whether that works or not, but I'm throwing it out there in case anyone else gets the same kind of feedback from their customers.

that is a correct observation of the problem

ok first pp ipn used to work with me but now it is giving the notorious "This transaction is invalid. Please return to the recipient's website to complete your transaction using their regular checkout flow." error...

I tried to install the latest three different patches (yes I rebooted from admin) but none of them did no good..

How can I fix this?!? this is really urgent so I definitely appreciate any help. I don't have SSL at the moment but I've been trying to get one from my host but their customer service isn't apparently the fastest one around...

many many thanks

nevermind

Has anyone got more information than what is on this thread. I am also getting the log messages indicating that "libcurl was built with SSL disabled, https: not
supported!"

I'm a little fuzzy on how the whole SSL certificate ties in to libcurl being compiled with SSL support. However in reading the CURL message, it doesn't sound like purchasing a certificate is going to do anything, since libcurl will still not have SSL enabled whether I have a certificate or not.

Another question is thus: Let's assume my hosting company fixes the libcurl minus SSL problem. Will I then need a certificate just to connect to PayPal's API?