Go to main content

Textpattern CMS support forum

You are not logged in. Register | Login | Help

#1 2012-03-15 11:32:10

decoderltd
Member
From: London
Registered: 2006-06-20
Posts: 248
Website

txp:article_custom limit problems

Hi,

I’m sure this must has come up before, but I can’t find anything in the forum.

I have some code below which outputs a list of article titles, but I’m having problems getting the limit to play ball. I understand that it defaults to 10 but I want to increase it to 20 articles. No matter what I do I can’t get it to do that. If I make the limit less than 10 that works fine, but no setting (not even the famed ‘999’) will budge it past 10 articles. Can anyone help?

<txp:category_list break="">
         <txp:variable name="has_articles" value='<txp:article_custom section=''<txp:section />'' category=''<txp:category />'' limit="1" />' />
         <txp:if_variable name="has_articles" value="">
         <txp:else />
         <div class="module">
         <h4><txp:category title="1" /></h4>
         <txp:article_custom limit="999" section='<txp:section />' category='<txp:category />' wraptag="ul" class="listing" break="li" >
         <txp:permlink><txp:title /></txp:permlink>
         </txp:article_custom>
         </div><!-- end module -->
         </txp:if_variable>
</txp:category_list>

Offline

#2 2012-03-15 11:55:45

uli
Moderator
From: Cologne
Registered: 2006-08-15
Posts: 4,315

Re: txp:article_custom limit problems

What happens when you remove any of these two limitations section='<txp:section />' category='<txp:category />' from the article tag?


In bad weather I never leave home without wet_plugout, smd_where_used and adi_form_links

Offline

#3 2012-03-15 14:26:03

decoderltd
Member
From: London
Registered: 2006-06-20
Posts: 248
Website

Re: txp:article_custom limit problems

Hi Uli,

Many thanks for your reply.

Your hunch was right, removing category=''<txp:category />'' solved the problem. The output doesn’t appear to be affected by not having it there or do you think I need add some extra code to balance things out?

Offline

#4 2012-03-15 15:48:13

uli
Moderator
From: Cologne
Registered: 2006-08-15
Posts: 4,315

Re: txp:article_custom limit problems

Glad it was that easy. Now it …

do you think I need add some extra code to balance things out?

… needs some testing ;)


In bad weather I never leave home without wet_plugout, smd_where_used and adi_form_links

Offline

#5 2012-03-15 16:34:35

decoderltd
Member
From: London
Registered: 2006-06-20
Posts: 248
Website

Re: txp:article_custom limit problems

Thanks Uli.

I’ll have a play around with it. It looks like category='<txp:category />' needs to be there otherwise it doesn’t split the output into its various categories. But at least I know where the problem is being generated.

Offline

#6 2012-03-15 20:39:31

els
Moderator
From: The Netherlands
Registered: 2004-06-06
Posts: 7,458

Re: txp:article_custom limit problems

Did you locate the problem? If not, looking at the tag trace could provide an insight. You can post it here if you want.

And I assume I don’t have to ask if you checked that there really are more than 10 live articles in those categories… ;)

Offline

#7 2012-03-16 14:43:33

decoderltd
Member
From: London
Registered: 2006-06-20
Posts: 248
Website

Re: txp:article_custom limit problems

Hi Els,

It’s a fair question but on this occasion there are more than 10 articles.

Thanks for your offer of help. I still haven’t located the reason for the problem but here’s the tag trace, any advice appreciated:

