Remove all attachments?

[Reece^B]

Hi

I need to reset all attachments, the DB links to a file path where nothing exists.

Is there a MySQL command?

[ozzy47]

Do you mean remove all of them, or point them to a different path?

[Reece^B]

Remove all known entries (avatars/profile pics/attachments) etc

[snakes1100]

Avatars are seperate from the others, but vb has always had the remove option for attchments built into the attachment manager section.

The others would require some queries.

[ozzy47]

As always, make sure to back up your database before running queries!

For attachments:

Try running this query:

UPDATE post SET attach = 0;

You should then also be able to truncate the attachment table.

If both types of the following images are stored in the database, try these 2 queries...

For avatars:

Try running this query:

DELETE FROM     customavatar USING     customavatar LEFT JOIN     user ON     user.userid = customavatar.userid

For profile pics:

Try running this query:

DELETE FROM     customprofilepic USING     customprofilepic LEFT JOIN     user ON     user.userid = customprofilepic.userid

This is untested, but it should work. Just remember, make sure to back up your database before running queries!

[snakes1100]

Originally Posted by ozzy47

As always, make sure to back up your database before running queries!

For attachments:

Try running this query:

UPDATE post SET attach = 0;

You should then also be able to truncate the attachment table.

I wouldnt do that, use the built in tool provided for vb, as it will reset all the tables that hold attachment info.

[Reece^B]

Is there a way to reset sigs?

[ozzy47]

To what?

[Reece^B]

blank

[Reece^B]

anyone?