how do i get rid of all post attachments?

[Jake Bunce]

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.

[Wayne Luke]

update post set attachmentid=0
delete from attachment

[Jake Bunce]

thx wluke

[Jake Bunce]

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!

[Wayne Luke]

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