Reset poll

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • jmd
    Senior Member
    • Jan 2002
    • 666

    Reset poll

    Hello

    I started a poll on my forum but the members came up with quite a few new listings for the poll

    6 people voted but I want to clear all votes and allow the people who aleady voted to re vote

    How do I do this??

    Thanks
    PLEASE VISIT US HERE. THANKS IN ADVANCE
  • Steve Machol
    Former Customer Support Manager
    • Jul 2000
    • 154488

    #2
    There is no way of doing this, except perhaps by modifying the database directly. It would be easier just to start a new poll.
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment

    • jmd
      Senior Member
      • Jan 2002
      • 666

      #3
      Oh no

      This poll is huge
      PLEASE VISIT US HERE. THANKS IN ADVANCE

      Comment

      • Steve Machol
        Former Customer Support Manager
        • Jul 2000
        • 154488

        #4
        Then modify the database directly.
        Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
        Change CKEditor Colors to Match Style (for 4.1.4 and above)

        Steve Machol Photography


        Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


        Comment

        • jmd
          Senior Member
          • Jan 2002
          • 666

          #5
          How do I do that steve??
          PLEASE VISIT US HERE. THANKS IN ADVANCE

          Comment

          • Steve Machol
            Former Customer Support Manager
            • Jul 2000
            • 154488

            #6
            You'd have to do this manually, and frankly since I've never done it I hesitate to offer any specific suggestions. You might want to set up a test poll, then go into the database and play with that first. Whatever you do, make a backup of your db first.
            Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
            Change CKEditor Colors to Match Style (for 4.1.4 and above)

            Steve Machol Photography


            Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


            Comment

            • jmd
              Senior Member
              • Jan 2002
              • 666

              #7
              what database do you modify??
              Steve
              Thanks

              I can't belive VB would not let you reset the votes so people could revote

              My God I hope VB3 has this.
              PLEASE VISIT US HERE. THANKS IN ADVANCE

              Comment

              • Steve Machol
                Former Customer Support Manager
                • Jul 2000
                • 154488

                #8
                The vB database of course. (The one specified in your config.php file.)
                Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
                Change CKEditor Colors to Match Style (for 4.1.4 and above)

                Steve Machol Photography


                Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


                Comment

                • jmd
                  Senior Member
                  • Jan 2002
                  • 666

                  #9
                  LOL

                  Sorry I ment to ask what file not database

                  Thanks I will hold off untill I see if anyone has done this before I mess with configphp



                  If anyone knows how to do this it would be appreciated

                  Thanks
                  PLEASE VISIT US HERE. THANKS IN ADVANCE

                  Comment

                  • Cary
                    Senior Member
                    • Apr 2002
                    • 4433
                    • 3.6.x

                    #10
                    phpMyAdmin --> Click the 'Poll' table (to your left) --> Browse (to your right) --> Click 'Edit' next to the poll you want to reset.

                    If you have 10 options in your poll and your options are 1, 2, 3, 4, 6, 7, 8, 9, 10 your 'options' field would look like

                    1|||2|||3|||4|||5|||6|||7|||8|||9|||10
                    And - your 'votes' field would look like
                    3|||5|||0|||7|||10|||2|||1|||1|||6|||0
                    (depending on which options has certain amouts of votes.

                    I.E. Option '1' would have 3 votes

                    Change your 'votes' field to i.e.
                    0|||0|||0|||0|||0|||0|||0|||0|||0|||0
                    (In other words, all 0's)

                    Next run the following query:

                    DELETE from pollvote WHERE pollvoteid = (Your Poll ID Number Goes Here)

                    Backup Your Database First!

                    Comment

                    • jmd
                      Senior Member
                      • Jan 2002
                      • 666

                      #11
                      Thanks Cary
                      PLEASE VISIT US HERE. THANKS IN ADVANCE

                      Comment

                      • MUG
                        Senior Member
                        • Apr 2002
                        • 1191
                        • 2.3.0

                        #12
                        Originally posted by Cary
                        phpMyAdmin --> Click the 'Poll' table (to your left) --> Browse (to your right) --> Click 'Edit' next to the poll you want to reset.

                        If you have 10 options in your poll and your options are 1, 2, 3, 4, 6, 7, 8, 9, 10 your 'options' field would look like



                        And - your 'votes' field would look like
                        (depending on which options has certain amouts of votes.

                        I.E. Option '1' would have 3 votes

                        Change your 'votes' field to i.e. (In other words, all 0's)

                        Next run the following query:

                        DELETE from pollvote WHERE pollvoteid = (Your Poll ID Number Goes Here)

                        Backup Your Database First!
                        Cary, that won't work... the query should be:

                        DELETE FROM pollvote WHERE pollid=(poll ID)

                        Comment

                        • Cary
                          Senior Member
                          • Apr 2002
                          • 4433
                          • 3.6.x

                          #13
                          Originally posted by MUG
                          Cary, that won't work... the query should be:

                          DELETE FROM pollvote WHERE pollid=(poll ID)
                          Thanks for the correction.

                          Comment

                          • Flight_Teacher
                            New Member
                            • May 2007
                            • 9
                            • 3.6.x

                            #14
                            Just a little update. Although this thread is older, it still works perfectly with vbulletin 4.1. I just did it without a hitch.

                            Plug-in developers take note: there is definitely demand for a simple "reset poll" plugin. Would be easy (I think)

                            Comment

                            widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
                            Working...