vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)
-   -   [Help] Please huge mistake! (https://vborg.vbsupport.ru/showthread.php?t=278200)

Kraxell 02-07-2012 09:06 PM

Ahhh....i use 4.1.9, there are no option for this....
Maybe try this:

ACP -> Maintenace -> SQL-Query
Maybe there is an option for this. Otherwise we must wait for tomorow, Lynne know the table for this command (iam sure).

GateKeeper_ 02-07-2012 09:09 PM

Quote:

Originally Posted by Kraxell (Post 2297305)
Ahhh....i use 4.1.9, there are no option for this....
Maybe try this:

ACP -> Maintenace -> SQL-Query
Maybe there is an option for this. Otherwise we must wait for tomorow, Lynne know the table for this command (iam sure).

Yeah there is no option in SQL-Query, I will just do as many as I can today, and wait for the command tomorrow.

Kraxell 02-07-2012 09:12 PM

stop to do that manually, you can do it tomorow with one command, i'll help you then.

GateKeeper_ 02-07-2012 09:49 PM

Quote:

Originally Posted by Kraxell (Post 2297308)
stop to do that manually, you can do it tomorow with one command, i'll help you then.

Okay I will wait until tomorrow thank you for your help and time.

TalkVirginia 02-07-2012 10:17 PM

Hey Gatekeeper,

Sorry to hear about all the trouble you're having. I just got an email about this. I just got home from work and will take a look at a fix for this. Can't promise a fix tonight but I'll do my best.

Thanks
Jim

GateKeeper_ 02-07-2012 11:58 PM

Quote:

Originally Posted by TalkVirginia (Post 2297328)
Hey Gatekeeper,

Sorry to hear about all the trouble you're having. I just got an email about this. I just got home from work and will take a look at a fix for this. Can't promise a fix tonight but I'll do my best.

Thanks
Jim

Thank you so much. I really appreciate your help. I will be waiting for the fix.

Best Regards,
GateKeeper

TalkVirginia 02-08-2012 12:47 AM

Quote:

Originally Posted by GateKeeper_ (Post 2297353)
Thank you so much. I really appreciate your help. I will be waiting for the fix.

Best Regards,
GateKeeper

How many top-level forum categories do you have?

I recommend taking a backup of your forum database before doing this.

You can run this SQL Query to enable the options listed below for ALL forums and categories however it will also change ALL of your top-level forum categories to look and act as forums. You will need to edit the options under the forum posting options to switch them back to top level categories.

Allow BB Code
Allow [IMG] Code
Allow [VIDEO] Code
Allow Smilies
Allow Post Icons
Allow Thread Ratings in this Forum
Count Posts Made in this Forum Towards User Post Counts
Show this Forum and Child Forums on the Quick Navigation menu


You will need to change to query to match the table prefix you are using. For instance, I'm using the "vb_" in front of all my vb table names. You should be able to run this from the maintenance section of your admincp or you can use phpmysqladmin.

Code:


UPDATE TABLEPREFIX_forum
SET options = '360135';

I'll try to add these options this weekend to the addon. Let me know if you have any questions.
hopefully this will make things a little easier. This was tested on vb 4.1.10.

Jim

GateKeeper_ 02-08-2012 01:54 AM

Thank you Jim, it worked but there are extra lines now. Is that normal and what does that mean? Anyways this saved me tons of time! Really appreciate it.

https://vborg.vbsupport.ru/external/2012/02/51.png

--------------- Added [DATE]1328670730[/DATE] at [TIME]1328670730[/TIME] ---------------

I used ACP > Management > Execute SQL Query >

UPDATE TABLEPREFIX_forum
SET options = '360135';

(With my table prefix)

TalkVirginia 02-08-2012 05:44 AM

Quote:

Originally Posted by GateKeeper_ (Post 2297383)
Thank you Jim, it worked but there are extra lines now. Is that normal and what does that mean? Anyways this saved me tons of time! Really appreciate it.

I used ACP > Management > Execute SQL Query >

UPDATE TABLEPREFIX_forum
SET options = '360135';

(With my table prefix)

Glad to hear it helped. :) I'm not sure what you mean by extra lines though.

GateKeeper_ 02-12-2012 10:17 PM

Quote:

Originally Posted by TalkVirginia (Post 2297415)
Glad to hear it helped. :) I'm not sure what you mean by extra lines though.

Can you also give me the sql command that enables "Moderate Thread" under "Moderation Options" please. I forgot to enable this option for over 10,000 child forums. :( Doing it manually will take me over 24 hours of work.


All times are GMT. The time now is 09:32 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.01065 seconds
  • Memory Usage 1,740KB
  • 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
  • (6)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)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