Forum Database error in vBulletin 4.0.4
 

<div>I upgraded from 4.0.3 to 4.0.4 and have been getting this error emailed to me. How do i fix this problem?

<div class="bbcode_container"> Code:
Database error in vBulletin 4.0.4:

Invalid SQL:

SELECT
IF(votenum >= 1, votenum, 0) AS votenum,
IF(votenum >= 1 AND votenum > 0, votetotal / votenum, 0) AS voteavg,

thread.threadid, thread.title AS threadtitle, thread.forumid, pollid, open, postusername, postuserid, thread.iconid AS threadiconid,
thread.dateline, notes, thread.visible, sticky, votetotal, thread.attach, thread.lastpost, thread.lastposter, thread.lastposterid, thread.lastpostid, thread.replycount, IF(thread.views