1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Vbulletin thread subscribe question

Discussion in 'Content Management' started by Revelations-Decoder, Jan 20, 2010.

  1. #1
    I am not completely sure this is the correct forum for this, but if not my apologies, it seemed the most likely to me!

    I have a VBulletin forum and neglected to make it default that people would get subscribed to threads unless opting out when they make a thread or post a reply.

    Can someone please tell ne the path in VB admin to where I reset this so people are auto subscribed to threads unless they opt out please.

    I have decided it makes keeping track of activity much simpler and with less clicks to have things set as auto subscribe.

    Thanks in Advance.
     
    Revelations-Decoder, Jan 20, 2010 IP
  2. Brandon Sheley

    Brandon Sheley Illustrious Member

    Messages:
    9,721
    Likes Received:
    612
    Best Answers:
    2
    Trophy Points:
    420
    #2
    you'll first need to go to your vboptions and set the subscription, than you can run a SQL command in the maintenance section of the admincp (near the bottom)


    regards
     
    Brandon Sheley, Jan 21, 2010 IP
  3. Revelations-Decoder

    Revelations-Decoder Well-Known Member

    Messages:
    3,028
    Likes Received:
    152
    Best Answers:
    4
    Trophy Points:
    190
    #3
    Thanks Loco.M

    I will take a look into that. I think I found the part in VB Options but didn't know about the SQL command part!
     
    Revelations-Decoder, Jan 21, 2010 IP
  4. adum

    adum Well-Known Member

    Messages:
    12
    Likes Received:
    1
    Best Answers:
    1
    Trophy Points:
    133
    #4
    What is the SQL command that needs to be run to fix this?

    I made the same mistake as Revelations-Decoder. I noticed that even after I changed the option, existing users will still not be subscribed to the thread after they reply.

    I guess that's the option that need to be rebuilt by the SQL command...

    Btw when I click "Execute SQL Query" I get this error: "You are not authorized to execute SQL queries"

    I guess I could just run the SQL from myPHPadmin anyway, just need to know what the command is. :)

    Thanks so much in advance!

    Best,

    Adam
     
    adum, Feb 9, 2010 IP
  5. adum

    adum Well-Known Member

    Messages:
    12
    Likes Received:
    1
    Best Answers:
    1
    Trophy Points:
    133
    #5
    Found it... vbulletin.com/forum/showthread.php?156290-Default-Thread-Subscription-Mode
     
    adum, Feb 9, 2010 IP
  6. Revelations-Decoder

    Revelations-Decoder Well-Known Member

    Messages:
    3,028
    Likes Received:
    152
    Best Answers:
    4
    Trophy Points:
    190
    #6
    please share here to adum as I had the same not authorized thing yet I am the admin!
     
    Revelations-Decoder, Feb 9, 2010 IP
  7. adum

    adum Well-Known Member

    Messages:
    12
    Likes Received:
    1
    Best Answers:
    1
    Trophy Points:
    133
    #7
    that link tells you how to do it...just edit config.php which is located in the includes folder
     
    adum, Feb 9, 2010 IP
    Revelations-Decoder likes this.
  8. Revelations-Decoder

    Revelations-Decoder Well-Known Member

    Messages:
    3,028
    Likes Received:
    152
    Best Answers:
    4
    Trophy Points:
    190
    #8
    excellent adum/adam got it and have run it Thankey dudey - hopefully that will have me sorted RE that one! Was having trouble locating it.
     
    Revelations-Decoder, Feb 9, 2010 IP
  9. Brandon Sheley

    Brandon Sheley Illustrious Member

    Messages:
    9,721
    Likes Received:
    612
    Best Answers:
    2
    Trophy Points:
    420
    #9
    You don't need to edit the config file if your user has the correct access.
    Go to admincp > maintenance > run SQL command > search for the one you want
     
    Brandon Sheley, Feb 10, 2010 IP
  10. Revelations-Decoder

    Revelations-Decoder Well-Known Member

    Messages:
    3,028
    Likes Received:
    152
    Best Answers:
    4
    Trophy Points:
    190
    #10
    Thanks Loco.M I think I have it all sorted now, just need to test to see if it works when I get a chance
     
    Revelations-Decoder, Feb 10, 2010 IP