Instagram AmazingRibs Facebook AmazingRibs X - Meathead Pinterest AmazingRibs Youtube AmazingRibs

Welcome!


This is a membership forum. Guests can view 5 pages for free. To participate, please join.

[ Pitmaster Club Information | Join Now | 30 Day Trial | Login | Contact Us ]

Only 4 free page views remaining.

Announcement

Collapse
No announcement yet.

Funky characters after recent upgrades.

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    Funky characters after recent upgrades.

    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.

    #2
    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?

    Comment


    • RAYMBO
      RAYMBO commented
      Editing a comment
      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

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

    Comment


    • smokin fool
      smokin fool commented
      Editing a comment
      If he's like me you do get rushed going from nap to nap several times a day....

    • Andrrr
      Andrrr commented
      Editing a comment
      smokin fool I’m too far away to start counting the years but I am infinitely jealous of you retired folks.

    • 58limited
      58limited commented
      Editing a comment
      Funky character Panhead John is still here I see.

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

    Comment


    • RAYMBO
      RAYMBO commented
      Editing a comment
      Yep. About to fix that one.

    #5
    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.

    Comment


      #6
      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”
      Last edited by RAYMBO; October 19, 2022, 01:31 AM.

      Comment


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

        Comment


          #8
          We had funky characters around here way before the upgrade.

          Comment


            #9
            so I don’t have delmixupia? whew!

            Comment


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

              Comment


              #11
              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.

              Comment


              #12
              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":

              Click image for larger version

Name:	weird character.jpg
Views:	286
Size:	156.5 KB
ID:	1311158

              Comment


              • RAYMBO
                RAYMBO commented
                Editing a comment
                Thanks! I forgot about the phrases and options the may have this issue.

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

              Last edited by Panhead John; October 20, 2022, 07:46 AM.

              Comment


              #14
              More:

              Like I needed one! If ya’ll get a chance do read klflowers post on processed foods, do it. Which takes me to my latest endeavor. I am in the process to find a dietary way to either greatly help or to eradicate the bladder cancer that was diagnosed on Wednesday the 5th day of this new year. I have been delving deeply into the

              Comment


              • RAYMBO
                RAYMBO commented
                Editing a comment
                Fixed.

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

              Hey folks, tomorrow I start ten days off, and because we abandoned our planned trip out to the Oregon coast (health and safety concerns), my game plan is to cook my fool head off during what is now the Staycation. Aside from what's up for the next two days, what gets cooked when will have to be decided a little bit on the fly

              Comment


              • RAYMBO
                RAYMBO commented
                Editing a comment
                Fixed.

            Announcement

            Collapse
            No announcement yet.
            Working...
            X
            false
            0
            Guest
            Guest
            500
            ["membership","help","nojs","maintenance","shop","reset-password","authaau-alpha","ebooklogin-start","alpha","start"]
            false
            false
            Yes
            ["\/forum\/free-deep-dive-guide-ebook-downloads","\/forum\/free-deep-dive-guide-ebook-downloads\/1157845-paid-members-download-your-6-deep-dive-guide-ebooks-for-free-here","\/forum\/the-pitcast","\/forum\/national-barbecue-news-magazine","\/forum\/national-barbecue-news-magazine\/national-barbecue-news-magazine-aa","\/forum\/national-barbecue-news-magazine\/national-barbecue-news-magazine-aa\/bbq-news-magazine-2019-issues","\/forum\/national-barbecue-news-magazine\/national-barbecue-news-magazine-aa\/bbq-news-magazine-2020-issues","\/forum\/national-barbecue-news-magazine\/national-barbecue-news-magazine-aa\/bbq-news-magazine-2021-issues","\/forum\/national-barbecue-news-magazine\/national-barbecue-news-magazine-aa\/bbq-news-magazine-2022-issues","\/forum\/national-barbecue-news-magazine\/national-barbecue-news-magazine-aa\/current-2023-issues","\/forum\/national-barbecue-news-magazine\/national-barbecue-news-magazine-aa\/current-2024-issues","\/forum\/national-barbecue-news-magazine\/national-barbecue-news-magazine-aa\/current-2025-issues","\/forum\/national-barbecue-news-magazine\/national-barbecue-news-magazine-aa\/current-2026-issues","\/forum\/bbq-stars","\/forum\/bbq-stars\/tuffy-stone","\/forum\/bbq-stars\/meathead","\/forum\/bbq-stars\/harry-soo","\/forum\/bbq-stars\/matt-pittman","\/forum\/bbq-stars\/kent-rollins","\/forum\/bbq-stars\/dean-fearing","\/forum\/bbq-stars\/tim-grandinetti","\/forum\/bbq-stars\/kent-phillips-brett-gallaway","\/forum\/bbq-stars\/david-bouska","\/forum\/bbq-stars\/ariane-daguin","\/forum\/bbq-stars\/jack-arnold","\/forum\/free-deep-dive-guide-ebook-downloads"]
            /forum/free-deep-dive-guide-ebook-downloads