Contentteller

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
Facebook: