Results 1 to 8 of 8

Thread: Strange character in MY PIPELINE table

  1. #1
    distrib is offline Junior Member
    Join Date
    Oct 2006
    Posts
    1

    Default Strange character in MY PIPELINE table

    Hi,
    i have installed SugarCRM 4.5.0d (+ patch) in my suse linux 10
    apache2-2.0.54-10
    php4-4.4.0-6
    mysql-4.1.13-3
    I have a strange character in MY PIPELINE table
    in the title (Pipeline total is €0.00K) and under the tables ( €0 €0 €0 €0 €0)
    How can i resolve this problem?
    Thank you.
    Last edited by distrib; 2006-10-16 at 10:52 AM.

  2. #2
    tcalatayud is offline Junior Member
    Join Date
    Oct 2006
    Posts
    2

    Red face Re: Strange character in MY PIPELINE table

    Hi,

    I´ve the same problem! Have you been able to solve it? If so, can you tell how?

    Thanks and best regards,
    Toni

  3. #3
    malcolmh's Avatar
    malcolmh is offline A Sugar Hero | Help Forum Moderator
    Join Date
    Aug 2004
    Posts
    1,712

    Default Re: Strange character in MY PIPELINE table

    Quote Originally Posted by distrib
    Hi,
    i have installed SugarCRM 4.5.0d (+ patch) in my suse linux 10
    apache2-2.0.54-10
    php4-4.4.0-6
    mysql-4.1.13-3
    I have a strange character in MY PIPELINE table
    in the title (Pipeline total is €0.00K) and under the tables ( €0 €0 €0 €0 €0)
    How can i resolve this problem?
    Thank you.
    Hi,

    I guess you are talking about the Currency symbol. Via locale Ssettings in Admin or My Account you need to enter the currency symbol in Unicode i.e. for € try "& # 8 3 6 4 ;" without the spaces).

    Hope this helps
    Cheers Malcolm

    Genius4U Limited - Ingenious simple IT solutions for you / Genial einfache IT Lösungen für Sie
    http://www.genius4u.com or http://www.genius4u.de

  4. #4
    terencem is offline Junior Member
    Join Date
    Dec 2006
    Posts
    3

    Default Re: Strange character in MY PIPELINE table

    Quote Originally Posted by malcolmh
    Hi,

    I guess you are talking about the Currency symbol. Via locale Ssettings in Admin or My Account you need to enter the currency symbol in Unicode i.e. for € try "& # 8 3 6 4" without the spaces).

    Hope this helps
    That's odd (is this a bug?) because I have just entered "& # 8 3 5 6" and I get "Pipeline total is £0.00K". The correct currency sign is shown in the window on the setup page once I have pressed save, but in the home page it is still incorrect, as shown above in the home page, and "Pipeline total is ₤1.20K" on the pipeline page.

    Microsoft Windows XP Professional
    Version: 5.1.2600
    Service Pack: 2.0

    Terence.

  5. #5
    roblaus's Avatar
    roblaus is offline Sugar Community Member
    Join Date
    Dec 2006
    Location
    Vienna / Austria
    Posts
    2,850

    Default Re: Strange character in MY PIPELINE table

    Had the same issue - not even with a symbol but with EUR and HUF respectively. I went into settings again and simply typed over it, saved and it was back to normal. I suspect that it is somehow connected to the theme you use. But that's a wild guess only. My DB was utf8 right from the beginning.

    rgds
    rl

  6. #6
    malcolmh's Avatar
    malcolmh is offline A Sugar Hero | Help Forum Moderator
    Join Date
    Aug 2004
    Posts
    1,712

    Default Re: Strange character in MY PIPELINE table

    Hi,

    After making the change you have to refresh the My Pipeline Dashlet or Dashboard manually for the change to take effect. Another option is via Admin -> Repair --> Clear Dashlet Cache

    Hope this helps
    Cheers Malcolm

    Genius4U Limited - Ingenious simple IT solutions for you / Genial einfache IT Lösungen für Sie
    http://www.genius4u.com or http://www.genius4u.de

  7. #7
    terencem is offline Junior Member
    Join Date
    Dec 2006
    Posts
    3

    Default Re: Strange character in MY PIPELINE table

    Hi Malcom,

    Actually, neither seems to make a difference here.

    T.

  8. #8
    terencem is offline Junior Member
    Join Date
    Dec 2006
    Posts
    3

    Default Re: Strange character in MY PIPELINE table

    Quote Originally Posted by roblaus
    Had the same issue - not even with a symbol but with EUR and HUF respectively. I went into settings again and simply typed over it, saved and it was back to normal. I suspect that it is somehow connected to the theme you use. But that's a wild guess only. My DB was utf8 right from the beginning.

    rl
    Typing over it again makes no difference nor does changing the them or refresshing the Dashlet cache.

    T.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •