Funky characters after recent upgrades.

[RAYMBO]

I am working on fixing the conversion debacle that changed emojis and special characters into garbage.

Like the apostrophe/single quotes looked like this: ’

I have not found a simple and successful way to convert all of these (90,000+ posts are effected).

So. I am doing this one bad character group at a time.

Please post here if you spot one. Link to the post. And if you know what the garbage characters should be, please let me know that as well.

The apostrophe was an easy one and you should already notice that it has been fixed.

Thanks for you patience. I will try to get this all fixed up as fast as I can.

[Michael_in_TX]

Take your time.

No, seriously, we're okay. Those of us with a database background understand exactly what is going on. (I am a backup on a 300k record academic journal database with this same problem!)

This does raise a lovely question.... what does

SELECT COUNT(*)
FROM table_of_posts
WHERE deleted = 0;

return?

[RAYMBO]

Would be nice if vBulletin kept it that simple. But the "text" parts of a forum, topic, post, attachment, message, etc.. are in the "text" table. And the main table is called "node". So to get the results you want, this query:
select count(*) from node join text using(nodeid) where node.contenttypeid = 22
which currently returns just over one million posts: 1,019,024

[Panhead John]

Thanks Ray! What’s killing us worse is the slow response time changing pages. Appreciate all your hard work with this!

[smokin fool]

If he's like me you do get rushed going from nap to nap several times a day....

[Andrrr]

smokin fool I’m too far away to start counting the years but I am infinitely jealous of you retired folks.

[58limited]

Funky character Panhead John is still here I see.

[Sid P]

Hey Ray, is now showing where I previously had used this wink emoji 😉. Thanks.

[RAYMBO]

Yep. About to fix that one.

[RAYMBO]

Alrighty then!

Got lucky.

Found a big list of Unicode Emojis listed on a site that also has the same conversion debacle.

So a nice list of the garbage characters next to the title.

See: https://forum.pianoworld.com/ubbthre...s-to-talk.html

I should be able to fix most of the garbage characters.

[RAYMBO]

So far. I have been able to fix these:

Wink smilie:
Fire: 🔥
Ellipsis: …
Degree: °
Apostrophe: ’

I am working on the open/close double quotes. But it is complicated. “quotes”

[FireMan]

Ah, so that’s what it is, Funky Characters. I thought it was symbol jibberish. Thanks fer &€?¥£#in me out.

[Chuck in Charlotte]

We had funky characters around here way before the upgrade.

[smokenoob]

so I don’t have delmixupia? whew!

[scottranda]

The latency is very long now. Can we fix that?

[RAYMBO]

I am still working on that.

See: https://pitmaster.amazingribs.com/fo...ecent-upgrades

[RAYMBO]

Update.

I found a way to fix the complex double open and close quotes. Example, “quotes around this”

I think that was the last of the major characters issues. The rest are most likely emojis.

Please let me know if you spot any topic or post with the funky characters.

[STEbbq]

Thank you!!!!!!!!

Here is one more:

https://pitmaster.amazingribs.com/forum/the-pit-mastery-program/misc-or-general-food-discusison/1155373-another-journey?p=1161992#post1161992

[RAYMBO]

Fixed.

[DaveD]

Ray, one straggler on the Funky Character front: the banner column along the right hand side of every page has one in the "Tell a friend" box, in the first word "You've":

[RAYMBO]

Thanks! I forgot about the phrases and options the may have this issue.

[Panhead John]

Ray. https://pitmaster.amazingribs.com/fo...timate-griddle

[Panhead John]

https://pitmaster.amazingribs.com/forum/pitmaster-general-discussion/1301771-anyone-have-a-good-ad-blocker-they-like-mainly-for-youtube

More here too.

[RAYMBO]

Fixed and fixed.

[STEbbq]

More:

https://pitmaster.amazingribs.com/forum/the-pit-mastery-program/misc-or-general-food-discusison/1155373-another-journey?p=1162081#post1162081

[RAYMBO]

Fixed.

[DaveD]

And another one for ya. This is supposed to be Ole with an accent on the e when describing the red chile sauce.

https://pitmaster.amazingribs.com/forum/the-pit-mastery-program/misc-or-general-food-discusison/1268555-dave-s-staycation-cook-a-thon?p=1272517#post1272517

[RAYMBO]

Fixed.