<!-- Runtime:    0.0473 -->
<!-- Query time: 0.016159 -->
<!-- Queries: 53 -->
<!-- Memory: 5243Kb, <txp:title /> -->
<!-- txp tag trace: 
[SQL (0.0011088848114): select name, data from txp_lang where lang='en-gb' AND ( event='public' OR event='common')]
[SQL (0.000560998916626): select name, code, version from txp_plugin where status = 1 AND type IN (0,1) order by load_order]
[SQL (0.000178813934326): select name,code,version from txp_plugin where status = 1 AND name='smd_lib']
[SQL (0.000282049179077): select name from txp_section where `name` like 'garden-projects' limit 1]
[SQL (0.000125885009766): select page, css from txp_section where name = 'garden-projects' limit 1]
[SQL (0.000223159790039): select user_html from txp_page where name='garden-projects']
[Page: garden-projects]
<txp:output_form form="meta" />
	[SQL (0.000169038772583): select Form from txp_form where name='meta']
	[Form: meta]
	<txp:if_section name="">
		[<txp:if_section name="">: false]
		<txp:if_individual_article>
			[<txp:if_individual_article>: false]
			<txp:article status="sticky" form="meta_dynamic" />
				[SQL (0.000401973724365): select *, unix_timestamp(Posted) as uPosted, unix_timestamp(Expires) as uExpires, unix_timestamp(LastMod) as uLastMod from textpattern where 1=1 and Status = 5 and Posted <= now() and (now() <= Expires or Expires = '0000-00-00 00:00:00') and Section IN ('garden-projects') order by Posted desc limit 0, 10]
				[article 11]
				[SQL (0.000128030776978): select Form from txp_form where name='meta_dynamic']
				[Form: meta_dynamic]
				<txp:if_article_list>
					[<txp:if_article_list>: true]
					<txp:if_category>
						[<txp:if_category>: false]
						<txp:if_section name="default">
							[<txp:if_section name="default">: false]
							<txp:section title="1" />
								[SQL (0.000117063522339): select title from txp_section where name='garden-projects']
						</txp:if_section>
						<txp:site_name />
					</txp:if_category>
				</txp:if_article_list>
				<txp:if_individual_article>
					[<txp:if_individual_article>: false]
				</txp:if_individual_article>
				<txp:custom_field name="meta_desc" />
				<txp:keywords />
		</txp:if_individual_article>
	</txp:if_section>
	<txp:output_form form="meta_static" />
		[SQL (0.000126123428345): select Form from txp_form where name='meta_static']
		[Form: meta_static]
		<txp:css name="reset" />
		<txp:css name="960" />
		<txp:css name="base" />
		<txp:css name="print" />
		<txp:feed_link flavor="atom" format="link" label="Atom" />
		<txp:feed_link flavor="rss" format="link" label="RSS" />
		<txp:rsd />
	<txp:output_form form="javascript_cycle" />
		[SQL (0.000121116638184): select Form from txp_form where name='javascript_cycle']
		[Form: javascript_cycle]
	<txp:output_form form="javascript_column" />
		[SQL (0.000110864639282): select Form from txp_form where name='javascript_column']
		[Form: javascript_column]
	<txp:if_section name="garden-projects">
		[<txp:if_section name="garden-projects">: true]
	</txp:if_section>
	<txp:if_section name=",profile">
		[<txp:if_section name=",profile">: false]
	</txp:if_section>
<txp:output_form form="header+nav" />
	[SQL (0.000113964080811): select Form from txp_form where name='header+nav']
	[Form: header+nav]
	<txp:output_form form="header" />
		[SQL (0.000113964080811): select Form from txp_form where name='header']
		[Form: header]
		<txp:image class="decoration" id="8" />
			[SQL (0.00021505355835): select * from txp_image where id = 8 limit 1]
	<txp:output_form form="nav" />
		[SQL (0.000123977661133): select Form from txp_form where name='nav']
		[Form: nav]
		<txp:section_list sections="profile,garden-projects,services,resources,news,garden-notebook,contact" wraptag="ul" break="li" include_default="1" default_title="Home" active_class="active"  />
			[SQL (0.000211000442505): select name, title from txp_section where name in ('profile','garden-projects','services','resources','news','garden-notebook','contact') order by field(name, 'profile','garden-projects','services','resources','news','garden-notebook','contact')]
		<txp:feed_link wraptag="div">
		</txp:feed_link>
		<txp:output_form form="searchBox" />
			[SQL (0.000110149383545): select Form from txp_form where name='searchBox']
			[Form: searchBox]
			<txp:search_input button="" label="" section="search" size="15" wraptag="" />
				[SQL (9.79900360107E-5): select form from txp_form where `name` = 'search_input' limit 1]
<txp:if_individual_article>
	[<txp:if_individual_article>: false]
