mysql 5 and vbadvanced

[tiberium911]

Im using vBulletin 3.5.3, vBadvanced 2.0 and MySQL 5.0 and Im having a little bit of a problem. I have disabled strict mode on MySQL and almost everything now works. The one thing that does not work is the news module. If I enable it I get a huge MySQL error on the main page of my site.

tiberium911

[Brian]

So... What's the error?

[tiberium911]

The error I get is the following:


Database error in vBulletin 3.5.3:

Invalid SQL:

SELECT IF(votenum >= 1, votenum, 0) AS numbvote, IF(votenum >= 1 AND votenum != 0, votetotal / votenum, 0) AS voteavg,
thread.threadid, post.title, thread.replycount, postusername, postuserid, thread.dateline AS postdateline, thread.lastposter, thread.lastpost, IF(views<=thread.replycount, thread.replycount+1, views) AS views, thread.forumid, post.postid, pagetext, allowsmilie, forum.title AS forumtitle

,thread.iconid AS threadiconid, iconpath AS threadiconpath

, NOT ISNULL(subscribethread.subscribethreadid) AS subscribed
FROM thread AS thread
LEFT JOIN forum AS forum USING (forumid)
LEFT JOIN post AS post ON (post.postid = thread.firstpostid)
LEFT JOIN icon USING (iconid)



LEFT JOIN subscribethread AS subscribethread ON (subscribethread.threadid = thread.threadid AND subscribethread.userid = '1')
LEFT JOIN deletionlog AS deletionlog ON (thread.threadid = deletionlog.primaryid AND type = 'thread')
WHERE thread.threadid IN(5,4)

GROUP BY post.postid
ORDER BY thread.dateline DESC
LIMIT 2;

MySQL Error : Column 'iconid' in from clause is ambiguous
Error Number : 1052
Date : Friday, February 10th 2006 @ 06:20:39 PM
Script : http://192.168.0.102/index.php
Referrer : http://192.168.0.102/index.php
IP Address : 192.168.0.102
Username : tiberium911
Classname : vB_Database

[Brian]

If you check the bugs forum for the 2.0.0 version there is a fix in there. Or, if you upgrade to 2.1 then that should take care of the problem as well.

[tiberium911]

thanks