Erro na DataBase ao Postar noticia :/

[dim]

ele funciona normal so que apenas quando nao tem noticia postada :/
ai quando eu posto a noticia e tento abrir o portal
da o sequinte erro;

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
, avatarpath, NOT ISNULL(filedata) AS hascustom, customavatar.dateline AS avatardateline, avatarrevision
, NOT ISNULL(subscribethread.subscri bethreadid) AS subscribed
FROM narutospoilers_thread AS thread
LEFT JOIN narutospoilers_forum AS forum USING (forumid)
LEFT JOIN narutospoilers_post AS post ON (post.postid = thread.firstpostid)
LEFT JOIN narutospoilers_icon USING (iconid)
LEFT JOIN narutospoilers_user AS user ON (user.userid = post.userid)



LEFT JOIN narutospoilers_avatar as avatar ON (avatar.avatarid = user.avatarid)
LEFT JOIN narutospoilers_customavatar as customavatar ON (customavatar.userid = user.userid)

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

GROUP BY post.postid
ORDER BY sticky DESC,thread.dateline DESC
LIMIT 10;
MySQL Error : Column 'iconid' in from clause is ambiguous
Error Number : 1052
Date : Friday, September 15th 2006 @ 05:44:06 PM
Script : http://www.narutospoilers.com/board/portal.php
Referrer :
IP Address : 201.32.176.11
Username : Benzil
Classname : vB_Database

alguem pode me ajudar? :/

[beduino]

Opa,
vc estah usando algum mod ou hack?
de vez em quando vc vai no admincp - admin tools faz um rebuild nas suas tabelas?
abraços
b.

[dim]

finalmente uma resposta para uma duvida minha suahsuah xD
zuera :P
vlw mesmo ;p

[beduino]

Prezado,
fora a 'zueira' - afinal qual era o problema e como vc resolveu?
Abraçao
B.

[dim]

Na verdade foi um golpe de sorte
Fui la nas opções do modulo desativei todas e postei!
feito isso fui lá e ativei todas as opções
Só isso ._.