vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   How remove one million of threads? (https://vborg.vbsupport.ru/showthread.php?t=299226)

Concha 06-17-2013 08:39 PM

How remove one million of threads?
 
I want remove one million of threads and 2 million posts.
These threads are in one forum.

What is the best form to remove this?

snakes1100 06-17-2013 08:43 PM

Simply deleting the forum via the "forum manager" will do what you want, but with that many threads/posts in it, im going to guess you will have a few timeout issues, your going to have to change a few settings via php & mysql to get around the timeouts.

ForceHSS 06-17-2013 08:43 PM

snake beat me to it was just going to say that myself

Concha 06-17-2013 08:45 PM

Quote:

Originally Posted by snakes1100 (Post 2428783)
Simply deleting the forum via the "forum manager" will do what you want, but with that many threads/posts in it, im going to guess you will have a few timeout issues, your going to have to change a few settings via php & mysql to get around the timeouts.

Quote:

Originally Posted by ForceHSS (Post 2428784)
snake beat me to it was just going to say that myself

What is specifically that option?


this?
thread.php?do=prune

snakes1100 06-17-2013 08:48 PM

Any timeout settings via php or mysql.

Most likely memory settings as well.

Without running it myself, i cant say what all errors you will run into, most likely, you will run into some more mysql errors unrelated to timeouts anyways.

Are you doing this because you think its causing server issues?

Concha 06-17-2013 08:53 PM

Quote:

Originally Posted by snakes1100 (Post 2428786)
Any timeout settings via php or mysql.

Most likely memory settings as well.

Without running it myself, i cant say what all errors you will run into, most likely, you will run into some more mysql errors unrelated to timeouts anyways.

Are you doing this because you think its causing server issues?

Is a cleaning, because are message from bots and spammers.

All threads are in one ID Forum.

What is the option in admincp?

snakes1100 06-17-2013 08:56 PM

There is no option in the admincp to change php or mysql settings, those are system programs.

As stated in the earlier post, you can try deleting the forum via the "forum manager", but its most likely going to error out with that many threads/posts in it.

Concha 06-17-2013 09:00 PM

Quote:

Originally Posted by snakes1100 (Post 2428791)
As stated in the earlier post, you can try deleting the forum via the "forum manager", but its most likely going to error out with that many threads/posts in it.

And delete these thread with phpmyadmin?

snakes1100 06-17-2013 09:02 PM

No, you cant do that.

Remove it as stated previously.

Concha 06-17-2013 09:07 PM

Quote:

Originally Posted by snakes1100 (Post 2428793)
No, you cant do that.

Remove it as stated previously.

Ok. But my question is, where delete these threads in admincp of vbulletin?

admincp/thread.php?do=pruneedit
admincp/thread.php?do=prune
admincp/other?


Thanks!!


All times are GMT. The time now is 03:49 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.00993 seconds
  • Memory Usage 1,735KB
  • 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
  • (5)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