vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   Whats the best way of doing this? (https://vborg.vbsupport.ru/showthread.php?t=179088)

Andy92 05-13-2008 02:04 PM

Whats the best way of doing this?
 
Hey,

I have a forum thats been running for around 3 months now. It has a few hundred members, and basically i want to delete all the threads and categories and start again with them, but keep all the members, pms, etc.

Whats the best way of going about deleting just the threads and categories and starting again from scratch?

veenuisthebest 05-13-2008 03:31 PM

Go to AdminCP->Forums and Moderators->Forum Manager->See in Controls column and click dropdown->Delete Forum.

Doing so Deletes the forum, any subforums, and posts in the forum and any subforums. This action cannot be undone, so it is highly recommended that you make a backup of your database before doing this.

Andy92 05-13-2008 05:02 PM

Ok, but after i do this and delete them all, when i go to create a new category will it start with the id as 1 again, or will it continue from like 70 something? And will the same happen with posts?

CommanderFluffy 05-13-2008 05:42 PM

why dont you just go to your admin and prune all posts before july 2007 so your members dont get confused and completely messed up as to why the posts that might be still active vanish. some may think you have been hacked!

veenuisthebest 05-13-2008 05:52 PM

Quote:

Originally Posted by Andy92 (Post 1518486)
Ok, but after i do this and delete them all, when i go to create a new category will it start with the id as 1 again, or will it continue from like 70 something? And will the same happen with posts?

have never done this myself (and would never do)

Does ID's matter that much to you??

If yes, then do it in your test board first !!!!!! and see for yourself .. I think it would continue..

Andy92 05-13-2008 07:29 PM

Hmm, what if i go into mysql and empty the table? Thats after its been emptied by vbulletin. Then the ids will start again.

:)

veenuisthebest 05-13-2008 07:39 PM

have thought about it earlier... but do you know which tables and how many to empty..

--------------- Added [DATE]1210711389[/DATE] at [TIME]1210711389[/TIME] ---------------

its not a big task.. but I suggest you and recommend .. that you open a support ticket for this before starting to empty tables .. atleast you should be sureeee enough which tables to empty.

By the way.. if you successfully do this.. do not forget to post back, what you did !! this would help other users to know

CommanderFluffy 05-14-2008 03:32 AM

well this is what i would sugest if you may take this line of action. delete the forum and start from scratch members and all.. cause thats what you are typically doing. well unless your website hasnt had an active member in months then just prune or delet all cause i highly doubt you can get back to id 1 again unless you reinstall

Andy92 05-14-2008 08:36 PM

Ok, what ive done is gone onto the admin cp and deleted all the forums with all the posts on, and also all the reputation.

Then to make sure just the reputation, posts and categories start from id 1 again, i have gone into PhpMyAdmin and basically emptied the threads, posts, forums and reputation tables.

Now they have all started from id 1 again, and everything is working!

:)


All times are GMT. The time now is 01:39 PM.

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.01191 seconds
  • Memory Usage 1,724KB
  • 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
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (9)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
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete