Documents garballed on downloading. SugarCRM 4.5.0f - THE SOLUTION

[rturnbull]

Hello to all,

I have noticed on here that there are many posts about garballed documents coming back from Email or the Documents module. I believe I have found a solution.....

The problem is that people who are "HELPING" don't ask enough questions about the users environment and make assumtions about his/her environment. This has led to many "solutions" but not one that works.

The fix for the garballed documents is the php.ini and the mbstring section. A) MAKE SURE YOU HAVE MBSTRING ENABLED. B) ONCE YOU HAVE MBSTRING MAKE SURE TO CONFIGURE ITS VALUES!!!!

Here is now my php.ini [mbstring] section after I editted it.

[mbstring]
; language for internal character representation.
mbstring.language = Japanese

; internal/script encoding.
; Some encoding cannot work as internal encoding.
; (e.g. SJIS, BIG5, ISO-2022-*)
;mbstring.internal_encoding = EUC-JP
mbstring.internal_encoding = UTF-8

; http input encoding.
mbstring.http_input = auto

; http output encoding. mb_output_handler must be
; registered as output buffer to function
;mbstring.http_output = SJIS
mbstring.http_output = pass

; enable automatic encoding translation accoding to
; mbstring.internal_encoding setting. Input chars are
; converted to internal encoding by setting this to On.
; Note: Do _not_ use automatic encoding translation for
; portable libs/applications.
;mbstring.encoding_translation = Off
mbstring.encoding_translation = On

; automatic encoding detection order.
; auto means
mbstring.detect_order = auto

; substitute_character used when character cannot be converted
; one from another
mbstring.substitute_character = none;

; overload(replace) single byte functions by mbstring functions.
; mail(), ereg(), etc are overloaded by mb_send_mail(), mb_ereg(),
; etc. Possible values are 0,1,2,4 or combination of them.
; For example, 7 for overload everything.
; 0: No overload
; 1: Overload mail() function
; 2: Overload str*() functions
; 4: Overload ereg*() functions
mbstring.func_overload = 0

Once edited and apache is restarted, everything works fine!!!

Cheers!!

Ryan Turnbull

Definition of assume: Make a "ASS" out of "U" and "ME"

[rickcrites]

Thanks for this. I'm sure it will probably work for some people. But, it didn't fix my much more minor problem. Perhaps you have some data that would help, however.

I am getting extraneous question marks (?) in all forum posts, whenever there are two or more spaces in a row. This is rather maddening, as I am in the habit of spacing twice between sentences. So, every sentence ends up with a period followed by a question mark.

It doesn't look funny when I am composing or editing the post. It only shows up when I am reading / viewing it.

It does not seem to matter whether I am composing in html or plain text. It is independent of the browser used to write or read the message. I have my databases converted to UTF-8, as they should be. I tried your solution, above. Nothing I have tried so far has had any effect.

Can you help? Thanks in advance.

Best,
Rick