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

[Nandor]

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

[DrByte]

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] =>
)

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.

[DrByte]

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/

[RodG]

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

[RodG]

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.

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?

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.

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

[Nandor]

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

[RodG]

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

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

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?).

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.

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

[Nandor]

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