Poll Error

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Stratto
    New Member
    • Jun 2007
    • 11
    • 3.7.x

    Poll Error

    Hey again, I'm having another problem. This time, an error when somebody clicks on a poll and the poll not appearing for other users to click on. It appears for me but registered users cannot vote even when their usergroup allows it, this is the error thing.

    Code:
    Invalid SQL:
    INSERT IGNORE INTO _inanopollvote
        (pollid, votedate, voteoption, userid, votetype)
    VALUES
        (461, 1211536720, 4, 157, 0);
    
    MySQL Error   : Unknown column 'votetype' in 'field list'
    Error Number  : 1054
    I have searched the forums and cannot do that SQL query as I don't have all the access to the site, as I do it all for a friend because he doesn't know how. So I tend to work on the forums for them. Is there any other way?


    Any and all help would be appreciated as I cannot find out whats going on.
    Thank you.
    Last edited by Stratto; Fri 23 May '08, 2:40am.
    Rekuaza ~ Website Collective.
  • zCarot [RU]
    Senior Member
    • Oct 2006
    • 109
    • 3.7.x

    #2
    You can try to execute this SQL query:
    Code:
    ALTER TABLE _inanopollvote ADD votetype INT UNSIGNED NOT NULL DEFAULT '0'
    By the way, this SQL is executed in upgrade to vBulletin Beta 6. Are you sure, that you ran /install/upgrade.php? Try it at first.

    Comment

    • Stratto
      New Member
      • Jun 2007
      • 11
      • 3.7.x

      #3
      Yes, I ran the upgrade twice to make sure and it does all the steps properly.

      I went to maintanace and, execute sql query but it wont let me. I do not have the access to mySQL, I only have ftp and admin. Since Its on a friends website and I have told them to run that but they don't know how to..I could If I was able >>;
      Rekuaza ~ Website Collective.

      Comment

      • zCarot [RU]
        Senior Member
        • Oct 2006
        • 109
        • 3.7.x

        #4
        Just insert your user id to includes/config.php
        PHP Code:
        $config['SpecialUsers']['canrunqueries'] = 'USER_ID'

        Comment

        • Stratto
          New Member
          • Jun 2007
          • 11
          • 3.7.x

          #5
          Yeah, silly me ^^;

          Ok, done and it works thank you. I have another problem but I don't know if I should make another topic for it? I'd hate to be seen as spamming.
          Rekuaza ~ Website Collective.

          Comment

          • zCarot [RU]
            Senior Member
            • Oct 2006
            • 109
            • 3.7.x

            #6
            Yes. You must start a new thread

            Comment

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