I have a poll erorr and it's really tickign me off.
Here's the SQL error I get.
Database error in vBulletin 3.0.3:
Invalid SQL:
## GET POLL ##
SELECT thread.pollid, thread.forumid, open, threadid, replycount, question, poll.dateline,
options, votes, active, numberoptions, timeout, multiple, voters,
pollvote.voteoption, pollvote.userid AS voteuserid
FROM thread AS thread
LEFT JOIN poll AS poll ON (thread.pollid = poll.pollid)
LEFT JOIN deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND type = 'thread')
LEFT JOIN pollvote AS pollvote ON(thread.pollid = pollvote.pollid AND pollvote.userid = 1)
WHERE forumid NOT IN (0,20)
AND deletionlog.primaryid IS NULL
AND thread.pollid <> 0
AND thread.open <> 10
AND thread.visible = '1'
AND thread.forumid IN (21)
ORDER BY RAND() DESC
LIMIT 1
mysql error: Got error 28 from table handler
mysql error number: 1030
Date: Thursday 14th of October 2004 09:36:16 PM
Script:
http://www.smackdownvsraw.net/
Referer:
http://forums.smackdownvsraw.net/
Username: E f E d H h H
IP Address: 24.14.0.240