Announcement

Collapse
No announcement yet.

Poll Error

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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 23rd May '08, 2:40am.
    Rekuaza ~ Website Collective.

  • #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


    • #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


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

        Comment


        • #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


          • #6
            Yes. You must start a new thread

            Comment

            Loading...
            Working...
            X