1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

Repeiring national characters in PPB 10.2.0-1

Discussion in 'Plesk 10.x for Linux Issues, Fixes, How-To' started by batiskaff, May 16, 2011.

  1. batiskaff

    batiskaff Guest

    Repairing national characters in PPB 10.2.0-1


    After update our PP from 9.x to 10.2 we decided to use the billing.
    Up until then, we had never used the billing and found this problem only right now.
    So, when I open our online store for purchasing some subscription I see right national characters.
    But if I open the registration form I see the drop-down select of languages with wrong national characters.
    For example like this:

    When I use invoices I have the same problem with names of months.

    I realized that this problem in the system DB table 'locales' and I tried to find the right way to fix it myself in KB.
    I found the best way here http://kb.odin.com/en/6279 but in comments wrote that hotfix only for PB 6.0.3. It's not for our version PB 10.2.0-1

    How can I fix it by an another way?

    P.S. Also I see that all tables in DB 'billing' have a collate latin1_swedish_cs. What do I have to do with it correctly? I think if I just change the collation to utf-8, I cannot fix it right. Where can I get the information what billing tables should have right settings locales and collations? May be is there a script for repair DB tables for our version PPB 10.2.0-1 w/o needing reinstall because we don't want to touch this working server?

    Thanks for your help in advance.
    Last edited by a moderator: May 16, 2011
  2. EugeneL

    EugeneL Regular Pleskian

    Feb 18, 2011
    Likes Received:
    Hi, batiskaff

    Unfortunately you were required to apply the fix mentioned in KB article before upgrade. There is no such official hotfix for 10.2 version.

    You can download patch for 6.0.3 and tune it by yourself or you can use attached file as example (I've tuned it to be applicable for 10.2 - changed file paths and made DB name as a script input parameter). Please consider that it is not the official patch!

    If you decide to use my version of file, just run:
    shell> plesk-billing-10.2.0-repair-locales.sh <billing_db>
    Default value for <billing_db> is "billing".

    Attached Files: