Contentteller

Contentteller Support Forums
Home Forums > Contentteller > Import >

Remove software news from frontpage

Discussion in 'Import' started by error, Jun 16, 2009.

  1. error Customer

    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?
    error, Jun 16, 2009
    #1
  2. Philipp Administrator

    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:

    Code:
    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
    Philipp, Jun 16, 2009
    #2
  3. error Customer

    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?
    error, Jun 16, 2009
    #3
  4. Philipp Administrator

    Open the Latest Software News PHP file in an editor and remove the following from the SQL query:

    Code:
    AND newsstory_frontpage = '1'
    Philipp, Jun 16, 2009
    #4
  5. error Customer

    Works like a charm. Thank you.
    error, Jun 16, 2009
    #5
Tweet
Facebook:
Forgot your password?
Contentteller Support Forums
Home Forums > Contentteller > Import >
  • Home
  • Forums

    Forums

    Quick Links
    • Search Forums
    • What's New?
  • Members

    Members

    Quick Links
    • Registered Members
    • Current Visitors
    • Recent Activity
  • Help

    Help

    Quick Links
    • Smilies
    • BB Codes
    • Trophies

Separate names with a comma.

Advanced search...
    Forum software by XenForo™ ©2011 XenForo Ltd.