ExpressionEngine CMS
Open, Free, Amazing

Thread

This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.

The active forums are here.

Content Display Issues (since 2.1.1 upgrade)

October 20, 2010 1:40am

Subscribe [4]
  • #1 / Oct 20, 2010 1:40am

    KenKodz

    25 posts

    After I updated to 2.1.1 I began have issues displaying entries using the below code: 

    {exp:channel:entries channel="{segment_1}" category="34" orderby="date" limit="10" status="NOT closed" }
        <div class="bottom_left_col">
            <h3 class="underline"><a href="http://{site_url}{segment_1}/{segment_2}/{url_title}">{title}</a></h3>
            {exp:word_limit total="100"}{first_desc}{/exp:word_limit}
     <a href="http://{site_url}{segment_1}/{segment_2}/{url_title}class=more">read more</a>
        </div>
    {/exp:channel:entries}

    When I turned on debugging I see the following query is running:

    SELECT DISTINCT(t.entry_id) FROM exp_channel_titles AS t
                    LEFT JOIN exp_channels ON t.channel_id = exp_channels.channel_id LEFT JOIN exp_members AS m ON m.member_id = t.author_id INNER JOIN exp_category_posts ON t.entry_id = exp_category_posts.entry_id
                             INNER JOIN exp_categories ON exp_category_posts.cat_id = exp_categories.cat_id WHERE t.entry_id !='' AND t.site_id IN ('1')  AND t.entry_date < 1287548463  AND (t.expiration_date = 0 OR t.expiration_date > 1287548463) AND t.channel_id = '6' AND t.url_title = 'health' AND exp_categories.cat_id = '34' AND t.status != 'closed'ORDER BY t.sticky desc, t.entry_date desc, t.entry_id desc LIMIT 0, 10

    Notice the

    AND t.url_title = 'health'

    in the query.

    Why in the world is EE2 specifying the url_title? “health” is the channel and a category not an entry.

    Because of this I can’t show a list of entries.

    Please Help.

  • #2 / Oct 20, 2010 9:52am

    Sue Crocker

    26054 posts

    Are you running this on a page that has a url_title?

  • #3 / Oct 20, 2010 10:48am

    KenKodz

    25 posts

    No. It’s just used to provide a listing of articles with a preview.

    I have found the problem. With 2.1.0 dynamic=“no” was the default (or at least it worked that way) and now with 2.1.1 I have to specifically set it to dynamic=“no”.

    But I am still needing to get those darn forums fixed.

    Thanks again Sue! I really do appreciate your help.

  • #4 / Oct 20, 2010 4:01pm

    Ingmar

    29245 posts

    dynamic=“no” was never the default, but I am glad you got it to work. Post again as needed, please.

.(JavaScript must be enabled to view this email address)

ExpressionEngine News!

#eecms, #events, #releases