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

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

UN-installation

1. Delete the compareutility.php file from your server.

vBulletin version?

• Only tested on vBulletin 3.8.1
• May work on vBulletin 3.5 and up
• Won't work on less than vBulletin 3.5
• The vB4 version is located here

Screenshot

• None, run the script to see the report.

[Hornstar]

The out-of-the-box vBulletin fields that are not in the vBulletin tables: vb3_holiday - varname and vb3_subscription - varname

Is this bad? what should I do?

[gwerzal]

This is a great mod.

Will be very useful for one of my sites.

Thank you very much

[calorie]

It seems that for upgrades the varname field wasn't added to the vB holiday and subscription tables though it doesn't appear to cause problems. For those getting reports about the missing varname field in the vB holiday and subscription tables in your database, run the following queries to add varname to the tables:

# replace vb3_ with your vB table prefix you set in the vB config file

ALTER TABLE vb3_holiday ADD varname VARCHAR(100) NOT NULL DEFAULT '';
ALTER TABLE vb3_holiday ADD INDEX varname (varname);
ALTER TABLE vb3_subscription ADD varname VARCHAR(100) NOT NULL DEFAULT '';

[Biker_GA]

Originally Posted by ragtek

It would be realy cool, if you could delete automaticaly all added tables & fields.

I'll second that one! I've spent hours going through each table trying to find the cause of a recent issue. I ended up blowing off the installation and reinstalling. This would have been a live saver at the time, especially if it would allow me to remove the offending tables/fields.

[ahmed-samara]

great .... thanks

[Magnumutz]

This sure is sweet for checking on your database for foreign tables
Another great job by Calorie!

[ahmed-samara]

well well well ..

my questions is if i have database error like if i drop some table from database i can't use yours file compareutility.php to chack or test ... so i prefer to test the file oursite of the logain to admincp

if we can use something like this link .

www.yoursitename.com/vb/compareutility.php

thanks again to support this file

[snowlion]

** never mind, i figured it out

[Thomas P]

Thanks for the Mod and the fix, great work.

Originally Posted by calorie

It seems that for upgrades the varname field wasn't added to the vB holiday and subscription tables though it doesn't appear to cause problems. For those getting reports about the missing varname field in the vB holiday and subscription tables in your database, run the following queries to add varname to the tables

[choccyclaire]

vBulletin should really detect it's own blog software and not view it as an addon.