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:
Posted in Quick-Reply, and also broken if Quick-Edited:
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:
Thanks a lot.
PS: Currently not using any plugin, just plain VBulletin.
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, á é í ç ó ú à è ü ã õ ê ô
Hello, test, 123, á é í ç ó ú à è ü ã õ ê ô
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,'é','é');
PS: Currently not using any plugin, just plain VBulletin.
Comment