New install +Articles problem

Discussion in 'Subrion CMS Packages Discussions' started by CKENT, Sep 2, 2017.

  1. CKENT

    CKENT New Member

    Hey I just installed with articles. I imported over my articles and categories from the older version through SQL. Everything went ok, just had to reupload all of the images, not too bad it was a small site. However when going into publishing package settings, and enabling view subcategories in parents. I get ALL articles in every category. Any idea where I could have gone wrong?
  2. CKENT

    CKENT New Member

    Issue appears to be with this statement

    $where .= $iaCore->get('articles_show_children')
    ? sprintf(" AND t1.`category_id` IN (SELECT `category_id` FROM `%s` WHERE `parent_id` = %d) ",
    $iaArticlecat->getTableFlat(true), $category['id'])
    : " AND t1.`category_id` = ({$category['id']}) ";

Share This Page