Announcement

Collapse
No announcement yet.

How to remove post icon from old threads

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

  • How to remove post icon from old threads

    We've discontinued enabling post icons but they still show up in old thread title.
    Any way to remove icon in thread title?

    Thanks,
    Mark
    Mark

  • #2
    These queries will remove the post icons from ALL posts and threads:

    UPDATE post SET iconid='0';

    UPDATE thread SET iconid='0';

    Backup your database first.
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment


    • #3
      Hi Steve, do I just enter this info in `Manual query box?
      I didn't see any ref, to icons etc in the auto query dropdown menu.

      Mark
      Off to do backup first
      Mark

      Comment


      • #4
        Yes, it's a Manual Query.
        Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
        Change CKEditor Colors to Match Style (for 4.1.4 and above)

        Steve Machol Photography


        Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


        Comment


        • #5
          Okay, I copied and pasted and got this error...

          An error occurred while attempting to execute your query. The following information was returned.
          error number: 1064
          error desc: You have an error in your SQL syntax near ';

          UPDATE thread SET iconid='0'' at line 1

          ----------------------------------
          Are the semi-colons part of it?
          Though I copied and pasted, the semi-colon didn't show in the query box on the second line.

          Mark
          Mark

          Comment


          • #6
            I doesn't look like you copied them correctly.

            Yours:

            UPDATE thread SET iconid='0''

            Mine:

            UPDATE thread SET iconid='0';

            My query ran fine without any errors on my test forums.
            Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
            Change CKEditor Colors to Match Style (for 4.1.4 and above)

            Steve Machol Photography


            Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


            Comment


            • #7
              hmm, what's wierd is that even though I enter the info, after I click continue, the semi-colon - ; is not there in the query box at the end of the second line, thus the error.

              Mark
              Mark

              Comment


              • #8
                You may have a real old version of phpMyAdmin. Try it without the semi-colon.
                Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
                Change CKEditor Colors to Match Style (for 4.1.4 and above)

                Steve Machol Photography


                Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


                Comment


                • #9
                  Manual Query: Only one query can be run at a time

                  (blushes) performing each query separately did the trick!

                  Thanks Steve, for putting up with my slow learning.
                  I won't forget this one!

                  Cheers,
                  Mark
                  Mark

                  Comment

                  Loading...
                  Working...
                  X