</txp:if_individual_article>
<txp:if_article_list>
	[<txp:if_article_list>: true]
	<txp:article_custom allowoverride="0" form="gbd_articleProject" limit="1" pgonly="0" section="garden-projects" sort="rand()" status="4" />
		[SQL (0.00160789489746): select *, unix_timestamp(Posted) as uPosted, unix_timestamp(Expires) as uExpires, unix_timestamp(LastMod) as uLastMod from textpattern where 1=1 and Status = 4 and Posted <= now() and (now() <= Expires or Expires = '0000-00-00 00:00:00') and Section IN ('garden-projects') order by rand() limit 0, 1]
		[article 27]
		[SQL (0.000129222869873): select Form from txp_form where name='gbd_articleProject']
		[Form: gbd_articleProject]
		<txp:output_form form="gbd_featurePanel" />
			[SQL (0.000110149383545): select Form from txp_form where name='gbd_featurePanel']
			[Form: gbd_featurePanel]
			<txp:smd_if field="article_image" operator="isused">
				[<txp:smd_if field="article_image" operator="isused">: false]
				<txp:if_article_category name="testimonials" >
					[<txp:if_article_category name="testimonials" >: true]
					<txp:image id="86" />
						[SQL (0.000140905380249): select * from txp_image where id = 86 limit 1]
				</txp:if_article_category>
				<txp:if_section name="services">
					[<txp:if_section name="services">: false]
				</txp:if_section>
				<txp:if_section name="resources">
					[<txp:if_section name="resources">: false]
				</txp:if_section>
				<txp:if_section name="news">
					[<txp:if_section name="news">: false]
				</txp:if_section>
				<txp:if_section name="garden-notebook">
					[<txp:if_section name="garden-notebook">: false]
				</txp:if_section>
				<txp:if_section name="contact">
					[<txp:if_section name="contact">: false]
				</txp:if_section>
				<txp:if_section name="sitemap">
					[<txp:if_section name="sitemap">: false]
				</txp:if_section>
			</txp:smd_if>
		<txp:if_section name="garden-notebook,news">
			[<txp:if_section name="garden-notebook,news">: false]
			<txp:title />
			<txp:body />
			<txp:output_form form="gbd_beforeAfter" />
				[SQL (0.000118970870972): select Form from txp_form where name='gbd_beforeAfter']
				[Form: gbd_beforeAfter]
				<txp:smd_if field="before_after" operator="isused">
					[<txp:smd_if field="before_after" operator="isused">: false]
				</txp:smd_if>
			<txp:output_form form="article_base" />
				[SQL (0.000128984451294): select Form from txp_form where name='article_base']
				[Form: article_base]
				<txp:output_form form="gbd_sendArticle" />
					[SQL (0.000111103057861): select Form from txp_form where name='gbd_sendArticle']
					[Form: gbd_sendArticle]
					<txp:permlink />
					<txp:zem_contact label="Send article link to a friend" send_article="1">
						[SQL (0.000237226486206): insert into txp_discuss_nonce set issue_time = now(), nonce = '7de3c302f857b9adeb3bf1fad332eff0']
						<txp:zem_contact_email label="Recipient Email" send_article="1" />
						<txp:zem_contact_email label="Your Email" />
						<txp:zem_contact_submit label="Send Article" />
					</txp:zem_contact>
		</txp:if_section>
		<txp:variable name="has_articles" value='<txp:article_custom section=''<txp:section />'' category=''<txp:category />'' limit="1" />' />
			[attribute 'value']
			<txp:article_custom section='<txp:section />' category='<txp:category />' limit="1" />
				[attribute 'section']
				<txp:section />
				[/attribute]
				[attribute 'category']
				<txp:category />
				[/attribute]
				[SQL (0.000339984893799): select *, unix_timestamp(Posted) as uPosted, unix_timestamp(Expires) as uExpires, unix_timestamp(LastMod) as uLastMod from textpattern where 1=1 and Status = 4 and Posted <= now() and (now() <= Expires or Expires = '0000-00-00 00:00:00') and Section IN ('garden-projects') order by Posted desc limit 0, 1]
				[article 59]
				[SQL (0.000123977661133): select Form from txp_form where name='default']
				[Form: default]
				<txp:if_individual_article>
					[<txp:if_individual_article>: false]
					<txp:permlink>
						<txp:title />
					</txp:permlink>
				</txp:if_individual_article>
				<txp:posted />
				<txp:body />
				<txp:author />
					[SQL (0.000128984451294): select RealName from txp_users where `name` = 'alison' limit 1]
				<txp:category1 title="1" link="1" />
					[SQL (0.000180006027222): select title from txp_category where name='testimonials' and type='article']
				<txp:category2 title="1" link="1" />
				<txp:comments_invite wraptag="p" />
				<txp:site_url />
			[/attribute]
		<txp:if_variable name="has_articles" value="">
			[<txp:if_variable name="has_articles" value="">: false]
			<txp:article_custom section='<txp:section />' category='<txp:category />' wraptag="div" break="" class="intro" status="5" >
				[attribute 'section']
				<txp:section />
				[/attribute]
				[attribute 'category']
				<txp:category />
				[/attribute]
				[SQL (0.000336170196533): select *, unix_timestamp(Posted) as uPosted, unix_timestamp(Expires) as uExpires, unix_timestamp(LastMod) as uLastMod from textpattern where 1=1 and Status = 5 and Posted <= now() and (now() <= Expires or Expires = '0000-00-00 00:00:00') and Section IN ('garden-projects') order by Posted desc limit 0, 10]
				[article 11]
				<txp:body />
			</txp:article_custom>
		</txp:if_variable>
		<txp:category_list break="">
			[SQL (0.000169992446899): select name, title from txp_category where type = 'article' and name not in('default','root')   order by name ASC]
			<txp:variable name="has_articles" value='<txp:article_custom section=''<txp:section />'' category=''<txp:category />'' limit="1" />' />
				[attribute 'value']
				<txp:article_custom section='<txp:section />' category='<txp:category />' limit="1" />
					[attribute 'section']
					<txp:section />
					[/attribute]
					[attribute 'category']
					<txp:category />
					[/attribute]
					[SQL (0.000643014907837): select *, unix_timestamp(Posted) as uPosted, unix_timestamp(Expires) as uExpires, unix_timestamp(LastMod) as uLastMod from textpattern where 1=1 and Status = 4 and Posted <= now() and (now() <= Expires or Expires = '0000-00-00 00:00:00') and (Category1 IN ('articles') or Category2 IN ('articles')) and Section IN ('garden-projects') order by Posted desc limit 0, 1]
				[/attribute]
			<txp:if_variable name="has_articles" value="">
				[<txp:if_variable name="has_articles" value="">: true]
			</txp:if_variable>
			<txp:variable name="has_articles" value='<txp:article_custom section=''<txp:section />'' category=''<txp:category />'' limit="1" />' />
				[attribute 'value']
				<txp:article_custom section='<txp:section />' category='<txp:category />' limit="1" />
					[attribute 'section']
					<txp:section />
					[/attribute]
					[attribute 'category']
					<txp:category />
					[/attribute]
					[SQL (0.000643968582153): select *, unix_timestamp(Posted) as uPosted, unix_timestamp(Expires) as uExpires, unix_timestamp(LastMod) as uLastMod from textpattern where 1=1 and Status = 4 and Posted <= now() and (now() <= Expires or Expires = '0000-00-00 00:00:00') and (Category1 IN ('biography') or Category2 IN ('biography')) and Section IN ('garden-projects') order by Posted desc limit 0, 1]
				[/attribute]
			<txp:if_variable name="has_articles" value="">
				[<txp:if_variable name="has_articles" value="">: true]
			</txp:if_variable>
			<txp:variable name="has_articles" value='<txp:article_custom section=''<txp:section />'' category=''<txp:category />'' limit="1" />' />
				[attribute 'value']
				<txp:article_custom section='<txp:section />' category='<txp:category />' limit="1" />
					[attribute 'section']
					<txp:section />
					[/attribute]
					[attribute 'category']
					<txp:category />
					[/attribute]
					[SQL (0.000647068023682): select *, unix_timestamp(Posted) as uPosted, unix_timestamp(Expires) as uExpires, unix_timestamp(LastMod) as uLastMod from textpattern where 1=1 and Status = 4 and Posted <= now() and (now() <= Expires or Expires = '0000-00-00 00:00:00') and (Category1 IN ('intro') or Category2 IN ('intro')) and Section IN ('garden-projects') order by Posted desc limit 0, 1]
				[/attribute]
			<txp:if_variable name="has_articles" value="">
				[<txp:if_variable name="has_articles" value="">: true]
			</txp:if_variable>
			<txp:variable name="has_articles" value='<txp:article_custom section=''<txp:section />'' category=''<txp:category />'' limit="1" />' />
				[attribute 'value']
				<txp:article_custom section='<txp:section />' category='<txp:category />' limit="1" />
					[attribute 'section']
					<txp:section />
					[/attribute]
					[attribute 'category']
					<txp:category />
					[/attribute]
					[SQL (0.000633955001831): select *, unix_timestamp(Posted) as uPosted, unix_timestamp(Expires) as uExpires, unix_timestamp(LastMod) as uLastMod from textpattern where 1=1 and Status = 4 and Posted <= now() and (now() <= Expires or Expires = '0000-00-00 00:00:00') and (Category1 IN ('latest-news') or Category2 IN ('latest-news')) and Section IN ('garden-projects') order by Posted desc limit 0, 1]
				[/attribute]
			<txp:if_variable name="has_articles" value="">
				[<txp:if_variable name="has_articles" value="">: true]
			</txp:if_variable>
			<txp:variable name="has_articles" value='<txp:article_custom section=''<txp:section />'' category=''<txp:category />'' limit="1" />' />
				[attribute 'value']
				<txp:article_custom section='<txp:section />' category='<txp:category />' limit="1" />
					[attribute 'section']
					<txp:section />
					[/attribute]
					[attribute 'category']
					<txp:category />
					[/attribute]
					[SQL (0.000365972518921): select *, unix_timestamp(Posted) as uPosted, unix_timestamp(Expires) as uExpires, unix_timestamp(LastMod) as uLastMod from textpattern where 1=1 and Status = 4 and Posted <= now() and (now() <= Expires or Expires = '0000-00-00 00:00:00') and (Category1 IN ('projects') or Category2 IN ('projects')) and Section IN ('garden-projects') order by Posted desc limit 0, 1]
					[article 57]
					[Form: default]
					<txp:if_individual_article>
						[<txp:if_individual_article>: false]
						<txp:permlink>
							<txp:title />
						</txp:permlink>
					</txp:if_individual_article>
					<txp:posted />
					<txp:body />
					<txp:author />
					<txp:category1 title="1" link="1" />
					<txp:category2 title="1" link="1" />
					<txp:comments_invite wraptag="p" />
					<txp:site_url />
				[/attribute]
			<txp:if_variable name="has_articles" value="">
				[<txp:if_variable name="has_articles" value="">: false]
				<txp:category title="1" />
				<txp:article_custom limit="40" section='<txp:section />'  category='<txp:category />' wraptag="ul" class="listing" break="li" >
					[attribute 'section']
					<txp:section />
					[/attribute]
					[attribute 'category']
					<txp:category />
					[/attribute]
					[SQL (0.00056004524231): select *, unix_timestamp(Posted) as uPosted, unix_timestamp(Expires) as uExpires, unix_timestamp(LastMod) as uLastMod from textpattern where 1=1 and Status = 4 and Posted <= now() and (now() <= Expires or Expires = '0000-00-00 00:00:00') and (Category1 IN ('projects') or Category2 IN ('projects')) and Section IN ('garden-projects') order by Posted desc limit 0, 40]
					[article 57]
					<txp:permlink>
						<txp:title />
					</txp:permlink>
					[article 55]
					<txp:permlink>
						<txp:title />
					</txp:permlink>
					[article 54]
					<txp:permlink>
						<txp:title />
					</txp:permlink>
					[article 53]
					<txp:permlink>
						<txp:title />
					</txp:permlink>
					[article 52]
					<txp:permlink>
						<txp:title />
					</txp:permlink>
					[article 43]
					<txp:permlink>
						<txp:title />
					</txp:permlink>
					[article 41]
					<txp:permlink>
						<txp:title />
					</txp:permlink>
					[article 39]
					<txp:permlink>
						<txp:title />
					</txp:permlink>
					[article 10]
					<txp:permlink>
						<txp:title />
					</txp:permlink>
					[article 9]
					<txp:permlink>
						<txp:title />
					</txp:permlink>
				</txp:article_custom>
			</txp:if_variable>
			<txp:variable name="has_articles" value='<txp:article_custom section=''<txp:section />'' category=''<txp:category />'' limit="1" />' />
				[attribute 'value']
				<txp:article_custom section='<txp:section />' category='<txp:category />' limit="1" />
					[attribute 'section']
					<txp:section />
					[/attribute]
					[attribute 'category']
					<txp:category />
					[/attribute]
					[SQL (0.00100898742676): select *, unix_timestamp(Posted) as uPosted, unix_timestamp(Expires) as uExpires, unix_timestamp(LastMod) as uLastMod from textpattern where 1=1 and Status = 4 and Posted <= now() and (now() <= Expires or Expires = '0000-00-00 00:00:00') and (Category1 IN ('published-articles') or Category2 IN ('published-articles')) and Section IN ('garden-projects') order by Posted desc limit 0, 1]
				[/attribute]
			<txp:if_variable name="has_articles" value="">
				[<txp:if_variable name="has_articles" value="">: true]
			</txp:if_variable>
			<txp:variable name="has_articles" value='<txp:article_custom section=''<txp:section />'' category=''<txp:category />'' limit="1" />' />
				[attribute 'value']
				<txp:article_custom section='<txp:section />' category='<txp:category />' limit="1" />
					[attribute 'section']
					<txp:section />
					[/attribute]
					[attribute 'category']
					<txp:category />
					[/attribute]
					[SQL (0.000571012496948): select *, unix_timestamp(Posted) as uPosted, unix_timestamp(Expires) as uExpires, unix_timestamp(LastMod) as uLastMod from textpattern where 1=1 and Status = 4 and Posted <= now() and (now() <= Expires or Expires = '0000-00-00 00:00:00') and (Category1 IN ('resource') or Category2 IN ('resource')) and Section IN ('garden-projects') order by Posted desc limit 0, 1]
				[/attribute]
			<txp:if_variable name="has_articles" value="">
				[<txp:if_variable name="has_articles" value="">: true]
			</txp:if_variable>
			<txp:variable name="has_articles" value='<txp:article_custom section=''<txp:section />'' category=''<txp:category />'' limit="1" />' />
				[attribute 'value']
				<txp:article_custom section='<txp:section />' category='<txp:category />' limit="1" />
					[attribute 'section']
					<txp:section />
					[/attribute]
					[attribute 'category']
					<txp:category />
					[/attribute]
					[SQL (0.000572919845581): select *, unix_timestamp(Posted) as uPosted, unix_timestamp(Expires) as uExpires, unix_timestamp(LastMod) as uLastMod from textpattern where 1=1 and Status = 4 and Posted <= now() and (now() <= Expires or Expires = '0000-00-00 00:00:00') and (Category1 IN ('service') or Category2 IN ('service')) and Section IN ('garden-projects') order by Posted desc limit 0, 1]
				[/attribute]
			<txp:if_variable name="has_articles" value="">
				[<txp:if_variable name="has_articles" value="">: true]
			</txp:if_variable>
			<txp:variable name="has_articles" value='<txp:article_custom section=''<txp:section />'' category=''<txp:category />'' limit="1" />' />
				[attribute 'value']
				<txp:article_custom section='<txp:section />' category='<txp:category />' limit="1" />
					[attribute 'section']
					<txp:section />
					[/attribute]
					[attribute 'category']
					<txp:category />
					[/attribute]
					[SQL (0.000294923782349): select *, unix_timestamp(Posted) as uPosted, unix_timestamp(Expires) as uExpires, unix_timestamp(LastMod) as uLastMod from textpattern where 1=1 and Status = 4 and Posted <= now() and (now() <= Expires or Expires = '0000-00-00 00:00:00') and (Category1 IN ('testimonials') or Category2 IN ('testimonials')) and Section IN ('garden-projects') order by Posted desc limit 0, 1]
					[article 59]
					[Form: default]
					<txp:if_individual_article>
						[<txp:if_individual_article>: false]
						<txp:permlink>
							<txp:title />
						</txp:permlink>
					</txp:if_individual_article>
					<txp:posted />
					<txp:body />
					<txp:author />
					<txp:category1 title="1" link="1" />
					<txp:category2 title="1" link="1" />
					<txp:comments_invite wraptag="p" />
					<txp:site_url />
				[/attribute]
			<txp:if_variable name="has_articles" value="">
				[<txp:if_variable name="has_articles" value="">: false]
				<txp:category title="1" />
				<txp:article_custom limit="40" section='<txp:section />'  category='<txp:category />' wraptag="ul" class="listing" break="li" >
					[attribute 'section']
					<txp:section />
					[/attribute]
					[attribute 'category']
					<txp:category />
					[/attribute]
					[SQL (0.000468969345093): select *, unix_timestamp(Posted) as uPosted, unix_timestamp(Expires) as uExpires, unix_timestamp(LastMod) as uLastMod from textpattern where 1=1 and Status = 4 and Posted <= now() and (now() <= Expires or Expires = '0000-00-00 00:00:00') and (Category1 IN ('testimonials') or Category2 IN ('testimonials')) and Section IN ('garden-projects') order by Posted desc limit 0, 40]
					[article 59]
					<txp:permlink>
						<txp:title />
					</txp:permlink>
					[article 58]
					<txp:permlink>
						<txp:title />
					</txp:permlink>
					[article 56]
					<txp:permlink>
						<txp:title />
					</txp:permlink>
					[article 45]
					<txp:permlink>
						<txp:title />
					</txp:permlink>
					[article 27]
					<txp:permlink>
						<txp:title />
					</txp:permlink>
					[article 26]
					<txp:permlink>
						<txp:title />
					</txp:permlink>
					[article 25]
					<txp:permlink>
						<txp:title />
					</txp:permlink>
					[article 24]
					<txp:permlink>
						<txp:title />
					</txp:permlink>
					[article 23]
					<txp:permlink>
						<txp:title />
					</txp:permlink>
					[article 22]
					<txp:permlink>
						<txp:title />
					</txp:permlink>
				</txp:article_custom>
			</txp:if_variable>
		</txp:category_list>
		<txp:output_form form="buttons_socialMedia" />
			[SQL (0.000109910964966): select Form from txp_form where name='buttons_socialMedia']
			[Form: buttons_socialMedia]
			<txp:output_form form="button_email" />
				[SQL (8.01086425781E-5): select Form from txp_form where name='button_email']
				[Form: button_email]
			<txp:output_form form="button_twitter" />
				[SQL (8.51154327393E-5): select Form from txp_form where name='button_twitter']
				[Form: button_twitter]
			<txp:output_form form="button_linkedin" />
				[SQL (7.79628753662E-5): select Form from txp_form where name='button_linkedin']
				[Form: button_linkedin]
			<txp:output_form form="button_rss" />
				[SQL (7.79628753662E-5): select Form from txp_form where name='button_rss']
				[Form: button_rss]
