(10401) order error with one language, other two works fine

RodG:

See Post#3
This has come a full circle. PayPal is a 'red herring'.

I thought you may be onto something with the prices though.

Summary: (See Post#13).
Problem only occurs with some existing products in the store.
There are 3 languages being used (English, German, Hungarian). The problem only occurs when using Hungarian language.
Problem is not in the language files.
I'm 99% convinced its a character encoding issue.

Cheers
Rod

**Hi Rod!

i just wrote to paypal technical support (pasting the log file) as DrByte suggested. Hopefully they tell
something useful.
How can i set to find out this character encoding issue? So tha language files ar all right.
In the meantime i'm facing another problem. If a costumer registers, welcome emails are sent out in german and english but not hungarian, please check:

http://www.zen-cart.com/showthread.php?206929-costumer-account-reg-email-sent-in-two-languages-but-not-the-third

Trying to find out here too, what can be wrong, till now havent been able to find the file(s) regarding this problem.
But it is again only a hungarian language issue. Maybe only a welcome text is not written (though i havent found the english and german text yet) or something in admin is not set, or maybe...well not easy.

The site doesnt like the three languages together...

thanks

Nandor**

RodG:

I'm 99% convinced its a character encoding issue.
I was considering that, especially since the transmitted customer name has multibyte characters: [SHIPTONAME] => Enikö Szögeczki

It would be worth testing a transaction where all characters come from the basic english alphabet, in an effort to partially rule out multibyte characters as the cause.

DrByte:

I was considering that, especially since the transmitted customer name has multibyte characters: [SHIPTONAME] => Enikö Szögeczki

It would be worth testing a transaction where all characters come from the basic english alphabet, in an effort to partially rule out multibyte characters as the cause.

**Created a new costumer:

Clinton Bill
Fifth Avenue 5000
New York City, NY 14199
United States

that is definitely english name. But the same error happens, this 10401 when ordering (rather trying) and again no welcome email is sent to costumer (did the registration in hungarian and shopping also in hungarian, of course)

thanks

Nandor**

There were a number of PayPal issues fixed between 1.3.9e and 1.3.9h. It would be really helpful if you would upgrade your site to 1.3.9h

DrByte:

There were a number of PayPal issues fixed between 1.3.9e and 1.3.9h. It would be really helpful if you would upgrade your site to 1.3.9h

Do you have some forum topics about this upgrading?

thanks

Nandor

Do you have some forum topics about this upgrading?
Between 1.3.9e and 1.3.9h there are just updated files
In the docs there is a changed file log you can review

kobra:

Between 1.3.9e and 1.3.9h there are just updated files
In the docs there is a changed file log you can review

The are files till : 1.3.9e

like :

changelog-v1-3-9e.html
whatsnew_1.3.9e.html

So there "e" is the highest.

thanks

Nandor

It was all documented and posted on the forum back when those releases were published several years ago. And the information is also in the /docs/ folder of each release.

Summary:
-download 1.3.9h, unzip
-read the /docs/changed_files_for_139f.html and copy those files over to your site
-read the /docs/changed_files_for_139g.html and copy those files over to your site
-read the /docs/changed_files_for_139h.html and copy those files over to your site
Of course, every time you replace a file, if you've made any changes to that file (or any addons you're using have changed that file), then you'll need to manually re-merge your changes into that file.

DrByte:

It was all documented and posted on the forum back when those releases were published several years ago. And the information is also in the /docs/ folder of each release.

Summary:
-download 1.3.9h, unzip
-read the /docs/changed_files_for_139f.html and copy those files over to your site
-read the /docs/changed_files_for_139g.html and copy those files over to your site
-read the /docs/changed_files_for_139h.html and copy those files over to your site
Of course, every time you replace a file, if you've made any changes to that file (or any addons you're using have changed that file), then you'll need to manually re-merge your changes into that file.

honestly i dont find from where to download this....
thanks
Nandor

DrByte:

I was considering that, especially since the transmitted customer name has multibyte characters: [SHIPTONAME] => Enikö Szögeczki
It would be worth testing a transaction where all characters come from the basic english alphabet, in an effort to partially rule out multibyte characters as the cause.

You're so close, but not from the customer name. It's from the product name, and when present is causing a part of the PayPal array to fail.

[L_NAME0] => Engel Anh*#228;nger

