This website can use cookies to improve the user experience

This website can use cookies to improve the user experience and to provide certain services and functions to users. Cookies contain small amounts of information (such as login information and user preferences) and will be stored on your device.

Enable All Cookies Privacy Policy

Remove software news from frontpage


avatar
error 232
From: -
Remove software news from frontpage

Upon importing news from old cms a lot of software news was imported on frontpage news.

frontpage channel ID: 1
software channel ID: 2

how to remove software news from frontpage through sql database?

Notice

This topic is archived. New comments cannot be posted and votes cannot be cast.

Responses to this topic


1 Re: Remove software news from frontpage
avatar
OP 232
From: -
Works like a charm. Thank you.
1 Re: Remove software news from frontpage
avatar
Editor
0
From: -
Open the Latest Software News PHP file in an editor and remove the following from the SQL query:

AND newsstory_frontpage = '1'
1 Re: Remove software news from frontpage
avatar
OP 232
From: -
It works. Thanks. Now I get: "The news database is currently empty" in the Latest Software News block. Do I need to wait on database to populate?
1 Re: Remove software news from frontpage
avatar
Editor
0
From: -
1) You need to find out the channel key of your software category. You find it in the newschannel_key column of the esselbach_ct_newschannels table.

2) Then run the following SQL query in phpMyAdmin:

UPDATE esselbach_ct_newsstories SET newsstory_frontpage = '0' WHERE newsstory_channels = '1a1a1a1a';


You need to replace 1a1a1a1a with the channel key of your software category

Notice

This topic is archived. New comments cannot be posted and votes cannot be cast.