Announcement

Collapse
No announcement yet.

Invalid SQL when posting polls

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

  • Invalid SQL when posting polls

    Users are getting the following error when posting polls...

    Database error in vBulletin 2.2.9:
    Invalid SQL: INSERT INTO poll (pollid,question,dateline,options,votes,active,numberoptions,timeout,multiple) VALUES (NULL,'test','1075445829','yes|||no|||maybe|||sometimes','0|||0|||0|||0',1,4,'0','0')
    mysql error: Can't open file: 'poll.MYI'. (errno: 145)
    mysql error number: 1016
    Date: Friday 30th of January 2004 01:57:09 AM
    Script: http://hogwarts.nexcess.net/poll.php
    Referer: http://hogwarts.nexcess.net/poll.php...&polloptions=4
    They can get as far as putting the optoins in, but after that, the problem occurs.

    I'm not sure what would be causing this...

  • #2
    login to phpmyadmin and run the following command

    REPAIR TABLE poll;

    or upload repair.php from your extras folder to your /admin folder. then point your browser at it
    myste.com/forum/admin/repair.php

    either solution should work

    Comment

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