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.

[Rebecca217]

This is exactly what I was looking for. Thank you!

[Farid]

Interesting tool!

But I wish the [Ask for Query] was working though...

I have a few out-of-the-box vBulletin fields that are not in my vBulletin tables:
holiday: varname
subscription: varname
userfield: field1
usergroup: albumpicmaxsize

...but now I have no idea how important these are, how come they are not there, and if/how I should be fixing the problem... :erm:

[MrBlaQ]

This util helped me a lot after an upgrade from 2.2.6 to 4.0.2 PL4. I had a lot of left over profile fields in my user table that were interfering with the postbit building functions. For instance, I had a "message" profile field on my 2.2.6 board and when I upgraded to 4.0.2, those fields were moved to the new profile structure. But, the old columns weren't deleted from the DB. What happened was the postbit message context was being merged with the user context. Both had a [message] key and since the user->message key was blank, my PM messages were showing up blank.

[safakuygur]

Very nice thanks

[robbiefritz]

Has anyone used this on 4.03?

Update: Tested on my test forum and all worked well. THanks

[robbiefritz]

Besides the permissions that one needs to set for the Admin, one needs to make the following change also.

You are not authorized to execute SQL queries. You need to edit your vBulletin config.php file, replacing X with your user ID in the following line: $config['SpecialUsers']['canrunqueries'] = 'X';

[Boofo]

In vb version 4.0.3 it is showing blog_attachmentlegacy under "The database tables that are not a part of out-of-the-box vBulletin", on the suite. I have not added this table.

Good job, Calorie. This is great!

[Hippy]

Same issue
did you find a fix ?
I posted over at vb.com as well
On test upgrade DB and the live forum
holiday: varname
subscription: varname
usergroup: albumpicmaxsize

Originally Posted by Farid

Interesting tool!

But I wish the [Ask for Query] was working though...

I have a few out-of-the-box vBulletin fields that are not in my vBulletin tables:
holiday: varname
subscription: varname
userfield: field1
usergroup: albumpicmaxsize

...but now I have no idea how important these are, how come they are not there, and if/how I should be fixing the problem... :erm:

[Abhik]

Any idea when this mod going to officially released for vb 4.0.3 PL1?

[Boofo]

Originally Posted by Abhik

Any idea when this mod going to officially released for vb 4.0.3 PL1?

It already works for 4.0.3 PL1. There is only one entry missing (in my above post) but other than that, it works fine.