Email subjects of arabic language not showing correct

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Rabso
    Member
    • Oct 2008
    • 33
    • 5.1.x

    Email subjects of arabic language not showing correct

    Hi,

    My members complaining of the emails subjects that are sent from my forum, only when I write the subject in Arabic language as my forum is in Arabic.

    The issue is only with the subject of email but the body of emails are fine.

    this example of how the subject be
    Code:
    Account validated at D8A7D984D985D986D8AAD8AFD989 D8A7D984D8B9D8B1D8A8D98A D984D984D8B7D98AD8B1D8A7D986 D8A7D984D8AAD8B4D8A8D98AD987D98A!
    I have set the option "Encode as UTF-8" to yes but the issue still not solved. to be noted that my server use the UTF-8 HTML Character Set
  • Lynne
    Former vBulletin Support
    • Oct 2004
    • 26255

    #2
    What is the collation of the database tables?

    Please don't PM or VM me for support - I only help out in the threads.
    vBulletin Manual & vBulletin 4.0 Code Documentation (API)
    Want help modifying your vbulletin forum? Head on over to vbulletin.org
    If I post CSS and you don't know where it goes, throw it into the additional.css template.

    W3Schools <- awesome site for html/css help

    Comment

    • Rabso
      Member
      • Oct 2008
      • 33
      • 5.1.x

      #3
      It is "latin1_general_ci"

      Comment

      • Lynne
        Former vBulletin Support
        • Oct 2004
        • 26255

        #4
        Then you should not be setting the option in the config.php file to UTF-8 as it is not UTF-8.

        Please don't PM or VM me for support - I only help out in the threads.
        vBulletin Manual & vBulletin 4.0 Code Documentation (API)
        Want help modifying your vbulletin forum? Head on over to vbulletin.org
        If I post CSS and you don't know where it goes, throw it into the additional.css template.

        W3Schools <- awesome site for html/css help

        Comment

        • Rabso
          Member
          • Oct 2008
          • 33
          • 5.1.x

          #5
          I am kind confusing here

          Now this information is from my Database server: Server charset: UTF-8 Unicode (utf8)

          and the following is set already without any change in my config.php
          Code:
              //    ****** MySQLI OPTIONS *****
              // When using MySQL 4.1+, MySQLi should be used to connect to the database.
              // If you need to set the default connection charset because your database
              // is using a charset other than latin1, you can set the charset here.
              // If you don't set the charset to be the same as your database, you
              // may receive collation errors.  Ignore this setting unless you
              // are sure you need to use it.
          // $config['Mysqli']['charset'] = 'utf8';
          as you see I did not sit it to UTF8

          but when I enter to my database I see the Collation is latin1_general_ci

          So what is the correct way to override this issue? noting that I am using Arabic language with UTF-8 charset and there is no issue at all in my forum except the titles of emails.


          ---- update ---

          I found way (if this will help to solve my issue) to convert the tables from latin1_general_ci to utf8_unicode_ci, is this will effect bad on my forum tables?

          and which better for vb5? utf8_unicode_ci or utf8_general_ci
          Last edited by Rabso; Sun 28 Dec '14, 8:48pm.

          Comment

          • Lynne
            Former vBulletin Support
            • Oct 2004
            • 26255

            #6
            If you are going to convert your tables, please make sure you do this on a database backup and test it out on a test site before doing the same to the live site.

            Please don't PM or VM me for support - I only help out in the threads.
            vBulletin Manual & vBulletin 4.0 Code Documentation (API)
            Want help modifying your vbulletin forum? Head on over to vbulletin.org
            If I post CSS and you don't know where it goes, throw it into the additional.css template.

            W3Schools <- awesome site for html/css help

            Comment

            • Rabso
              Member
              • Oct 2008
              • 33
              • 5.1.x

              #7
              My forum is not yet officially open for my organization so there is nothing for me to be worry at this point.

              I have converted all tables to utf8_unicode_ci but the issue of emails subject still same it makes me crazy any help please

              Comment

              • Lynne
                Former vBulletin Support
                • Oct 2004
                • 26255

                #8
                If you converted to UTF-8, did you uncomment the line in the config.php file? And, when you did the conversion, did you make sure to check the tables AND fields? Have you considered reinstalling with the correct charset set up for the database?

                Please don't PM or VM me for support - I only help out in the threads.
                vBulletin Manual & vBulletin 4.0 Code Documentation (API)
                Want help modifying your vbulletin forum? Head on over to vbulletin.org
                If I post CSS and you don't know where it goes, throw it into the additional.css template.

                W3Schools <- awesome site for html/css help

                Comment

                • Rabso
                  Member
                  • Oct 2008
                  • 33
                  • 5.1.x

                  #9
                  1. uncomment the line in the config.php file made my whole forum looks un-readable! such:
                  Code:
                      لا يمكن اكمال ذلك العمل. يرجى المØ*اولة مرة أخرى، وإذا كان هذا تكرر مرة أخرى الرجاء الاتصال بالإدارة وتشرØ* لهم سبب ظهور هذه الرسالة.
                  2. Yes I checked the tables and rows; all is utf8_unicode_ci

                  3. No I did not considered this! I may give it try but I have modifying a lot my forum to meet my requirements! is making backup for my database now useful for me to restore all my sittings? or I have to start all from start again?

                  I used the following script to convert:

                  PHP Code:
                                 <?php
                                     $con 
                  mysql_connect('localhost','user','password');
                                     if(!
                  $con) { echo "Cannot connect to the database ";die();}
                                     
                  mysql_select_db('db_name');
                                     
                  $result=mysql_query('show tables');
                                     while(
                  $tables mysql_fetch_array($result)) {
                                              foreach (
                  $tables as $key => $value) {
                                               
                  mysql_query("ALTER TABLE $value CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci");
                                         }}
                                     echo 
                  "The collation of your database has been successfully changed!";
                                  
                  ?>



                  ---- update ---

                  I have created new database and made sure it is utf8_unicode_ci
                  then I installed new test forum, then I made sure that all the tables are utf8_unicode_ci

                  After that I tried to send email but the same issue for the subject came! I have then uncomment the line in the config.php to make it utf-8 and forum shows the Arabic ok but again the same issue of email subject came!

                  it seems something out of my handle
                  Last edited by Rabso; Mon 29 Dec '14, 8:46pm.

                  Comment

                  • Lynne
                    Former vBulletin Support
                    • Oct 2004
                    • 26255

                    #10
                    When you say you are emailing your user and you "write the subject in Arabic", are you talking about sending emails via the admincp? I looked through the bug tracker and couldn't find anything relating to your problem. If it is regarding emailing from the admincp, it may be that noone has noticed this problem because I don't know of a lot of admins that email via the admincp.

                    Please don't PM or VM me for support - I only help out in the threads.
                    vBulletin Manual & vBulletin 4.0 Code Documentation (API)
                    Want help modifying your vbulletin forum? Head on over to vbulletin.org
                    If I post CSS and you don't know where it goes, throw it into the additional.css template.

                    W3Schools &lt;- awesome site for html/css help

                    Comment

                    • Rabso
                      Member
                      • Oct 2008
                      • 33
                      • 5.1.x

                      #11
                      Yes exactly, this issue is accruing with the following action:
                      1. When the user receive the activation email, recovery password or the welcome email (for example my forum title is in Arabic and thus the title will be "Account validated at forum name". the English words show ok but the Arabic it shows code as above.
                      2. when I send email via admincp with Arabic title it shows code also.


                      basically any email with Arabic title it will show this issue.

                      Comment

                      • Lynne
                        Former vBulletin Support
                        • Oct 2004
                        • 26255

                        #12
                        Is this your issue here - http://tracker.vbulletin.com/browse/VBV-10922 ? There is also this issue here - http://tracker.vbulletin.com/browse/VBV-12474

                        Please don't PM or VM me for support - I only help out in the threads.
                        vBulletin Manual & vBulletin 4.0 Code Documentation (API)
                        Want help modifying your vbulletin forum? Head on over to vbulletin.org
                        If I post CSS and you don't know where it goes, throw it into the additional.css template.

                        W3Schools &lt;- awesome site for html/css help

                        Comment

                        • Rabso
                          Member
                          • Oct 2008
                          • 33
                          • 5.1.x

                          #13
                          Yes it is same the VBV-10922, I have voted for it and I hope it be solved soon. thank you Lynne.

                          Comment

                          • rabban
                            New Member
                            • Apr 2010
                            • 23
                            • 4.1.x

                            #14
                            Same problem here in 5.2.2 with Russian language.
                            Any temporary solution?
                            Please help us to solve it!
                            Thanks in advance.
                            Crossroad of the worlds

                            Comment

                            • melazhari
                              New Member
                              • Jun 2014
                              • 4
                              • 5.2.x

                              #15
                              Any temporary solution?

                              Comment

                              Related Topics

                              Collapse

                              Working...