Jump to content

Archived

This topic is now archived and is closed to further replies.

www.in.no

UTF email error

Recommended Posts

Hi,

 

Using version 2.3.3.

 

When sending email or as it seems order confirmations there are some problem regarding UTF-8 and special characters in the following fields:

 

From field (The name, not email address)

To Field (The name, not email address)

Subject

 

The content is ok and showing special characters as ÆØÅ correct.

 

But in any other field they don't show correct.

 

 

I have been trying to search bug reports, and git hub but i don't find any good fix for it..

 

There are some fixes in the forum, but with varying result as the posts indicate. And not sure if it is fixed in all the correct places.

 

Any one know of a fully fix for this.

 

Thanks..

Share this post


Link to post
Share on other sites

@@www.in.no

 

if I used this for years without any problems maybe you couldn't read https://github.com/tgely/oscommerce2/commit/fe9818df347fff234ff331b2ac4a386467ff2b9c

 

Could you say something about if there is a bug in this commit?


:blink:
osCommerce based shop owner with minimal design and focused on background works. When the less is more.
Email managment with tracking pixel, package managment for shipping, stock management, warehouse managment with bar code reader, parcel shops management on 3000 pickup points without local store.

Share this post


Link to post
Share on other sites

@@Gergely

 

Hi thanks for the link, i tried searching and not reading the hole code so i missed that :-)

 

The only problem that i found is that when sending email from admin the store owner name is not correct when having special characters.

 

"STORE OWNER ÆØÅ" <arild@in.no>

 

Also the subject in Contact us don't show special characters correct in the received email.

Foresp?rsel fra OSC Test Store

But all others fields showing correct. The Special characters are from the contact_us language file.

 

 

Tell a friend work correct and showing all characters.

Share this post


Link to post
Share on other sites

@@www.in.no

 

I use full utf-8 code system so I have no problem. You can see the merge commit https://github.com/tgely/oscommerce2/commit/2be156e3ba36764e82375a851c2e930bdf9b0661

 

Do you use Latin-1 (ISO-8859-1) database?


:blink:
osCommerce based shop owner with minimal design and focused on background works. When the less is more.
Email managment with tracking pixel, package managment for shipping, stock management, warehouse managment with bar code reader, parcel shops management on 3000 pickup points without local store.

Share this post


Link to post
Share on other sites

@@Gergely

 

Thanks, i have a look and see if all is implemented. Just to be sure.

 

But i also found out that the directadmin editor did not put out utf-8 correctly, because when i was editing the language files in OSC internal editor it become ok.

Share this post


Link to post
Share on other sites

@@Gergely

 

Hi, this merge you have

https://github.com/tgely/oscommerce2/commit/2be156e3ba36764e82375a851c2e930bdf9b0661

 

This is for the installation base as well, so if i do all the changes in the install directory and files then it will be correctly installed with UTF if i re install?

 

As i also have problems with getting ssl to work correctly with sessions i might soon try a fresh install without any changes except for the UTF fixes.

Share this post


Link to post
Share on other sites

@@www.in.no

I had 2 important utf8 fixes later:

 

https://github.com/tgely/oscommerce2/commit/0cb19dc131d71d1e8234b1883a53fcbadd39a275 (installation)

https://github.com/tgely/oscommerce2/commit/e94148d7b278780bfbad55a2c60b120cd7437e1f (search)

 

Make a full backup first. I suggest for testing and start with a fress new installation.


:blink:
osCommerce based shop owner with minimal design and focused on background works. When the less is more.
Email managment with tracking pixel, package managment for shipping, stock management, warehouse managment with bar code reader, parcel shops management on 3000 pickup points without local store.

Share this post


Link to post
Share on other sites

Thanks for the URL's. @@Gergely

 

Just want to clean up the url' for UTF-8 in case some other want to follow them because the text you added at the end have become a part of the url and resulting in 404.

 

https://github.com/tgely/oscommerce2/commit/e94148d7b278780bfbad55a2c60b120cd7437e1f

 

https://github.com/tgely/oscommerce2/commit/0cb19dc131d71d1e8234b1883a53fcbadd39a275

 

And the first one here as well.

 

https://github.com/tgely/oscommerce2/commit/2be156e3ba36764e82375a851c2e930bdf9b0661

Share this post


Link to post
Share on other sites

@@Gergely

 

Just a question before i start the re install process with the UTF changes.

 

I am on windows and using notpad++ to edit.

 

When i open the extracted oscommerce files it shows as "UNIX ANSI"

 

My choice then is:

 

Convert it to UTF-8

 

I can set notpad++ it to open files as UTF-8 without BOM, then showing as "ANSI as UTF-8"

 

Witch approach is best?

Do i need to convert all files to UTF-8?

Share this post


Link to post
Share on other sites

@@www.in.no

 

only language files need to use utf-8 without bom. I converted my all relevant language files. (latin-1 code pages languages not need to convert utf8)

I transformed hungarian files only. The modules can contain language informations when install them so I transformed some important modules too.


:blink:
osCommerce based shop owner with minimal design and focused on background works. When the less is more.
Email managment with tracking pixel, package managment for shipping, stock management, warehouse managment with bar code reader, parcel shops management on 3000 pickup points without local store.

Share this post


Link to post
Share on other sites

@@Gergely

 

In Github in the file catalog/install/rpc.php

Is there a missing "," at the end of line 141 ?

51  140
				 'DB_DATABASE' => trim(rawurldecode($HTTP_GET_VARS['name'])),
  141
+				    'DB_DATABASE_CHARSET' => trim(rawurldecode($HTTP_GET_VARS['charset']))
52  142
			    );

Share this post


Link to post
Share on other sites

@@www.in.no

 

yes there is, but after utf8 upgrade it will be clear :)


:blink:
osCommerce based shop owner with minimal design and focused on background works. When the less is more.
Email managment with tracking pixel, package managment for shipping, stock management, warehouse managment with bar code reader, parcel shops management on 3000 pickup points without local store.

Share this post


Link to post
Share on other sites

@@Gergely

 

Ok, thanks.

 

Have tried a changed installation with your 3 fixes and it works great...

 

So the language is sorted out, just SSL again...before i can go on installing the addons i want..

Share this post


Link to post
Share on other sites

×