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

Hi All!

Some days ago you helped me to solve order email, paypal express payment problem. It worked fine.
I was making trial orders to see if everything is fine and it was with two languages, but the third one.
The site has: english,german,hungarian language. The buying with english and german language works fine, but with the third,hungarian, language the costumer gets this message, attached a screenshot.

it says, if you cant read it, :

an error occured when we tried to contact the payment processor.please try again, select an alternate payment method, or contact the store owner for
assistance. (10401) 10401 Transaction refused because of an invalid argument.
See additional error messages for details-- Order total is invalid

plus i (admin) get this to email address:
10401 Transaction refused because of an invalid argument. See additional error messages for details. - Order total is invalid.

this is a log file of this transaction :

2013-03-08 05:47:44

(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(tm) - PayPal/NVP
[4] => X-VPS-VIT-Integration-Version: 1.3.9e
)

Request Parameters: {SetExpressCheckout}
Array
(
[AMT] => 8.49
[ITEMAMT] => 5.49
[SHIPPINGAMT] => 3.00
[L_NUMBER0] =>
[L_NAME0] => Engel Anh*#228;nger
[L_AMT0] => 5.49
[L_QTY0] => 1
[LOCALECODE] => DE
[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
[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] => EUR
[USER] => info_api1.szeghalmys.com
[PWD] => ****************
[VERSION] => 60.0
[SIGNATURE] => ****************************************************DI7K
)

Response:
Array
(
[TOKEN] => EC-9FF66947L86454734
[TIMESTAMP] => 2013-03-08T04:47:44Z
[CORRELATIONID] => f4dbd84ef391f
[ACK] => Success
[VERSION] => 60.0
[BUILD] => 5331358
[CURL_ERRORS] =>
)

SetExpressCheckout, Elapsed: 1483ms -- Success

thanks in advance

Nandor

sorry!!! this is the log file of the error order (the previous one was a fine one!) :

2013-03-08 05:51:02

(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(tm) - PayPal/NVP
[4] => X-VPS-VIT-Integration-Version: 1.3.9e
)

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

SetExpressCheckout, Elapsed: 1893ms -- Failure

TIMESTAMP=2013%2d03%2d08T04%3a51%3a02Z&CORRELATIONID=739a84dee3c8a&ACK=Failure&VERSION=60%2e0&BUILD=5331358&L_ERRORCODE0=10401&L_SHORTMESSAGE0=Transaction%20refused%20because%20of%20an%20invalid%20argument%2e%20See%20additional%20error%20messages%20for%20details%2e&L_LONGMESSAGE0=Order%20total%20is%20invalid%2e&L_SEVERITYCODE0=Error&CURL_ERRORS=

Nandor:

I was making trial orders to see if everything is fine and it was with two languages, but the third one.
The site has: english,german,hungarian language. The buying with english and german language works fine, but with the third,hungarian, language the costumer gets this message, attached a screenshot.
<snip>
this is a log file of this transaction :

The transaction with the error appears to be missing some important data. specifically:

[AMT] => x.xx
[ITEMAMT] => x.xx
[SHIPPINGAMT] => x.xx
[L_NUMBER0] =>
[L_NAME0] => xxxxxxxxxxxxxxxxx
[L_AMT0] => x.xx
[L_QTY0] => 1
[LOCALECODE] => DE

I copied this from the good transaction log. It is a part of the "Request Parameters: {SetExpressCheckout} Array"

The thing is though, I don't have any idea why this would be missing, and especially when only when the Hungarian language is enabled.

I assume that this is consistent and repeatable?

Cheers
Rod

RodG:

The transaction with the error appears to be missing some important data. specifically:

---

[AMT] => x.xx
[ITEMAMT] => x.xx
[SHIPPINGAMT] => x.xx
[L_NUMBER0] =>
[L_NAME0] => xxxxxxxxxxxxxxxxx
[L_AMT0] => x.xx
[L_QTY0] => 1
[LOCALECODE] => DE

I copied this from the good transaction log. It is a part of the "Request Parameters: {SetExpressCheckout} Array"

The thing is though, I don't have any idea why this would be missing, and especially when only when the Hungarian language is enabled.

I assume that this is consistent and repeatable?

Cheers
Rod

**Hi Rod!

thanks for your reply. I just made at least 10 trial purchase. the result : this error only occurs in hungarian language shopping and
whats more weird only in case of one category : pendants. Other categories like : rings, personalized, bangles...work well with all three languages!

**

Nandor:

** the result : this error only occurs in hungarian language shopping and
whats more weird only in case of one category : pendants. Other categories like : rings, personalized, bangles...work well with all three languages!
**

Well, that's really narrowed it down. A LOT.

At a guess, I'd have to say this is being caused by some sort of character encoding issue.. In other words, there is something in the hungarian language file(s) that is** only** being invoked by the pendants category (what makes that so 'special'?).

I think the way I'd be approaching this one would be

1. Make a backup of the hungarian language files.
2. Replace the originals, one at a time with the English (or german) files of the same name.
3. When the problem goes away you'll have identified the file causing the problem.
4. Restore all the original hungarian files from the backups.

5. Attempt to identify exactly what is amiss with the file you've identified. The fix will depend on the actual problem (obviously).

Hopefully this helps.

Cheers
Rod

RodG:

Well, that's really narrowed it down. A LOT.

At a guess, I'd have to say this is being caused by some sort of character encoding issue.. In other words, there is something in the hungarian language file(s) that is** only** being invoked by the pendants category (what makes that so 'special'?).

I think the way I'd be approaching this one would be

1. Make a backup of the hungarian language files.
2. Replace the originals, one at a time with the English (or german) files of the same name.
3. When the problem goes away you'll have identified the file causing the problem.
4. Restore all the original hungarian files from the backups.

5. Attempt to identify exactly what is amiss with the file you've identified. The fix will depend on the actual problem (obviously).

Hopefully this helps.

Cheers
Rod

Did you mean the language file php-s? there are a lot. or should i look for them in admin?
if i replace the one hungarian l. file with an english wont it crash or something?

thanks
Nandor

Nandor:

Did you mean the language file php-s? there are a lot.

Yes, thems the ones I meant. Yes, there are a lot. :(
Start with the 'obvious' or most likely ones first, namely, those dealing with the PayPal payments.

Nandor:

if i replace the one hungarian l. file with an english wont it crash or something?

No. It will simply display those particular pages in English rather than hungarian.

If you take a look at the contents of these files, you'll see that they are actually very simple in the way they are structured. They don't contain any actual code (or very little), just a lot of 'defines'.

These 'defines' will be near identical (other than the actual text component) regardless of the language.

For example: /languages/english/modules/payment/paypal.php contains:

define('MODULE_PAYMENT_PAYPAL_ENTRY_FIRST_NAME', 'First Name:');
define('MODULE_PAYMENT_PAYPAL_ENTRY_LAST_NAME', 'Last Name:');
define('MODULE_PAYMENT_PAYPAL_ENTRY_BUSINESS_NAME', 'Business Name:');
define('MODULE_PAYMENT_PAYPAL_ENTRY_ADDRESS_NAME', 'Address Name:');
define('MODULE_PAYMENT_PAYPAL_ENTRY_ADDRESS_STREET', 'Address Street:');
define('MODULE_PAYMENT_PAYPAL_ENTRY_ADDRESS_CITY', 'Address City:');
define('MODULE_PAYMENT_PAYPAL_ENTRY_ADDRESS_STATE', 'Address State:');

/languages/hungarian/modules/payment/paypal.php will contain:

define('MODULE_PAYMENT_PAYPAL_ENTRY_FIRST_NAME', 'First Name (in hungarian) :');
define('MODULE_PAYMENT_PAYPAL_ENTRY_LAST_NAME', 'Last Name (in hungarian):');
define('MODULE_PAYMENT_PAYPAL_ENTRY_BUSINESS_NAME', 'Business Name (in hungarian):');
define('MODULE_PAYMENT_PAYPAL_ENTRY_ADDRESS_NAME', 'Address Name (in hungarian):');
define('MODULE_PAYMENT_PAYPAL_ENTRY_ADDRESS_STREET', 'Address Street (in hungarian):');
define('MODULE_PAYMENT_PAYPAL_ENTRY_ADDRESS_CITY', 'Address City (in hungarian):');
define('MODULE_PAYMENT_PAYPAL_ENTRY_ADDRESS_STATE', 'Address State (in hungarian:');

/languages/binary/modules/payment/paypal.php (should such a language file exist) will contain:

define('MODULE_PAYMENT_PAYPAL_ENTRY_FIRST_NAME', '00010011000111000');
define('MODULE_PAYMENT_PAYPAL_ENTRY_LAST_NAME', '11000100011110000');
define('MODULE_PAYMENT_PAYPAL_ENTRY_BUSINESS_NAME', '101010111100000');

Note that in all cases, there is the 'english' component (in all upper case). These are a bit like 'placeholders' that is used throughout the zencart code, and then there is the actual text to be used whenever these 'placeholders' are found. If/when you replace the /hungarian/..../paypal.php file with the /english/.../paypal.php file the only difference is the text. Does that make sense?

I am working on the assumption that it is one of these hungarian language files that is causing your problem.

Cheers
Rod

RodG:

Yes, thems the ones I meant. Yes, there are a lot. :(
Start with the 'obvious' or most likely ones first, namely, those dealing with the PayPal payments.

No. It will simply display those particular pages in English rather than hungarian.

If you take a look at the contents of these files, you'll see that they are actually very simple in the way they are structured. They don't contain any actual code (or very little), just a lot of 'defines'.

These 'defines' will be near identical (other than the actual text component) regardless of the language.

For example: /languages/english/modules/payment/paypal.php contains:

define('MODULE_PAYMENT_PAYPAL_ENTRY_FIRST_NAME', 'First Name:');
define('MODULE_PAYMENT_PAYPAL_ENTRY_LAST_NAME', 'Last Name:');
define('MODULE_PAYMENT_PAYPAL_ENTRY_BUSINESS_NAME', 'Business Name:');
define('MODULE_PAYMENT_PAYPAL_ENTRY_ADDRESS_NAME', 'Address Name:');
define('MODULE_PAYMENT_PAYPAL_ENTRY_ADDRESS_STREET', 'Address Street:');
define('MODULE_PAYMENT_PAYPAL_ENTRY_ADDRESS_CITY', 'Address City:');
define('MODULE_PAYMENT_PAYPAL_ENTRY_ADDRESS_STATE', 'Address State:');

/languages/hungarian/modules/payment/paypal.php will contain:

define('MODULE_PAYMENT_PAYPAL_ENTRY_FIRST_NAME', 'First Name (in hungarian) :');
define('MODULE_PAYMENT_PAYPAL_ENTRY_LAST_NAME', 'Last Name (in hungarian):');
define('MODULE_PAYMENT_PAYPAL_ENTRY_BUSINESS_NAME', 'Business Name (in hungarian):');
define('MODULE_PAYMENT_PAYPAL_ENTRY_ADDRESS_NAME', 'Address Name (in hungarian):');
define('MODULE_PAYMENT_PAYPAL_ENTRY_ADDRESS_STREET', 'Address Street (in hungarian):');
define('MODULE_PAYMENT_PAYPAL_ENTRY_ADDRESS_CITY', 'Address City (in hungarian):');
define('MODULE_PAYMENT_PAYPAL_ENTRY_ADDRESS_STATE', 'Address State (in hungarian:');

---

/languages/binary/modules/payment/paypal.php (should such a language file exist) will contain:

define('MODULE_PAYMENT_PAYPAL_ENTRY_FIRST_NAME', '00010011000111000');
define('MODULE_PAYMENT_PAYPAL_ENTRY_LAST_NAME', '11000100011110000');
define('MODULE_PAYMENT_PAYPAL_ENTRY_BUSINESS_NAME', '101010111100000');

Note that in all cases, there is the 'english' component (in all upper case). These are a bit like 'placeholders' that is used throughout the zencart code, and then there is the actual text to be used whenever these 'placeholders' are found. If/when you replace the /hungarian/..../paypal.php file with the /english/.../paypal.php file the only difference is the text. Does that make sense?

I am working on the assumption that it is one of these hungarian language files that is causing your problem.

Cheers
Rod

**Hi Rod,

tried first /languages/english/modules/payment/paypal.php - replaced hungarian with english. nothing happened.

everything is the same. So i can buy with hungarian language, but only one category is problematic(pendants/angels). If the hungarian language php would be the problem couldnt i order nothing at all in hungarian?

havent found a file like this : languages/binary/modules/payment/paypal.php

do you think i should try replacing other language php-s?

or try searching elsewhere? How come that costumer can order bangles in hungarian, rings in hungarian but not pendants? Maybe when i uploaded this one category, did something different? The problem only comes with pendants shopping in hungarian with paypal.
In the meantime i enabled cash on delivery for a try. It is ok, all languages , all products can be bought. No problem with this. so definitely paypal, this one type of product and language.

Thanks in advance

Nandor**

Nandor:

**Hi Rod,

tried first /languages/english/modules/payment/paypal.php - replaced hungarian with english. nothing happened.

everything is the same. So i can buy with hungarian language, but only one category is problematic(pendants/angels). If the hungarian language php would be the problem couldnt i order nothing at all in hungarian?

havent found a file like this : languages/binary/modules/payment/paypal.php

do you think i should try replacing other language php-s?

or try searching elsewhere? How come that costumer can order bangles in hungarian, rings in hungarian but not pendants? Maybe when i uploaded this one category, did something different? The problem only comes with pendants shopping in hungarian with paypal.
In the meantime i enabled cash on delivery for a try. It is ok, all languages , all products can be bought. No problem with this. so definitely paypal, this one type of product and language.

Thanks in advance

Nandor**

I just saw that the error emails subject is :MODULE_PAYMENT_PAYPALWPP_TEXT_EMAIL_ERROR_SUBJECT (10401)

So i replaced the hungarian paypalwpp.php with the english.The problem is still the same. One thing changed. in hungarian a paypal button appeared, when shopping but as previously you cannot buy pendant in hungarian.
thought i finally found it......not

Nandor

Nandor:

Hi Rod,
tried first /languages/english/modules/payment/paypal.php - replaced hungarian with english. nothing happened.

Please define 'nothing' for me :)

Nandor:

everything is the same.

That would simply mean the hungarian file you replaced isn't/wasn't even being used in this part of the code processing.. If it was, the text would show in English rather than hungarian.

Nandor:

So i can buy with hungarian language, but only one category is problematic(pendants/angels). If the hungarian language php would be the problem couldnt i order nothing at all in hungarian?

If there were only ONE hungarian language file then the problem would be in that one file. You have more than one file to consider. First you need to identify the relevant file, and THEN you'll need to identify the part of the file that is causing the issue.

Nandor:

do you think i should try replacing other language php-s?

I think the way I'd be approaching this one would be

1. Make a backup of the hungarian language files.
   **2) Replace the originals, one at a time with the English (or german) files of the same name. **
2. When the problem goes away you'll have identified the file causing the problem.
3. Restore all the original hungarian files from the backups.

Yes. You'll need to replace the others (unless you have a better way of narrowing the problem down). Hhhm, we did discuss looking at the server error logs for clues, didn't we? They are generally good for identifying problem files)

