Was bedeutet das nun wieder?!

[M@rkus]

Database error in vBulletin 3.0.0 Release Candidate 2:

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 = )
WHERE forumid NOT IN (1,4,13,16,19,37,35,32,25,26,27,29,17,34,24)
AND deletionlog.primaryid IS NULL
AND thread.pollid <> 0
AND thread.open <> 10
AND thread.visible = '1'
AND thread.forumid IN (38)


ORDER BY RAND() DESC
LIMIT 1
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ')
WHERE forumid NOT IN (1,4,13,16,19,37,35,32,25,26,27,29,17

mysql error number: 1064

Date: Friday 09th of January 2004 12:04:20 AM
Script: http://www.e34m5.de/board/vbindex.php
Referer:
IP Address: 80.62.48.74

[Znaper]

## 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 = ???)
WHERE forumid NOT IN (1,4,13,16,19,37,35,32,25,26,27,29,17,34,24)
AND deletionlog.primaryid IS NULL
AND thread.pollid <> 0
AND thread.open <> 10
AND thread.visible = '1'
AND thread.forumid IN (38)


An der Stelle der roten Fragezeichen, wurde keine Userid übergeben, des ganze liegt aber an Deinem Hack und nicht am Original vB selbst.


mfg Znaper

[M@rkus]

und was kann ich dagegen machen?

So wie ich das verstehe, versucht jemand der wohl dann nicht angemeldet ist, bei der Abstimmung mitzumachen!?

[pogo]

Wie lautet denn diese Zeile in vbindex.php?

LEFT JOIN pollvote AS pollvote ON(thread.pollid = pollvote.pollid AND pollvote.userid = )

[M@rkus]

die lautet so...


LEFT JOIN ".TABLE_PREFIX."pollvote AS pollvote ON(thread.pollid = pollvote.pollid AND pollvote.userid = $bbuserinfo[userid])