This one went OK. The 'faulty' ones cause the data to be missing completely (hard to see what isn't there), and that's what paypal is complaining about.

The solution is to still fix the (dozen or so) products the were inserted into the store before the character set was changed.

Cheers
Rod

RodG:

You're so close, but not from the customer name. It's from the product name, and when present is causing a part of the PayPal array to fail.

[L_NAME0] => Engel Anh*#228;nger

This one went OK. The 'faulty' ones cause the data to be missing completely (hard to see what isn't there), and that's what paypal is complaining about.

The solution is to still fix the (dozen or so) products the were inserted into the store before the character set was changed.

Cheers
Rod

hello Rod!

do you say that i should remove the products, subcategories and categories and upload them again?
I tried that this week : removed all pendants (these were the ones that didnt work), its category too, and uploaded again. This time with two subcategories and one product and it still doesnt work.
Or do you say that i should make a "deeper" removing? Though i dont know how to do that.

By the way, do you think that this problem has to do anything with the email sending problem?
(linked in a previous posting)

thanks in advance

Nandor

RodG:

You're so close, but not from the customer name. It's from the product name, and when present is causing a part of the PayPal array to fail.

[L_NAME0] => Engel Anh*#228;nger

This one went OK. The 'faulty' ones cause the data to be missing completely (hard to see what isn't there), and that's what paypal is complaining about.Fair, and I looked for that, but the logs posted showed that ZC had already stripped the L_xxxx items because of a math problem, and was only passing the AMT, which shouldn't have any reason to fail if there's no line items passed with it.
ref: > Request Parameters: {SetExpressCheckout}
Array
(
[PAYMENTACTION] => Sale
[ALLOWNOTE] => 1
[LANDINGPAGE] => Billing
[ADDROVERRIDE] => 1
[SHIPTONAME] => Enikö Szögeczki
[SHIPTOSTREET] => Sport Str. 12.
[SHIPTOCITY] => Felsozsolca
[SHIPTOZIP] => 3561
[SHIPTOSTATE] => B.-A.-Z.
[SHIPTOCOUNTRYCODE] => HU
[EMAIL] => szeniko81##########################
[PHONENUM] => 06703777283
[AMT] => 2,377.20
[RETURNURL] => http://szeghalmys.com/ipn_main_handler.php?type=ec
[CANCELURL] => http://szeghalmys.com/index.php?main_page=checkout_shipping&ec_cancel=1
[PAGESTYLE] => Primary
[METHOD] => SetExpressCheckout
[CURRENCYCODE] => HUF
[USER] => info_api1.szeghalmys.com
[PWD] => ****************
[VERSION] => 60.0
[SIGNATURE] => ****************************************************DI7K
)

Response:
Array
(
[TIMESTAMP] => 2013-03-08T04:51:02Z
[CORRELATIONID] => 739a84dee3c8a
[ACK] => Failure
[VERSION] => 60.0
[BUILD] => 5331358
[L_ERRORCODE0] => 10401
[L_SHORTMESSAGE0] => Transaction refused because of an invalid argument. See additional error messages for details.
[L_LONGMESSAGE0] => Order total is invalid.
[L_SEVERITYCODE0] => Error
[CURL_ERRORS] =>
)

RodG:

The solution is to still fix the (dozen or so) products the were inserted into the store before the character set was changed.
Ya, always good to clean up bad data.

Nandor, you can simply manually edit the names and descriptions of those old products to fix them.

Nandor:

honestly i dont find from where to download this....
There's a download link on the home page of www.zen-cart.com: http://sourceforge.net/projects/zencart/files/

DrByte:

Fair, and I looked for that, but the logs posted showed that ZC had already stripped the L_xxxx items because of a math problem

I didn't spot the math problem. Well, I did see "Order total is invalid", but since I'd been following this trail from paypal->languages-hungarian->categories->products->existing_products_only, I assumed product title language problem. <naturally?> I'd ruled out the 'math lead' figuring that this would be the same regardless of language (other than magnitude and /or exchange rate differences).

Another clue perhaps?

Oh, mustn't forget. The same products get processed correctly with other payment methods.

Thanks for joining in. Already a fresh set of eyes has been useful. (probably more to me than Nandor).

Hmm, @Nandor. Have you made any changes to your currency settiings, exchange rates? Zone or Tax settings? Perhaps your inability to use anything less than 1.00EU is also a bigger clue than I 1st thought.

Cheers
Rod

Nandor:

do you say that i should remove the products, subcategories and categories and upload them again?

This depends on how to 'uploaded' them, and exactly what it was to were attempting to upload.

Nandor:

I tried that this week : removed all pendants (these were the ones that didnt work), its category too, and uploaded again. This time with two subcategories and one product and it still doesnt work.

Just to confirm. Can you still add a new product and have this working ok?

Nandor:

Or do you say that i should make a "deeper" removing? Though i dont know how to do that.

I was thinking you should delete/drop the product table and recreating it (assuring the correct character set is used). I really don't want to hold you hand with this though.

My main concern now is your use of the term 'upload'? For example, you don't 'upload' categories. They are defined/created on the server itself.

If you are using an import/export tool, don't. At least not yet, and definitely not with the product data being used for testing. This could have us going around in circles for ages.

Nandor:

By the way, do you think that this problem has to do anything with the email sending problem?
(linked in a previous posting)

Generally speaking I'd say no, BUT, if you find the email sending problem is only to some customers, and you also find that these some customers have purchased the item(s) identified as causing an issue, then I have to say Yes, definitely, related.

Cheers
Rod

RodG:

This depends on how to 'uploaded' them, and exactly what it was to were attempting to upload.

Just to confirm. Can you still add a new product and have this working ok?

I was thinking you should delete/drop the product table and recreating it (assuring the correct character set is used). I really don't want to hold you hand with this though.

My main concern now is your use of the term 'upload'? For example, you don't 'upload' categories. They are defined/created on the server itself.

If you are using an import/export tool, don't. At least not yet, and definitely not with the product data being used for testing. This could have us going around in circles for ages.

Generally speaking I'd say no, BUT, if you find the email sending problem is only to some customers, and you also find that these some customers have purchased the item(s) identified as causing an issue, then I have to say Yes, definitely, related.

Cheers
Rod

**I changed the charset and setlocale in all language php files (admin and icludes too) to utf-8. Created some new products. Cant shop in hungarian with paypal in first two categories (pendants, bracelets) other are ok.
One thing changed, in admin dont have to use numerical codes and still the names, descriptions appear correctly on sites in german and hungarian.
Still no registration welcome email goes out in hungarian.

I just chose the wrong word. Didnt upload, created. Dont know the export/import tool.

Email sending problem is to all costumers, who register in hungarian language.

thanks

Nandor**

Nandor:

**I changed the charset and setlocale in all language php files (admin and icludes too) to utf-8. Created some new products. Cant shop in hungarian with paypal in first two categories (pendants, bracelets) other are ok.
One thing changed, in admin dont have to use numerical codes and still the names, descriptions appear correctly on sites in german and hungarian.
Still no registration welcome email goes out in hungarian.

I just chose the wrong word. Didnt upload, created. Dont know the export/import tool.

Email sending problem is to all costumers, who register in hungarian language.

thanks

Nandor**

**Hello My Dear Experts!
i dont know if you still have the nerve to deal with my problems.....

Bt i think i managed to figure out the problem with shopping in hungarian with paypal. It had (maybe) nothing to do with the language. - though there were/are some language problems.

There is a problem with the prices or something like that. In admin i give the prices in euro and if a price can be divided by 5 than it is ok in all three languages, like this: 5.15 / 3.45 / 9.55...etc.

But if it is 5.49 or 1.99 or 3.33 - in this case you cannot buy in hungarian language , in HUF of course.

Because it is set like - euro from european countries and hungarian forint for buyers from hungary.

Maybe it cannot deal with these numbers? or maybe it is just the setting.

Unfortunately i still have no idea what can be wrong with the welcome email sending problem in haungarian, of course....

thanks
Nandor**

Nandor:

i dont know if you still have the nerve to deal with my problems.....

LOL. We don't give up easily. :)

Nandor:

Bt i think i managed to figure out the problem with shopping in hungarian with paypal. It had (maybe) nothing to do with the language. - though there were/are some language problems.

There is a problem with the prices or something like that. In admin i give the prices in euro and if a price can be divided by 5 than it is ok in all three languages, like this: 5.15 / 3.45 / 9.55...etc.

So it seem DrByte has done it again.... A math problem. eh? (but only hungarian?).

Nandor:

But if it is 5.49 or 1.99 or 3.33 - in this case you cannot buy in hungarian language , in HUF of course.
Maybe it cannot deal with these numbers? or maybe it is just the setting.

I've no explanation for this.

Nandor:

Unfortunately i still have no idea what can be wrong with the welcome email sending problem in hangarian, of course....

I have to admit, I've not been following the thread with your email problems, that'll almost certainly have a different cause, and it is best to treat them separately.

Cheers
Rod

RodG:

LOL. We don't give up easily. :)

So it seem DrByte has done it again.... A math problem. eh? (but only hungarian?).

I've no explanation for this.

I have to admit, I've not been following the thread with your email problems, that'll almost certainly have a different cause, and it is best to treat them separately.

Cheers
Rod

**Hello!

Thanks for your help in this issue!

You're really the best! I dont know how i'd have solved it wihout your help!

Nandor**