Nandor:

or try searching elsewhere? How come that costumer can order bangles in hungarian, rings in hungarian but not pendants?

THAT is what we are trying to figure out.

Nandor:

Maybe when i uploaded this one category, did something different?

Maybe, but that doesn't fully explain the problem. You've already narrowed things down a little further than that.

Nandor:

The problem only comes with pendants shopping in hungarian with paypal.

As I stated before, this narrows down the possibilities a LOT.

Fact is, I think we have all the clues we need to theoretically be able to identify the exact line in the exact file that is triggering the error without any further testing.

What we are looking for is a file, in the** hungarian language** that contains reference to the 'pendant' category (or more specifically, something that makes this category different from the others, in theory, it could even be the name itself. What is the hungarian translation for 'pendant'?)** AND **is something that is used by the PayPal module, (this has be the most puzzled, because I can't think of any connection between a product category and the paypal needs/requirements, regardless of the language).

There would probably only be ONE file that meets ALL of these 'requirements'. ** I'm** not able to join the dots though, which is why my suggestion is to use a process of elimination until we can identify it.

Perhaps someone else here can see the connection where I can't? If they can, that'll be easier than the process of elimination. Meanwhile, it may appear daunting (because there are so many hungarian language files to eliminate), but you did already install them once, so replacing one at a time shouldn't be too much of a challenge.
Oh, you can also try re-installing all of the hungarian language files, just in case one of them didn't get uploaded properly.

Cheers
Rod

Nandor:

I just saw that the error emails subject is :MODULE_PAYMENT_PAYPALWPP_TEXT_EMAIL_ERROR_SUBJECT (10401)

So i replaced the hungarian paypalwpp.php with the english.The problem is still the same.

When you say 'still the same', do you mean that the email is still showing : MODULE_PAYMENT_PAYPALWPP_TEXT_EMAIL_ERROR_SUBJECT?

If YES, then it means your changes to the hungarian paypalwpp.php haven't taken effect.

This file contains a line that reads (in English)
define('MODULE_PAYMENT_PAYPALWPP_TEXT_EMAIL_ERROR_SUBJECT', 'ALERT: PayPal Express Checkout Error');

If/when working 'correctly' (and assuming an error is still present), the error emails subject would/should be reading 'ALERT: PayPal Express Checkout Error'

Nandor:

One thing changed. in hungarian a paypal button appeared, when shopping but as previously you cannot buy pendant in hungarian.
thought i finally found it......not

It looks to me like your on the right track. If you can figure out WHY the "MODULE_PAYMENT_PAYPALWPP_TEXT_EMAIL_ERROR_SUBJECT" isn't being replaced by its defined value 'ALERT: PayPal Express Checkout Error' (or the hungarian equivalent) you'll probably have the problem licked..

Important: It probably won't be this particular 'define' that is causing the actual problem, this is just another clue that is telling me that the fault is probably in this file though (the hungarian paypalwpp.php).

Getting closer by the minute. ;)

