By cmcguinness on

Hi, I've been drafted in to help on a charity website : http://www.theclubhouse.ie/theclubhouse/ - it looks like the index is a 'story' content and I need it to be 'page' as I just have static information, with the blog post appearing as Latest News in the right sidebar. Is it possible to change this at all as I don't want any of the blog posts on the homepage, or the RSS symbol for that matter?

Thanks

P.S. I didn't start this job for the orginisation so I don't know how it was configured to begin.

⋅ Categories: Drupal 6.x

Comments

j.somers’s picture

j.somers commented

Normally, when you change the type of the node most of it should work. Make a database backup to be sure.

Using PHPMyAdmin or a command line MySQL interface you can try something like:

UPDATE node SET type = 'page' WHERE nid = '<nid of the story>';
cmcguinness’s picture

cmcguinness commented

Thanks for your reply.... unfortunately I'm not familiar with using the My SQL interface, could I be so cheeky as to ask for a step by step guide?

j.somers’s picture

j.somers commented

Well, I am going to have to make 1 assumption: your provider allows you to use PHPMyAdmin and has provided you login information for it.

When you are logged in to PHPMyAdmin you will a list of available databases on the left. Click on the database you use for your Drupal installation or, if you have only 1 database it could be this has been selected automatically. Next, it should show you a list of available tables within that database. One of it should be the table called 'node'. Prefixed with the prefix you might have selected when installing Drupal. Click on it and the right side of the screen should change. At the top of it should be different tabs: 'Browse', 'Structure', 'SQL', ... Select the SQL tab which should give you some kind of text area input field which, most likely, already contains the following:

SELECT * FROM `node` WHERE 1

Remove that line, paste the MySQL command I provided in my first reply and click the 'Go' button on the right lower side of the screen to execute the query.

cmcguinness’s picture

cmcguinness commented

I tried that, and thank you for taking the time to instruct me. Unfortunately however I still have the blog on the homepage - http://www.theclubhouse.ie/theclubhouse/

Is there a file I could just delete the this blog being generated on the homepage?

Thanks for your patience

cmcguinness’s picture

cmcguinness commented

I'm just thinking I've mixed up what I want done.... possibly it's going from a 'story' to a 'page' rather than the other way around.

Basically I need to get rid of the 'Test' and 'Get Involved?' post on the homepage I gave you the URL to?

I'm so lost on this one! Sorry

gbrussel’s picture

gbrussel commented

Nodetype might be the module you're looking for.

cmcguinness’s picture

cmcguinness commented

I found a different method but thanks for taking the time to help.

C

wobby’s picture

wobby commented

If the frontpage is ok and has the right info etc I would just leave it as it is whether its a page or a story and just disable the blogs from appearing on the frontpage, then enable the recent blog block so that the news posts eappear somewhere else, on the left or the right etc
To disable blogs on the frontpage read below .......
Another way is to choose your publishing options when you post a blog and uncheck the promote to frontpage, that way your blog will post but not appear on the frontpage :)

I have pretty much the same as you and this is what I done .....

I created a story, put in my images, text and links etc, saved it and at the bottom for the options I have
Comment Settings - Disabled
Publishing Options - selected the Published, Promoted to Front Page and Sticky at top of lists

This now has my frontpage or homepage sorted, no comments can be posted and it is always my frontpage :)

If you dont want your blogs appearing on the main page you can disable the default behaviour for this by going to
Admin - Content Types
The page will list all the content types and on mine it has Blog Entry at the top of the page
Underneath the Operations header there is an "edit" link
Click that to edit the blog entry
Scroll down and click workflow settings
Untick the box next to "promoted to frontpage"

This should now mean all blogs wont appear on the frontpage but will still be listed in the recent blogs block on your website

Put recent blog posts on the website by going to Admin - Blocks
Enable the Block - Recent Blog Posts and choose the area you want it to appear.
The theme I am using only lets me choose left or bottom footer, not sure about yours, depending on the theme you may have a choice of right and footer

You may still also need to edit the original page if you need to delete it in place of the new one that you have created :)

sounds like a nice idea BTW we used to have something similar here in Scotland with graphic design and music recording, the kids loved it but trying to get home office funding was a nightmare :(

I hope my post helps although Im not sure if this is the answer you are looking for, possibly a bit easier then editing database stuff or installing node modules etc

ô¿ô

cmcguinness’s picture

cmcguinness commented

Thanks for taking all that time to answer, I'm back in business!

Cheers from Ireland.

wobby’s picture

wobby commented

ô¿ô

I also sent you a message through the contact from on this Drupal site as I forgot to add stuff about the links and the RSS feeds :)

aw the best