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, 10Notice 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.