Cheers
Rod

RodG:

When you say 'still the same', do you mean that the email is still showing : MODULE_PAYMENT_PAYPALWPP_TEXT_EMAIL_ERROR_SUBJECT?

If YES, then it means your changes to the hungarian paypalwpp.php haven't taken effect.

This file contains a line that reads (in English)
define('MODULE_PAYMENT_PAYPALWPP_TEXT_EMAIL_ERROR_SUBJECT', 'ALERT: PayPal Express Checkout Error');

If/when working 'correctly' (and assuming an error is still present), the error emails subject would/should be reading 'ALERT: PayPal Express Checkout Error'

It looks to me like your on the right track. If you can figure out WHY the "MODULE_PAYMENT_PAYPALWPP_TEXT_EMAIL_ERROR_SUBJECT" isn't being replaced by its defined value 'ALERT: PayPal Express Checkout Error' (or the hungarian equivalent) you'll probably have the problem licked..

Important: It probably won't be this particular 'define' that is causing the actual problem, this is just another clue that is telling me that the fault is probably in this file though (the hungarian paypalwpp.php).

Getting closer by the minute. ;)

Cheers
Rod

**Hi Rod!

till now i replaced the following:
**
*paypal wpp.php
paypal.php
paypaldp.php

define checkout success.php

