Adding news pages

[Allen Mead]

I'm having trouble adding information pages in a central column on the home page.

I've read the manual and i guess I'm just being dumb but how do i insert items such as on the vbadvanced home page the bit on vBadvanced Links Directory RC2 Released!

I'm very green where all this html, php and mysql stuff is concerned it's going way over my head at the mo, i'm getting there but I need my hand held to get this baby set up.

So any help would be greatly appreciated.

Have a look at my cmps home page and the forum and let me know what you think.

http://www.astra-mk2.com/forum/cmps_index.php

http://www.astra-mk2.com/forum

Thanks in advance :)

PS. Brian if you read this, I'd just like to say thanks for all the help in getting the stuff onto my site :cool:

[DarknessDivine]

In your CMPS control panel you need to activate News and pick a forum you want for news and put that forumid for the news. I believe that is what you are wanting..

[Our Sponsors]

[Polo]

I'm getting this:

There seems to have been a slight problem with the database.
Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.

[Allen Mead]

Hi Polo, I am too. I think we've nailed it down to the website hosting, it appears the eeeeeediots have changed the admin software and not ensured all the database links work as the database is on a separate server.

I've checked all the files and stuff and they are still all there. Some asre kikking will be done in the morning!!!!!!

[Our Sponsors]

[Allen Mead]

In your CMPS control panel you need to activate News and pick a forum you want for news and put that forumid for the news. I believe that is what you are wanting..

Yup that's it! I thought it'd be something simple like that doh!

[DarknessDivine]

;)

[Polo]

i'm still getting the same error, hope everything is fixed soon :)

[Brian]

I'd need to see the entire error to tell you what's wrong (it should be sent via email, or you can view the page source to see what the error is).

[Polo]

when i get an error at my website, i get a box after that message... why isnt he's showing? is there a way to turn that notice of or what?

[Brian]

It only shows to admins when logged in. If you're not logged in, then you can view the page source to see the contents of that box.

[Polo]

oh ok, that is good to know, i didnt know that until now

[gemfsb]

I have same problem, heeeeeeeeeeeeeeeeelp

[Polo]

I have same problem, heeeeeeeeeeeeeeeeelp

What problem?

[gemfsb]

this one:
There seems to have been a slight problem with the database.
Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.

"

have I missed something?

[Polo]

oh, i see... well there is definetly something wrong with you database..... was your vbulletin working before?

[gemfsb]

yes sure, just get this error when add forum for the news bar in the admincp? what have you done to get red of it?

thank you

[Brian]

I'd need to see the entire error to tell you what's wrong (it should be sent via email, or you can view the page source to see what the error is).

[gemfsb]

ok here it is:

"
Database error in vBulletin 3.0.3:

Invalid SQL:
SELECT IF(votenum >= 1, votenum, 0) AS votenum, IF(votenum >= 1 AND votenum != 0, votetotal / votenum, 0) AS voteavg,
thread.threadid, thread.title, replycount, postusername, postuserid, thread.dateline AS postdateline, thread.lastposter, thread.lastpost, IF(views<=replycount, replycount+1, views) AS views, forumid, post.postid, pagetext, allowsmilie
, showsignature, usertextfield.signature
,thread.iconid AS threadiconid, iconpath AS threadiconpath
, avatarpath, NOT ISNULL(avatardata) AS hascustom, customavatar.dateline AS avatardateline, avatarrevision

, attachment.filename, attachment.filesize, attachment.visible, attachmentid, counter, thumbnail, LENGTH(thumbnail) AS thumbnailsize
FROM vb3_thread AS thread
LEFT JOIN vb3_post AS post ON (post.postid = thread.firstpostid)
LEFT JOIN vb3_icon USING (iconid)
LEFT JOIN vb3_attachment AS attachment ON (post.postid = attachment.postid)
LEFT JOIN vb3_user AS user ON (user.userid = post.userid)

LEFT JOIN vb3_usertextfield AS usertextfield ON (post.userid = usertextfield.userid)

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


LEFT JOIN vb3_deletionlog AS deletionlog ON (thread.threadid = deletionlog.primaryid AND type = 'thread')
WHERE forumid IN(,5,3,8,4) AND thread.visible = 1 AND thread.open != 10 AND deletionlog.primaryid IS NULL
GROUP BY post.postid
ORDER BY postdateline DESC
LIMIT 6
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '5,3,8,4) AND thread.visible = 1 AND thread.open != 10 AND delet

mysql error number: 1064
"

[gemfsb]

it solved:)

thank you Polo and Braian :)

[Polo]

do you mind sharing your solution?

[Brian]

It looks like he may have had his News Forum ID option set incorrectly with an unnecessary comma at the beginning.

[gemfsb]

actually its a silly one :o , see here (,5,3,8,4) there is an extra comma. thats it :)

[gemfsb]

yes Brian, thats right.

[Allen Mead]

started something off here, am still having problems with the web hosts, same problem, they are as useful as a chocolate kettle, it was all fine last friday as you can see when DarknessDivne looked, all ok, then when Polo looked it was all messed up and the web hosts changed the site admin software!!

I've also spotted this while having a look around

http://www.astra-mk2.com/allenmead/local.jpg

This don't seem right?

[mholtum]

There seems to have been a slight problem with the database.
Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.

[Allen Mead]

Brian is a god!!!!

When our hosts changed the admin software, somewhere along the line, a hyphon got changed to an underscore and that was the problem!!!

So guys have another look!!!

One thing I can't work out, is how to get the announcement up in my general chat page as the first news item. I can get the posts in the general forum to show but...

Any help greatly appreciated!

[Allen Mead]

bounce

[Polo]

oh wow... seems like a serious problem... wait for brians answer... but it seems that you will need to change the settings in your config.php file...