Administrative and Maintenance Tools - Fix the weird characters/symbols in posts.

This mod will allow you to fix the weird characters/symbols that appear at your forum when you move hosts and/or reatore a database due to the coallition characters conflict in the db.
For ex when all your posts appear with a bunch of ÂÂ@@ or whatever characters. All you have to do is enter those weird characters at the mod settings and then enter the right symbols that you want to replace and all your problems will be solved.

It can aslo be used to replace text. It can be whatever text you want.

Installation:

To install the mod, upload the includes folder to your forum root folder and then import the wierd_symbol_fix.xml file inside the mod package to Plugins&Products in the acp of your forum. Then go to the mod setting option: Fix Wierd Symbols. It can be found on the left side of the Admin Panel, right above the Maintenace section. And enter the information accordingly.

Note: After doing the replacement, go to: Admin CP -> Maintenance -> Update Counters and run Rebuild Post Cache.

[alhindasi]

waaaaaaaaaaaaaw 100%

it's working good

**BUT**

i need to fix and Replace many Word

Is it possible to add many Word

[rajubd]

some of my attachment showing wierd character is it going to work on attachment?

[gusfune]

One question: will this avoid characters breaking again? I mean, if it's something is causing all new posts to break, will this just fix the characters or is there any bug-fix inside the plugin?

Thanks.

[Threepwud]

I am trying to change ' to an apostrophe ' but it makes my page display a database error:

Database error in vBulletin 4.0.6:
Invalid SQL:
UPDATE thppost
SET pagetext = replace(pagetext, 'I'', ''');
MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '''')' at line 2
Error Number : 1064
Request Date : Saturday, September 11th 2010 @ 12:34:43 PM
Error Date : Saturday, September 11th 2010 @ 12:34:43 PM
Script : http://www.threepwud.com/vb/showthre...ndings?p=46049
Referrer : http://www.threepwud.com/vb/forum.php
IP Address : 94.170.240.143
Username : Threepwud
Classname : vB_Database
MySQL Version : 5.1.41

Any ideas?
Thanks mate

[borbole]

Originally Posted by Threepwud

I am trying to change ' to an apostrophe ' but it makes my page display a database error:

Database error in vBulletin 4.0.6:
Invalid SQL:
UPDATE thppost
SET pagetext = replace(pagetext, 'I'', ''');
MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '''')' at line 2
Error Number : 1064
Request Date : Saturday, September 11th 2010 @ 12:34:43 PM
Error Date : Saturday, September 11th 2010 @ 12:34:43 PM
Script : http://www.threepwud.com/vb/showthre...ndings?p=46049
Referrer : http://www.threepwud.com/vb/forum.php
IP Address : 94.170.240.143
Username : Threepwud
Classname : vB_Database
MySQL Version : 5.1.41

Any ideas?
Thanks mate

Can you tell me what test/character you want to replace and what with?

[Threepwud]

I mentioned that my apostrophes are showing as & # 0 3 9 ; (without the spaces, here it changes to an apostrophe!) so I want to change ' into an apostrophe.

Is this mod able to do that? Cheers mate

[borbole]

Originally Posted by Threepwud

I mentioned that my apostrophes are showing as & # 0 3 9 ; (without the spaces, here it changes to an apostrophe!) so I want to change ' into an apostrophe.

Is this mod able to do that? Cheers mate

Yes, that is able to do it. It can replace any text and character.

Anyway, you are using a single quote and as such you should escape it with the backslash character \

i.e. you should enter the character like this:

\'

at Wierd Symbol & the Replaced Text. I just tried it at my test site and it worked fine.

[Threepwud]

Alright, I changed it so my replaced text said \' and it didn't work - then also tried it with \**** and that didn't work.

I'm thinking maybe because it is between other characters. ie i****m has the characters between the I and M characters.

[borbole]

Originally Posted by Threepwud

Alright, I changed it so my replaced text said \' and it didn't work - then also tried it with \**** and that didn't work.

I'm thinking maybe because it is between other characters. ie i****m has the characters between the I and M characters.

After you ran it, did you update the counters as well as mentioned in bold at the bottom of the first post here

Note: After doing the replacement, go to: Admin CP -> Maintenance -> Update Counters and run Rebuild Post Cache.

[Threepwud]

HA! I did indeed miss that counter update. You sir are a genius.

The only thing I've noticed is that the forum slows down after I've enabled the mod. I'll look into that.

Thanks very much!

edit: after running your brilliant mod and then updating the counters, I simply disabled it and the place went faster again. Awesome stuff.

Could this mod be used to fix my quoting issues too?
[quote author=Jer link=topic=1118.msg46798#msg46798 date=1284059913]
comes from the SMF import and maybe if I can change them all...?