thread title does not match poll!

[josh929]

http://www.somegoodstuff.com/forums/showthread.php?threadid=24

click "view results", and then notice which thread it says you are in!

[josh929]

by the way, the thread that it says that you are in up top is actually not even in the forum it says its in (although there is a redirect in left in that forum). the thread that it says you're in is actually in the same forum as the poll thread.

anyways, anyone know what's up?

[Mike Sullivan]

Regarding view results, check the thread notes on that thread (the Edit Thread link) -- anything there?

And what forum is it *supposed* to be in? It says it's in the "Rants, Off Topic..." forum and it indeed shows up there on forumdisplay.

[josh929]

Regarding view results, check the thread notes on that thread (the Edit Thread link) -- anything there?

And what forum is it *supposed* to be in? It says it's in the ";Rants, Off Topic..."; forum and it indeed shows up there on forumdisplay.
there are no moderator notes, if that's what you're talking about?

and yes, it is supposed to be in "off-topic", as it was moved from a politics forum.

however, notice that when you're viewing the votes/who voted of the "leno or letterman" thread, it says this at the top:
SomeGoodStuff.com Discussion & Debate Forums (http://www.somegoodstuff.com/forums/index.php?) > Politics, Issues & Current Events (http://www.somegoodstuff.com/forums/forumdisplay.php?forumid=13) > Politics & Issues (http://www.somegoodstuff.com/forums/forumdisplay.php?forumid=6) > Susan Sontag, a simply shameful person (http://www.somegoodstuff.com/forums/showthread.php?threadid=17)


But, when you click on the above "susan sontag" thread link, it takes you to the proper thread ("leno or letterman" in the proper forum (which is "off topic", as stated before).

Note (not sure if it's important):
The "susan" thread incorrectly referred to in the link WAS moved from the "politics" forum to the "offtopic" forum, but the "leno" thread has been in offtopic the whole time.

So I'm wondering if this is some sort of bug that happens when you do one or a combo of the things I mentioned above?

[Scott MacVicar]

Open poll.php

look for
$threadinfo = $DB_site->query_first("
SELECT *, NOT ISNULL(deletionlog.primaryid) AS isdeleted
FROM " . TABLE_PREFIX . "thread AS thread
LEFT JOIN " . TABLE_PREFIX . "deletionlog AS deletionlog ON(deletionlog.primaryid = thread.threadid AND deletionlog.type = 'thread')
WHERE pollid = $pollid
");
replace with
$threadinfo = $DB_site->query_first("
SELECT *, NOT ISNULL(deletionlog.primaryid) AS isdeleted
FROM " . TABLE_PREFIX . "thread AS thread
LEFT JOIN " . TABLE_PREFIX . "deletionlog AS deletionlog ON(deletionlog.primaryid = thread.threadid AND deletionlog.type = 'thread')
WHERE pollid = $pollid AND open <> 10
");
Only part you are adding is the AND open <> 10

This was a complete fluke btw. When you moved your thread the new threadid was the same as the pollid and as we didn't check that the thread title wasn't a redirect you got the wrong result.

[josh929]

Thank you. :)