Administrative and Maintenance Tools - Table and Field Comparison Utility: Compare your database to out-of-the-box vBulletin

What is it?

This utility makes a comparison between the tables and fields in your database and the out-of-the-box vBulletin tables and fields.

It reports the following differences:

• The out-of-the-box vBulletin tables that are not in the database
• The database tables that are not a part of out-of-the-box vBulletin
• The out-of-the-box vBulletin fields that are not in the vBulletin tables
• The fields that are in the vBulletin tables but not a part of out-of-the-box vBulletin

New Features

• Ability to delete extraneous tables and fields from the compareutility.php file
  • Don't screw up your vBulletin database!

Installation

1. FTP the compareutility.php file into your /admincp directory in ASCII mode.
2. Go to the following page with your browser: http://www.YOUR-DOMAIN.com/YOUR-FORUM-DIR/YOUR-ADMINCP-DIR/compareutility.php
3. You need to set the following to yes to access the compareutility.php file:
   • ACP -> Usergroups -> Administrator Permissions -> Edit Permissions -> Can Run Maintenance Tools
4. To add a link to compareutility.php under the ACP -> Maintenance sidebar see this post.

UN-installation

1. Delete the compareutility.php file from your server.
2. Delete the cpnav_compare_db.xml from your server (from this post).

vBulletin version?

• Only tested on vBulletin 4.0.0 PL1 and 4.0.1
• May not work correctly on vBulletin 4.0.2
• May work on vBulletin 3.5 and up
• Won't work on less than vBulletin 3.5
• The vB3 version is located here

Screenshot

• None, run the script to see the report.

[Abhik]

Hello,
I have analyzed my database with this tool. I have these "The out-of-the-box vBulletin fields that are not in the vBulletin tables"

Can you help me to put them back? (I have a table prefix "mst_")

[Boofo]

What do you mean "put them back"? They are already there.

[Abhik]

Isn't they are the fields which are supposed to be in the tables?
I mean, my mst_groupmessage table doesn't have any field called discussionid
mst_pmtext table doesn't have any field called reportthreadid
mst_profilefieldcategory table doesn't have any field called allowprivacy
mst_usergroup table doesn't have any field called albumpicmaxsize.

So, is there any way, by queries, I can put those fields back in the tables?

[Boofo]

Those are fields, not tables in that pic you posted. They wouldn't be there unless the table that holds them was there also. You are fine.

[Abhik]

The tables are there.. not the fields/columns in those tables.

[Boofo]

You're not understanding. Those are NOT tables. They are fields. Look at what it says in the header. If that stuff was not there, you would be getting all sorts of errors on the site when it tried to use those. If you are still concerned, re-install the product.

[Abhik]

Okay, mst_groupmessage, mst_pmtext, mst_profilefieldcategory and mst_usergroup are fields, not tables?

[Boofo]

Yes, according to the pic you posted. They are considered columns. But I have been reading it wrong. According to that pic, you are right, they are not there.

Have you tried clicking on the [Ask for Query] link? I would first physically go to the db and make sure they are not there before I did anything, though.

[Abhik]

[Ask for Query] isn't clickable.
I manually checked the database and those fields indeed are absent from corresponding tables.

I guess only some manual queries can create those fields. It'd be very helpful for me if someone can tell me that.

[Abhik]

Okay..
I got the details from mysql-schema.php, run those queries and everything seems to work fine.

Thanks for your time