vb.org Archive - Remove all attachments?

Page 1 of 2

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)

- - Remove all attachments? (https://vborg.vbsupport.ru/showthread.php?t=301996)

Reece^B

09-07-2013 05:22 PM

Remove all attachments?

Hi

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

Is there a MySQL command?

ozzy47

09-07-2013 06:57 PM

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

Reece^B

09-08-2013 06:48 AM

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

snakes1100

09-08-2013 07:13 AM

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

09-08-2013 11:54 AM

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

For attachments:

Try running this query:

Code:

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:

Code:

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

For profile pics:

Try running this query:

Code:

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

09-08-2013 06:55 PM

Quote:

Originally Posted by ozzy47 (Post 2444112)

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

For attachments:

Try running this query:

Code:

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

09-10-2013 07:40 PM

Is there a way to reset sigs?

ozzy47

09-10-2013 11:40 PM

To what?

Reece^B

09-11-2013 08:13 PM

blank

Reece^B

09-13-2013 05:18 AM

anyone?

All times are GMT. The time now is 05:57 AM.

Page 1 of 2

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01097 seconds Memory Usage 1,728KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (4)bbcode_code_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: