The Arcive of Official vBulletin Modifications Site.

oldfan · #1 05-11-2009, 01:55 PM

Sorry if this is the wrong forum to ask this question...

Our forums/database is about 7 years old and I've lost track if what mods and modifications I've done over the years. Its a really bloody mess and I'd like to start of fresh and keep better tads on it this time.

I know you can transfer posts, threads and users, but will all the db tables/fields be reset to default? I don't want my users to have to re-register if they don't have to.

thanks

Biker_GA · #2 05-11-2009, 01:58 PM

As far as I know, there's no way to easily import the default tables/data into a new DB. You basically have to go through the DB and manually drop the tables that don't apply to your installation any longer. Something that's been on my "To Do" list for some time now.

Cryo · #3 05-11-2009, 02:05 PM

Do you want to completely get rid of all the tables and start with fresh ones? If you're upgrading from a previous version of vB it should just be a simple matter of upgrading and the installer will take care of the rest. If you want to start with completely fresh tables you should look at the vB importer. I'm pretty sure this will take source data from your existing tables and copy it correctly into the new installation / tables.

If you're just upgrading you can start fresh with a new style and system files and not worry about any past modifications. Granted, you may have some useless entries in your tables, but they won't be used so it should have virtually no effect on the speed of queries.

oldfan · #4 05-11-2009, 02:41 PM

Quote:

Do you want to completely get rid of all the tables and start with fresh ones?

yes

Fresh everything along with software upgrade, I just want to transfer posts, threads and users, minus all the modications I've added over the years.

Biker_GA · #5 05-11-2009, 02:45 PM

I asked the same question not too long ago.

oldfan · #6 05-11-2009, 02:57 PM

Quote:

Originally Posted by Biker_GA

I asked the same question not too long ago.

oh man

Quote:

Database hacks. You need to use a program like phpmyadmin to browse your database and remove custom tables and fields.

How do I know which ones I can remove and not to remove ?

Biker_GA · #7 05-11-2009, 03:02 PM

Heh.. There's the rub. There are version numbers associated with the tables, so much of it is an easy no brainer (I have tables from version 2.0!). The easiest way, I guess would be to print out the table structure for a "virgin" install and compare it to the existing one.

oldfan · #8 05-11-2009, 03:16 PM

Quote:

Another option is to import your database into a fresh installation of vBulletin. I recommend this only as a last resort if the database is unusable and you don't have a working backup. The import doesn't get everything and there are side effects. For example, the autoincrementids are not preserved so all previous internal links and bookmarks will be broken.

Whats the chances this would happen?

Biker_GA · #9 05-11-2009, 03:18 PM

100%. As Jake stated, it's a "last resort" item done in desperation. I'm not willing to break everything in old posts.

Lynne · #10 05-11-2009, 03:39 PM

Quote:

Originally Posted by oldfan

How do I know which ones I can remove and not to remove ?

You may be interested in this modification - Table and Field Comparison Utility: Compare your database to out-of-the-box vBulletin

Remember that you should do this first on a test site, not your live site.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04580 seconds Memory Usage 2,259KB Queries Executed 13 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (1)ad_showthread_firstpost (1)ad_showthread_firstpost_sig (1)ad_showthread_firstpost_start (5)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)navbar (3)navbar_link (120)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (10)post_thanks_box (10)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (10)post_thanks_postbit_info (10)postbit (10)postbit_onlinestatus (10)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.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/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_postinfo_query fetch_postinfo fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!