vb.org Archive
Page 2 of 6 1 2 34 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.8 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=235)
-   -   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=209890)

Hornstar 03-31-2009 09:19 AM
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 03-31-2009 01:29 PM
This is a great mod.

Will be very useful for one of my sites.

Thank you very much

calorie 03-31-2009 01:36 PM
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:
Code:
# 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 03-31-2009 01:44 PM
Quote:
Originally Posted by ragtek (Post 1780539)
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 04-01-2009 04:28 PM
great .... thanks

Magnumutz 04-02-2009 07:55 AM
This sure is sweet for checking on your database for foreign tables :)
Another great job by Calorie!

ahmed-samara 04-02-2009 11:20 AM
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 05-05-2009 11:15 AM
** never mind, i figured it out

Thomas P 06-19-2009 09:10 PM
Thanks for the Mod and the fix, great work.
Quote:
Originally Posted by calorie (Post 1781067)
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 09-16-2009 03:15 PM
vBulletin should really detect it's own blog software and not view it as an addon.


All times are GMT. The time now is 08:30 AM.
Page 2 of 6 1 2 34 Last »
Show 40 post(s) from this thread on one page

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.01139 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
  • (1)bbcode_code_printable
  • (2)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