[tehste]

Hey. After voting on the randome poll off the vbindex main page, any other attempts to view that page would return with this database error:

Database error in vBulletin 3.0.0:

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 = 2)
			WHERE forumid NOT IN (0)
			AND deletionlog.primaryid IS NULL
			AND thread.pollid <> 0
			AND thread.open <> 10
			AND thread.visible = '1'
			AND thread.forumid IN (1,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28)
			
			
			ORDER BY RAND() DESC
			LIMIT 1
mysql error: Got error 28 from table handler

mysql error number: 1030

Date: Saturday 27th of March 2004 03:20:07 AM
Script: http://www.lemonpoo.com/

Any Ideas how to fix this? And what caused it... And weather it is fixed in RC4


Edi: After refreshing it numerous times as soon as it happened it stayed on the error page... I then waited 10 mins and re-freshed again and it was fixed... I even kept refreshing to see if the same poll I voted on worked in the main page.. And it did. Very curious, anyi ideas

Also you can see I grab my randome poll from practically all the forums bar 4ish... Is this bad for the code? Also, If i set it on to all, and there is a poll in a forum wich not everyone has acsess to, will someone without rights to view that forum be able to view the poll.
And is there a way to set it to all and just leave a few not checked ever....