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)

Abhik 06-13-2010 11:45 AM

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_")
http://img14.imageshack.us/img14/3868/capturecq.jpg

Boofo 06-13-2010 11:56 AM

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

Abhik 06-13-2010 04:56 PM

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 06-13-2010 05:08 PM

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 06-14-2010 03:11 AM

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

Boofo 06-14-2010 04:30 AM

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 06-14-2010 04:30 PM

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

Boofo 06-14-2010 08:40 PM

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 06-15-2010 09:45 AM

:)
[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 06-15-2010 10:16 AM

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

Thanks for your time :)


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.00979 seconds
  • Memory Usage 1,729KB
  • 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)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