Cleaning tags from a thread.

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • What Exit?
    New Member
    • Sep 2009
    • 1
    • 3.8.x

    Cleaning tags from a thread.

    This has been driving me nuts.

    This was my SQL solution:
    Replace the 8389 number with the number of the thread you are cleaning.

    Code:
    SELECT threadid,taglist FROM thread WHERE threadid =8389;
    
    
      SELECT * FROM tagthread WHERE threadid =8389;
    
    
    
    UPDATE thread SET taglist = NULL WHERE threadid = 8389;
    
    
      DELETE FROM tagthread WHERE threadid = 8389;
    The first two just show you the current status. The UPDATE & DELETE do the work. You need to do both.

    Please take all normal precautions with DATABASE changes.

    Good luck,
    Jim
    I run a small general interest vB board:
    http://www.mellophant.com/
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...