checkout confirmation.php
checkout payment.php
checkout payment address.php
checkout process.php
checkout shipping.php
checkout shipping address.php
checkout success.php*

**After these nothing was solved. Still cant shop pendants in hungarian. still can shop everything else in all languages.
Then i stood up for a waking coffee.
Then i (before continuing the replacement process) i uploaded a new item to the problematic(pendants) category/subcategory and this new product
can be bought in hungarian, but the others in the same category not.

How do we proceed in your opinion?

thanks
Nandor

**

Nandor:

**
Then i (before continuing the replacement process) i uploaded a new item to the problematic(pendants) category/subcategory and this new product
can be bought in hungarian, but the others in the same category not.

How do we proceed in your opinion?
**

I'm unable to tell you the best way to proceed, because I've not much experience with foreign language / character set issues.

HOWEVER, I have discovered the actual problem. Actually, it was you that has discovered it with this latest observation, which has confirmed my earlier suspicion that it it is a character encoding issue.

The 'Category' is a 'red herring'. It doesn't have anything to do with the problem. The actual cause being related to the existing products in this category

This observation also suggests that looking for the fault in the language files themselves probably isn't going to help. That isn't where the problem is. You can/should revert the files back to the original hungarian.

Now we know what the problem isn't, we can concentrate more on what it is.
At some time or other you've managed to create a mismatch with your character sets. The original entries were made with one type of character encoding, and the new addition has been added/created with another.

