Non-English characters breaking in quick-reply and quick-edit

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • gusfune
    New Member
    • Jan 2007
    • 9
    • 4.0.x

    [Forum] Non-English characters breaking in quick-reply and quick-edit

    Hello,
    I'm currently using Vbulletin 4.0.6, but this problem is coming since 4.0.4.

    Basically, whenever any user posts using international characters using the quick-reply box, they break into UTF code (I believe it's UTF code what's showing up). This also happens when a moderator or admin edit the post using the quick-edit box on a post.

    If an user posts using an internal page for reply, or edits using the advanced editor (I mean, goes to an internal page to edit the post), the characters won't break.

    Here an example of a test.
    Original post:
    Hello, test, 123, á é í ç ó ú à è ü ã õ ê ô
    Posted in Quick-Reply, and also broken if Quick-Edited:
    Hello, test, 123, á é í ç ó ú à è ü ã õ ê ô
    This is a double issue that needs help.
    First: How can I fix this and prevent from happening again?

    Second: How can I fix all posts that were broken recently? I've tried manually using a SQL script to fix all broken characters in both vb_post and vb_posthistory entries, but even edited in there, won't change anything on the post page. If I edit the post on the post page (using the advanced editor), after running the queries, the characters will be back normal, and I just need to save to get back. I need a way to circumvent this manual work and fix all once in for all.

    Here is an example of the SQL query for fixing the é character:
    UPDATE vb_post SET pagetext = REPLACE (pagetext,'é','é');
    Thanks a lot.

    PS: Currently not using any plugin, just plain VBulletin.
  • gusfune
    New Member
    • Jan 2007
    • 9
    • 4.0.x

    #2
    No reply so far, can anyone please help with this?
    Thanks.

    Comment

    • gusfune
      New Member
      • Jan 2007
      • 9
      • 4.0.x

      #3
      bump

      Comment

      • Zachery
        Former vBulletin Support
        • Jul 2002
        • 59097

        #4
        You need to get php recompiled with iconv at the least, mbstring would also help.

        Comment

        Related Topics

        Collapse

        Working...