[Mecho]

Originally Posted by JenniferK

did you set up which forums the news will be pulled from and dothose forums actually have threads to pull? If the module is "empty" it won't display at all

no i dont .. where can i add them ??

Originally Posted by JenniferK

did you set up which forums the news will be pulled from and dothose forums actually have threads to pull? If the module is "empty" it won't display at all

tnx for help . i reinstall vbadvanced so i find where i must add froum to news... but when i add froum for news this error shows up :

Database error in vBulletin 3.6.1:

Invalid SQL:

SELECT IF(votenum >= 1, votenum, 0) AS numbvote, IF(votenum >= 1 AND votenum != 0, votetotal / votenum, 0) AS voteavg,
thread.threadid, thread.laspostid, 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

,thread.iconid AS threadiconid, iconpath AS threadiconpath
, avatarpath, NOT ISNULL(filedata) AS hascustom, customavatar.dateline AS avatardateline, avatarrevision
, NOT ISNULL(subscribethread.subscribethreadid) AS subscribed
FROM thread AS thread
LEFT JOIN post AS post ON (post.postid = thread.firstpostid)

LEFT JOIN post_parsed AS post_parsed ON (post_parsed.postid = post.postid AND post_parsed.styleid_code = -1 AND post_parsed.styleid_html = -1 AND post_parsed.styleid_php = 1 AND post_parsed.styleid_quote = 1)

LEFT JOIN icon AS icon ON (icon.iconid = thread.iconid)
LEFT JOIN user AS user ON (user.userid = post.userid)



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

LEFT JOIN subscribethread AS subscribethread ON (subscribethread.threadid = thread.threadid AND subscribethread.userid = '1')
WHERE thread.threadid IN(147)


GROUP BY post.postid
ORDER BY sticky DESC,thread.dateline DESC
LIMIT 10;

MySQL Error : Table 'mechodow_mechodlthebestmanmecho.post_parsed' doesn't exist
Error Number : 1146

:surprised:

Anyone ?