PDA

View Full Version : where is News !!!!!


Mecho
14 Sep 2006, 23:07
hi .. i installed vbadvanced . but news module and archive news module is not availabe !! i mean i cant see them in page:confused:

i realy appricate if some on help me about it ..

and on thing else .. is that possible that i can add to recent therads pics of topic and alittle of their text ???

tnx

JenniferK
14 Sep 2006, 23:14
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

Mecho
14 Sep 2006, 23:16
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 ??

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 ? :(

JenniferK
15 Sep 2006, 18:40
I'll help as best I can, but I'm somewhat new to all this myself ;)

I have no idea what the error you are getting is, I'm sorry.

The way to set up the News module is in Admin Cp go to VbA CMPS -> Edit Modules -> News (or whatever you have named your news module) -> scroll down to News Options

In that section, make sure to select the forum(s) you want the module to pull from. Check all the other options there too. Then you need to make sure the forum has the news to actually pull. Are you using an RSS feed? If so, you will need to set that up to feed into that forum. Check the feed - make sure it is working properly. Is it displaying correctly in the forum itself? If you have done all this and re-checked to make sure it is done right, then I am not sure what the problem is.

KW802
15 Sep 2006, 18:54
For vB 3.6.x you'll need to download CMPS 2.2.0 from vBadvanced.com.

Mecho
20 Sep 2006, 11:58
tnx for replies .. that error was caz of my host!! they repair it and now it works :)

tnx again