This is evident if you look at the description of your newly added product (hungarian) and you'll see a couple of characters that look like "�". This is telling me that something isn't being decoded correctly. None of the original entries appear to have this problem, which suggests the encoding has been been changed at some stage.

Thinking about this logically, I would be expecting those original entries (without the apparent encoding issue) would be OK, and that it would be the new entry (with the "�" that should be having the problem. I have no explanation as why you are getting the effect opposite to what I'd expect, but nonetheless, that does appear to be the case.

So, whats the best way to go from here? Firstly, I'd wait a day or so to see if anyone else picks up on this thread and can offer step-by-step guidance.

If this isn't forthcoming, firstly you should read this:
http://www.zen-cart.com/content.php?313-should-i-convert-my-store-from-iso-8859-1-to-utf8

Also read whatever else you can find on this subject (UTF8 vs iso-xxxx encodings) to ensure that you will be using the correct encoding for the hungarian language, which hopefully isn't going to cause you problems with the English & German languages. To do this correctly you'll need up update your SQL database tables (probably) as well as the 'defines' for the DB set in your configure.php files (and possibly elsewhere). You may only need to update one or the other. As I say, my experience here is really lacking, which is why I'm hoping someone with more experience will be of better help.

Anyway, after you've fixed this character set/encoding mismatch/problem, and since you don't have all that many products in your store anyway, rather than try to 'convert' the existing product data to bring everything back to the same/common format, it may be quicker and easier to just delete the products and re-enter them. Again, someone with more experience may be able to offer a better/easier/quicker solution

Cheers
Rod

RodG:

I'm unable to tell you the best way to proceed, because I've not much experience with foreign language / character set issues.

HOWEVER, I have discovered the actual problem. Actually, it was you that has discovered it with this latest observation, which has confirmed my earlier suspicion that it it is a character encoding issue.

The 'Category' is a 'red herring'. It doesn't have anything to do with the problem. The actual cause being related to the existing products in this category

This observation also suggests that looking for the fault in the language files themselves probably isn't going to help. That isn't where the problem is. You can/should revert the files back to the original hungarian.

Now we know what the problem isn't, we can concentrate more on what it is.
At some time or other you've managed to create a mismatch with your character sets. The original entries were made with one type of character encoding, and the new addition has been added/created with another.

This is evident if you look at the description of your newly added product (hungarian) and you'll see a couple of characters that look like "�". This is telling me that something isn't being decoded correctly. None of the original entries appear to have this problem, which suggests the encoding has been been changed at some stage.

Thinking about this logically, I would be expecting those original entries (without the apparent encoding issue) would be OK, and that it would be the new entry (with the "�" that should be having the problem. I have no explanation as why you are getting the effect opposite to what I'd expect, but nonetheless, that does appear to be the case.

So, whats the best way to go from here? Firstly, I'd wait a day or so to see if anyone else picks up on this thread and can offer step-by-step guidance.

If this isn't forthcoming, firstly you should read this:
http://www.zen-cart.com/content.php?313-should-i-convert-my-store-from-iso-8859-1-to-utf8

Also read whatever else you can find on this subject (UTF8 vs iso-xxxx encodings) to ensure that you will be using the correct encoding for the hungarian language, which hopefully isn't going to cause you problems with the English & German languages. To do this correctly you'll need up update your SQL database tables (probably) as well as the 'defines' for the DB set in your configure.php files (and possibly elsewhere). You may only need to update one or the other. As I say, my experience here is really lacking, which is why I'm hoping someone with more experience will be of better help.

Anyway, after you've fixed this character set/encoding mismatch/problem, and since you don't have all that many products in your store anyway, rather than try to 'convert' the existing product data to bring everything back to the same/common format, it may be quicker and easier to just delete the products and re-enter them. Again, someone with more experience may be able to offer a better/easier/quicker solution

Cheers
Rod

Hi Rod,

unfortunately i havent got any replies since last week.
Havent figured out either how to solve the issue.
I have decided to enable cod payment method in Hungary, it is more popular here (domestic orders) anyway. Paypal express stays for every other language, but hungarian.
Maybe will be able to solve this in some time!
Thanks a lot for your support!

Nandor

Is the problem only when the price is greater than 999.99 ?

DrByte:

Is the problem only when the price is greater than 999.99 ?

No, i tried it with many prices If thats what you mean. the currency is in euro and huf. There is as trial 1 euro, 5.49 euro.....

thanks

Nandor

Nandor:

No, i tried it with many prices If thats what you mean. the currency is in euro and huf. There is as trial 1 euro, 5.49 euro.....

thanks

Nandor

Me again.

i just realized that paypal button doesnt appear in hungarian. Can be seen at german,english language.
Could this be an issue?

Nandor

Two things:

1. It would be much easier to rule out known PayPal bugs if you were using v1.3.9h instead of v1.3.9e. Is it possible for you to upgrade, and then test again?
2. If you can't upgrade, then please log a support ticket with PayPal at https://www.paypal.com/mts and submit this log file to them as part of the details, and ask them what specific part of the transaction is causing the 10401 in this case.

Nandor:

sorry!!! this is the log file of the error order (the previous one was a fine one!) :

2013-03-08 05:51:02

(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(tm) - PayPal/NVP
[4] => X-VPS-VIT-Integration-Version: 1.3.9e
)

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

SetExpressCheckout, Elapsed: 1893ms -- Failure

TIMESTAMP=2013%2d03%2d08T04%3a51%3a02Z&CORRELATIONID=739a84dee3c8a&ACK=Failure&VERSION=60%2e0&BUILD=5331358&L_ERRORCODE0=10401&L_SHORTMESSAGE0=Transaction%20refused%20because%20of%20an%20invalid%20argument%2e%20See%20additional%20error%20messages%20for%20details%2e&L_LONGMESSAGE0=Order%20total%20is%20invalid%2e&L_SEVERITYCODE0=Error&CURL_ERRORS=

Nandor:

i just realized that paypal button doesnt appear in hungarian. Can be seen at german,english language.
Could this be an issue?Not sure whether that's a problem with your language files or not. And I'm not sure if it's a factor in the problem you're having. You should definitely fix whatever is missing from your language files.

DrByte:

Two things:

1. It would be much easier to rule out known PayPal bugs if you were using v1.3.9h instead of v1.3.9e. Is it possible for you to upgrade, and then test again?
2. If you can't upgrade, then please log a support ticket with PayPal at www.paypal.com/mts and submit this log file to them as part of the details, and ask them what specific part of the transaction is causing the 10401 in this case.

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