</txp:if_article_list>
<txp:output_form form="footer" />
	[SQL (9.89437103271E-5): select Form from txp_form where name='footer']
	[Form: footer]
	<txp:php>
	</txp:php>
	<txp:site_name />
	<txp:output_form form="javascript_googleAnalytics" />
		[SQL (8.70227813721E-5): select Form from txp_form where name='javascript_googleAnalytics']
		[Form: javascript_googleAnalytics]
[ ~~~ secondpass ~~~ ]
 -->

Offline

#8 2012-03-16 21:11:16

els
Moderator
From: The Netherlands
Registered: 2004-06-06
Posts: 7,458

Re: txp:article_custom limit problems

If I’m not mistaken it’s about categories ‘projects’ and ‘testimonials’, right? This is really strange… If you are absolutely sure that both categories have more than 10 articles that
  1. are in section ‘garden-projects’
  2. are live
  3. have a posted date in the past
  4. are not expired

then I’m clueless… I don’t see anything wrong with the article_custom query. Just one – desperate – guess: are you using custom fields, and if so, how are they named?

Offline

#9 2012-03-16 23:58:50

decoderltd
Member
From: London
Registered: 2006-06-20
Posts: 248
Website

Re: txp:article_custom limit problems

Hi Els,

Many thanks for looking at the tag trace. It’s a yes on the first three points but will check with the client about point 4, they may have set expiry dates unwittingly…

Offline

#10 2012-03-18 23:16:43

decoderltd
Member
From: London
Registered: 2006-06-20
Posts: 248
Website

Re: txp:article_custom limit problems

Hi Els,

This is embrassing! There were 17 articles but when I explained to the client about the 10 article default limit they went and expired the extra 7 leaving just 10. Understandable, it’s just they forgot to tell me.

Anyway, everything is now working fine. Thank you for all your help and apologies for the false alarm.

Offline

#11 2012-03-18 23:23:43

els
Moderator
From: The Netherlands
Registered: 2004-06-06
Posts: 7,458

Re: txp:article_custom limit problems

No problem, I’m glad it’s solved!

Offline

Board footer

Powered by FluxBB