Announcement

Collapse
No announcement yet.

How to remove post icon from old threads

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts
    MJM
    Senior Member

  • MJM
    replied
    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

    Leave a comment:

  • Steve Machol
    Former Customer Support Manager

  • Steve Machol
    replied
    You may have a real old version of phpMyAdmin. Try it without the semi-colon.

    Leave a comment:

  • MJM
    Senior Member

  • MJM
    replied
    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

    Leave a comment:

  • Steve Machol
    Former Customer Support Manager

  • Steve Machol
    replied
    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.

    Leave a comment:

  • MJM
    Senior Member

  • MJM
    replied
    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

    Leave a comment:

  • Steve Machol
    Former Customer Support Manager

  • Steve Machol
    replied
    Yes, it's a Manual Query.

    Leave a comment:

  • MJM
    Senior Member

  • MJM
    replied
    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

    Leave a comment:

  • Steve Machol
    Former Customer Support Manager

  • Steve Machol
    replied
    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.

    Leave a comment:

  • MJM
    Senior Member

  • MJM
    started a topic How to remove post icon from old threads

    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
Loading...
Working...
X