Announcement

Collapse
No announcement yet.

how do i get rid of all post attachments?

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

  • how do i get rid of all post attachments?

    i just found out my attachments table is over half my database! i'm considering deleting all my attachments for a few reasons relating to space.

    so how do i do this? i don't see a front end for it in the admin cp. i could directly query the database if i knew the right queries to run.

  • #2
    update post set attachmentid=0
    delete from attachment
    Translations provided by Google.

    Wayne Luke
    The Rabid Badger - a vBulletin Cloud demonstration site.
    vBulletin 5 API

    Comment


    • #3
      thx wluke

      Comment


      • #4
        i am testing this on my test forum. all attachments were successfully deleted along with attachment links in showthread.

        one problem:
        in forumdisplay there are still paperclip icons beside threads that used to have attachments. give me query!

        Comment


        • #5
          Check the thread table and see if there is a "Numattachment" field. Set it to zero by modifying one of the queries above.
          Translations provided by Google.

          Wayne Luke
          The Rabid Badger - a vBulletin Cloud demonstration site.
          vBulletin 5 API

          Comment

          Loading...
          Working...
          X