vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)
-   -   Administrative and Maintenance Tools - Table and Field Comparison Utility: Compare your database to out-of-the-box vBulletin (https://vborg.vbsupport.ru/showthread.php?t=235476)

Rebecca217 03-01-2010 05:00 PM

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

Farid 03-09-2010 11:49 AM

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 03-31-2010 06:33 PM

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 03-31-2010 06:39 PM

Very nice thanks

robbiefritz 04-29-2010 11:36 PM

Has anyone used this on 4.03?

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

robbiefritz 05-06-2010 06:27 PM

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

Quote:

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 05-22-2010 04:29 PM

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 06-06-2010 02:22 PM

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

Quote:

Originally Posted by Farid (Post 2000393)
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 06-10-2010 05:31 PM

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

Boofo 06-10-2010 05:43 PM

Quote:

Originally Posted by Abhik (Post 2051650)
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.


All times are GMT. The time now is 02:16 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.00998 seconds
  • Memory Usage 1,734KB
  • 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
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete