[Help] Please huge mistake!

[Kraxell]

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_]

Originally Posted by Kraxell

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]

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

[GateKeeper_]

Originally Posted by Kraxell

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]

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_]

Originally Posted by TalkVirginia

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]

Originally Posted by GateKeeper_

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.

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_]

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.



--------------- 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]

Originally Posted by GateKeeper_

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_]

Originally Posted by TalkVirginia

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.