another upgrade problem

[tzivoshashem]

Ok now I have another problem:
Whats this all about?

======================================================

Database error in vBulletin 3.7.2:

Invalid SQL:

SELECT IF(votenum >= 1, votenum, 0) AS votenum, IF(votenum >= 1 AND votenum != 0, votetotal / votenum, 0) AS voteavg, votetotal, user.*, thread.threadid, post.title, thread.replycount, postusername, postuserid, thread.dateline AS postdateline, sticky, thread.attach, thread.lastpostid, thread.lastposter, thread.lastpost, IF(views<=thread.replycount, thread.replycount+1, views) AS views, thread.forumid, post.postid, pagetext
, allowsmilie, pagetext_html, postparsed.hasimages, NOT ISNULL(subscribethread.subscribethreadid) AS subscribed
FROM jelsoft_thread AS thread
LEFT JOIN jelsoft_post AS post ON (post.postid = thread.firstpostid)
LEFT JOIN jelsoft_user AS user ON (user.userid = post.userid)
LEFT JOIN jelsoft_postparsed AS postparsed ON (postparsed.postid = post.postid AND postparsed.styleid = 7 AND postparsed.languageid = 1) LEFT JOIN jelsoft_subscribethread AS subscribethread ON (subscribethread.threadid = thread.threadid AND subscribethread.userid = '1')
WHERE thread.threadid IN(2695,2693,2692,2690,2689,2688,2687,2686,2660,2659,2658,2657,2656,2652,2651,26 46)



ORDER BY sticky DESC, thread.dateline DESC
LIMIT 16;

MySQL Error : Column 'votenum' in field list is ambiguous
Error Number : 1052
Request Date : Monday, July 21st 2008 @ 05:22:56 AM
Error Date : Monday, July 21st 2008 @ 05:22:57 AM
Script : http://www.thecooljew.com/index.php
Referrer :
IP Address : 74.255.216.100
Username : Webmaster
Classname : vb_database
MySQL Version : 4.1.14

[tzivoshashem]

I REALLY NEED TO GET THIS FIXED ANYBODY KNOW WHAT THIS MEANS:


Database error in vBulletin 3.7.2:

Invalid SQL:

SELECT IF(votenum >= 1, votenum, 0) AS votenum, IF(votenum >= 1 AND votenum != 0, votetotal / votenum, 0) AS voteavg, votetotal, user.*, thread.threadid, post.title, thread.replycount, postusername, postuserid, thread.dateline AS postdateline, sticky, thread.attach, thread.lastpostid, thread.lastposter, thread.lastpost, IF(views<=thread.replycount, thread.replycount+1, views) AS views, thread.forumid, post.postid, pagetext
, allowsmilie, pagetext_html, postparsed.hasimages, NOT ISNULL(subscribethread.subscribethreadid) AS subscribed
FROM jelsoft_thread AS thread
LEFT JOIN jelsoft_post AS post ON (post.postid = thread.firstpostid)
LEFT JOIN jelsoft_user AS user ON (user.userid = post.userid)
LEFT JOIN jelsoft_postparsed AS postparsed ON (postparsed.postid = post.postid AND postparsed.styleid = 7 AND postparsed.languageid = 1) LEFT JOIN jelsoft_subscribethread AS subscribethread ON (subscribethread.threadid = thread.threadid AND subscribethread.userid = '1')
WHERE thread.threadid IN(2695,2693,2692,2690,2689,2688,2687,2686,2660,2659,2658,2657,2656,2652,2651,26 46)



ORDER BY sticky DESC, thread.dateline DESC
LIMIT 16;

MySQL Error : Column 'votenum' in field list is ambiguous
Error Number : 1052
Request Date : Monday, July 21st 2008 @ 03:32:51 PM
Error Date : Monday, July 21st 2008 @ 03:32:51 PM
Script : http://thecooljew.com/cmps_index.php
Referrer :
IP Address : 74.161.236.89
Username : Webmaster
Classname : vb_database
MySQL Version : 4.1.14

[Our Sponsors]

[Brian]

Do you have any other hacks/plugins installed? Sounds like you may have something that's added a field called 'votenum' on one of those tables.