Remove software news from frontpage
error 232
From: -
From: -
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
error
OP
232
From: -
From: -
Works like a charm. Thank you.
1 Re: Remove software news from frontpage
Philipp Esselbach
From: -
Editor
0From: -
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
error
OP
232
From: -
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
Philipp Esselbach
From: -
Editor
0From: -
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:
You need to replace 1a1a1a1a with the channel key of your software category
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
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?