Go to main content

Textpattern CMS support forum

You are not logged in. Register | Login | Help

#1 2007-09-12 14:58:11

quinceginger
Member
From: Romania
Registered: 2006-08-21
Posts: 29

<txp:comments /> doesn't do the job

Hello,

The <txp:comment /> tag on my site (www.misesromania.org) does not seem to work.

The diagnostics are ok

Here are the debugging messages for two pages:

tag_error <txp:comments/> -> Textpattern Warning: Unknown column ‘027a’ in ‘order clause’
select *, unix_timestamp(posted) as time from txp_discuss where parentid=462 and visible=1 order by 027a on line 84

tag_error <txp:comments/> -> Textpattern Warning: Unknown column ‘027a’ in ‘order clause’
select *, unix_timestamp(posted) as time from txp_discuss where parentid=462 and visible=

———————————

Notice: Undefined variable: out in /home/misesrom/public_html/textpattern/lib/txplib_misc.php on line 321

tag_error <txp:comments/> -> Textpattern Warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘’ at line 1
select *, unix_timestamp(posted) as time from txp_discuss where parentid=464 and visible=1 order by
textpattern/lib/txplib_db.php:222 startRows() on line 84

textpattern/lib/txplib_db.php:84 trigger_error()
textpattern/lib/txplib_db.php:284 safe_query()
textpattern/lib/txplib_db.php:222 startRows()
textpattern/publish/taghandlers.php:1545 safe_rows_start()
textpattern/publish.php:963 comments()
processTags()
textpattern/publish.php:922 preg_replace_callback()
textpattern/lib/txplib_misc.php:1383 parse()
textpattern/publish.php:785 parse_form()
textpattern/publish.php:808 doArticle()

tag_error <txp:comments/> -> Textpattern Warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘’ at line 1
select *, unix_timestamp(posted) as time from txp_discuss where parentid=464 and visible=1 order by
textpattern/lib/txplib_db.php:222 startRows() on line 84

textpattern/lib/txplib_db.php:84 trigger_error()
textpattern/lib/txplib_db.php:284 safe_query()
textpattern/lib/txplib_db.php:222 startRows()
textpattern/publish/taghandlers.php:1545 safe_rows_start()
textpattern/publish.php:963 comments()
processTags()
textpattern/publish.php:922 preg_replace_callback()
textpattern/publish/taghandlers.php:2290 parse()
textpattern/publish.php:963 if_comments_allowed()
processTags()

Any ideas? Thanks very much!

Offline

#2 2007-09-12 15:01:04

ruud
Developer Emeritus
From: a galaxy far far away
Registered: 2006-06-04
Posts: 5,068
Website

Re: <txp:comments /> doesn't do the job

Check your tag trace
You appear to have an attribute sort="027a" (which is incorrect) set in the <txp:comments /> tag.

Offline

#3 2007-09-12 21:06:20

quinceginger
Member
From: Romania
Registered: 2006-08-21
Posts: 29

Re: <txp:comments /> doesn't do the job

Here’s the seemingly relevant part of the tag trace:

[SQL (0,000058): select Form from txp_form where name=‘comments_display’] [Form: comments_display] <txp:if_comments_preview> [<txp:if_comments_preview>: false] </txp:if_comments_preview> <txp:if_comments_allowed> [<txp:if_comments_allowed>: true] <txp:comments/> [SQL (0,000060): select *, unix_timestamp(posted) as time from txp_discuss where parentid=420 and visible=1 order by ] <txp:comments_form/> [SQL (0,000058): select ip from txp_discuss_ipban where `ip` = ’91.123.7.6’ limit 1] [SQL (0,000058): select Form from txp_form where `name` = ‘comment_form’ limit 1] <txp:comments_error wraptag=“ul” break=“li” /> <txp:comments_error wraptag=“p” /> </txp:if_comments_allowed>

Anything suspect?

Thanks.

Last edited by quinceginger (2007-09-12 21:09:34)

Offline

#4 2007-09-12 22:01:56

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

Re: <txp:comments /> doesn't do the job

quinceginger wrote:

tag_error <txp:comments/> ->  Textpattern Warning: Unknown column '027a' in 'order clause'
select *, unix_timestamp(posted) as time from txp_discuss where parentid=462 and visible=1 order by 027a  on line 84

As Ruud said:

You appear to have an attribute sort="027a" (which is incorrect) set in the <txp:comments /> tag.

Last edited by els (2007-09-12 22:03:01)

Offline

#5 2007-09-13 20:29:30

quinceginger
Member
From: Romania
Registered: 2006-08-21
Posts: 29

Re: <txp:comments /> doesn't do the job

Well, I use to order the sidebar titles with the help of custom_9 field, like this:

<txp:article_custom limit=99999 carte="" sortby="custom_9" sortdir="asc" section="articol" form="autor_lista" />

I am aware of the deprecated way I use to sort, but the sort="custom_9 asc" sintax does not work.

It happens that “027a” is the content of the custom_9 field for article id=462

However, in my opinion, it has nothing to do with <txp:comments />. The problem persists even in the case of articles with an empty custom_9 field

Here’s my comments_display form:

<txp:if_comments_preview>
<h3>Previzualizare:</h3>
<txp:comments_preview />
</txp:if_comments_preview>

<txp:if_comments_allowed>
<h2>Comentarii</h2>
<txp:comments />

<txp:comments_form />
<txp:else />
</txp:if_comments_allowed>

p. Any clue?

Offline

#6 2007-09-13 21:12:20

quinceginger
Member
From: Romania
Registered: 2006-08-21
Posts: 29

Re: <txp:comments /> doesn't do the job

For more relevance, here’s an entire tag trace for an article that has one comment:

Many thanks!

<!-- txp tag trace: 
[SQL (0,000071): select name from txp_lang where lang='ro-ro' limit 1]
[SQL (0,000657): select name, data from txp_lang where lang='ro-ro' AND ( event='public' OR event='common')]
[SQL (0,000242): select name, code, version from txp_plugin where status = 1]
[SQL (0,000073): select ID,Section from textpattern where ID = 464 and Status >= 4 limit 1]
[SQL (0,000052): select ID,Section from textpattern where ID = 464 and Status >= 4 limit 1]
[SQL (0,000079): select * from txp_section where name = 'blog' limit 1]
[SQL (0,000186): select *, unix_timestamp(Posted) as uPosted from textpattern where ID=464 and Status = 4]
[articol 464]
[SQL (0,000449): select ID, Title, url_title, unix_timestamp(Posted) as uposted
			from textpattern where Posted > '2007-08-25 16:16:28' and Section = 'blog' and Status=4 and Posted < now() order by Posted asc limit 1]
[SQL (0,000436): select ID, Title, url_title, unix_timestamp(Posted) as uposted
			from textpattern where Posted < '2007-08-25 16:16:28' and Section = 'blog' and Status=4 and Posted < now() order by Posted desc limit 1]
[SQL (0,000054): select host from txp_log where ip='91.123.7.6' limit 1]
[SQL (0,000181): select ID from textpattern where ID='464' and Status IN ('4', '5') limit 1]
[SQL (0,000161): select ID as thisid, Section as section, Title as title, url_title, unix_timestamp(Posted) as posted from textpattern where ID = 464]
[SQL (0,000053): select user_html from txp_page where name='default']
[Pagina: default]
<txp:output_form form="head" />
	[SQL (0,000052): select Form from txp_form where name='head']
	[Form: head]
	<txp:page_title/>
	<txp:custom_field name="autor" />
	<txp:css/>
	<txp:feed_link flavor="rss" format="link" label="RSS" />
	<txp:link_feed_link flavor="rss" format="link" label="RSS links" />
<txp:output_form form="header" />
	[SQL (0,000057): select Form from txp_form where name='header']
	[Form: header]
	<txp:link_to_home>
		<txp:sitename/>
	</txp:link_to_home>
	<txp:ako_nav name="english,cărţi,articole,opp,blog,seminarii,tipar,linkuri,despre noi" url="/english,/cuprins,/articol,/publicatie,/blog,/seminarii,/tipar,/linkuri,/desprenoi" headlvl="1" headon="0" divon="0" classtag="1" />
<txp:if_section name="cuprins">
	[<txp:if_section name="cuprins">: false]
</txp:if_section>
<txp:if_section name="capitol,articol">
	[<txp:if_section name="capitol,articol">: false]
</txp:if_section>
<txp:if_section name="publicatie">
	[<txp:if_section name="publicatie">: false]
</txp:if_section>
<txp:if_section name="blog">
	[<txp:if_section name="blog">: true]
	<txp:article limit="10" listform="blog_exc"/>
		[SQL (0,000508): select *, unix_timestamp(Posted) as uPosted from textpattern where ID = 464 and Status = 4 limit 1]
		[articol 464]
		[SQL (0,000058): select Form from txp_form where name='default']
		[Form: default]
		<txp:permlink>
			<txp:title/>
		</txp:permlink>
		<txp:output_form form="meta1form" />
			[SQL (0,000053): select Form from txp_form where name='meta1form']
			[Form: meta1form]
			<txp:custom_field name="autor" />
			<txp:output_form form="descriere_carte" />
				[SQL (0,000059): select Form from txp_form where name='descriere_carte']
				[Form: descriere_carte]
				<txp:if_custom_field name="carte">
					[<txp:if_custom_field name="carte">: false]
					<txp:custom_field name="subtitlu" />
				</txp:if_custom_field>
			<txp:output_form form="cuprins" />
				[SQL (0,000064): select Form from txp_form where name='cuprins']
				[Form: cuprins]
				<txp:if_section name="cuprins">
					[<txp:if_section name="cuprins">: false]
					<txp:if_article_category name="Actiunea-umana">
						[<txp:if_article_category name="Actiunea-umana">: false]
					</txp:if_article_category>
					<txp:if_article_category name="Etica-libertatii">
						[<txp:if_article_category name="Etica-libertatii">: false]
					</txp:if_article_category>
					<txp:if_article_category name="Birocratia">
						[<txp:if_article_category name="Birocratia">: false]
					</txp:if_article_category>
					<txp:if_article_category name="Jonathan-Gullible">
						[<txp:if_article_category name="Jonathan-Gullible">: false]
					</txp:if_article_category>
					<txp:if_article_category name="Politici-economice">
						[<txp:if_article_category name="Politici-economice">: false]
					</txp:if_article_category>
					<txp:if_article_category name="In-apararea-indezirabililor">
						[<txp:if_article_category name="In-apararea-indezirabililor">: false]
					</txp:if_article_category>
					<txp:if_article_category name="Socialismul">
						[<txp:if_article_category name="Socialismul">: false]
					</txp:if_article_category>
					<txp:if_article_category name="Teoria-socialismului-si-capitalismului">
						[<txp:if_article_category name="Teoria-socialismului-si-capitalismului">: false]
					</txp:if_article_category>
					<txp:if_article_category name="Ce-le-a-facut-Statul-banilor-nostri">
						[<txp:if_article_category name="Ce-le-a-facut-Statul-banilor-nostri">: false]
					</txp:if_article_category>
					<txp:if_article_category name="Ludwig-von-Mises-pe-intelesul-tuturor">
						[<txp:if_article_category name="Ludwig-von-Mises-pe-intelesul-tuturor">: false]
					</txp:if_article_category>
					<txp:if_article_category name="Calculul-economic">
						[<txp:if_article_category name="Calculul-economic">: false]
					</txp:if_article_category>
					<txp:if_article_category name="Profituri-si-pierderi">
						[<txp:if_article_category name="Profituri-si-pierderi">: false]
					</txp:if_article_category>
					<txp:if_article_category name="Scoala-austriaca">
						[<txp:if_article_category name="Scoala-austriaca">: false]
					</txp:if_article_category>
					<txp:if_article_category name="Manifestul-liberal">
						[<txp:if_article_category name="Manifestul-liberal">: false]
					</txp:if_article_category>
				</txp:if_section>
			<txp:output_form form="lang" />
				[SQL (0,000066): select Form from txp_form where name='lang']
				[Form: lang]
				<txp:if_custom_field name="ro-en">
					[<txp:if_custom_field name="ro-en">: false]
				</txp:if_custom_field>
			<txp:rss_article_edit>
			</txp:rss_article_edit>
		<txp:article_image class="image"/>
		<txp:body/>
		<txp:output_form form="metaform" />
			[SQL (0,000052): select Form from txp_form where name='metaform']
			[Form: metaform]
			<txp:output_form form="cuprins" />
				[Form: cuprins]
				<txp:if_section name="cuprins">
					[<txp:if_section name="cuprins">: false]
					<txp:if_article_category name="Actiunea-umana">
						[<txp:if_article_category name="Actiunea-umana">: false]
					</txp:if_article_category>
					<txp:if_article_category name="Etica-libertatii">
						[<txp:if_article_category name="Etica-libertatii">: false]
					</txp:if_article_category>
					<txp:if_article_category name="Birocratia">
						[<txp:if_article_category name="Birocratia">: false]
					</txp:if_article_category>
					<txp:if_article_category name="Jonathan-Gullible">
						[<txp:if_article_category name="Jonathan-Gullible">: false]
					</txp:if_article_category>
					<txp:if_article_category name="Politici-economice">
						[<txp:if_article_category name="Politici-economice">: false]
					</txp:if_article_category>
					<txp:if_article_category name="In-apararea-indezirabililor">
						[<txp:if_article_category name="In-apararea-indezirabililor">: false]
					</txp:if_article_category>
					<txp:if_article_category name="Socialismul">
						[<txp:if_article_category name="Socialismul">: false]
					</txp:if_article_category>
					<txp:if_article_category name="Teoria-socialismului-si-capitalismului">
						[<txp:if_article_category name="Teoria-socialismului-si-capitalismului">: false]
					</txp:if_article_category>
					<txp:if_article_category name="Ce-le-a-facut-Statul-banilor-nostri">
						[<txp:if_article_category name="Ce-le-a-facut-Statul-banilor-nostri">: false]
					</txp:if_article_category>
					<txp:if_article_category name="Ludwig-von-Mises-pe-intelesul-tuturor">
						[<txp:if_article_category name="Ludwig-von-Mises-pe-intelesul-tuturor">: false]
					</txp:if_article_category>
					<txp:if_article_category name="Calculul-economic">
						[<txp:if_article_category name="Calculul-economic">: false]
					</txp:if_article_category>
					<txp:if_article_category name="Profituri-si-pierderi">
						[<txp:if_article_category name="Profituri-si-pierderi">: false]
					</txp:if_article_category>
					<txp:if_article_category name="Scoala-austriaca">
						[<txp:if_article_category name="Scoala-austriaca">: false]
					</txp:if_article_category>
					<txp:if_article_category name="Manifestul-liberal">
						[<txp:if_article_category name="Manifestul-liberal">: false]
					</txp:if_article_category>
				</txp:if_section>
			<txp:comments_invite/>
			<txp:if_article_section name="blog,eblog">
				[<txp:if_article_section name="blog,eblog">: true]
			</txp:if_article_section>
		[SQL (0,000058): select Form from txp_form where name='comments_display']
		[Form: comments_display]
		<txp:if_comments_preview>
			[<txp:if_comments_preview>: false]
		</txp:if_comments_preview>
		<txp:if_comments_allowed>
			[<txp:if_comments_allowed>: true]
			<txp:comments/>
				[SQL (0,000091): select *, unix_timestamp(posted) as time from txp_discuss where parentid=464 and visible=1 order by ]
			<txp:comments_form/>
				[SQL (0,000058): select ip from txp_discuss_ipban where `ip` = '91.123.7.6' limit 1]
				[SQL (0,000064): select Form from txp_form where `name` = 'comment_form' limit 1]
				<txp:comments_error wraptag="ul" break="li" />
				<txp:comments_error wraptag="p" />
		</txp:if_comments_allowed>
</txp:if_section>
<txp:if_article_list>
	[<txp:if_article_list>: false]
</txp:if_article_list>
<txp:output_form form="sidebar" />
	[SQL (0,000060): select Form from txp_form where name='sidebar']
	[Form: sidebar]
	<txp:output_form form="section_specific" />
		[SQL (0,000061): select Form from txp_form where name='section_specific']
		[Form: section_specific]
		<txp:if_section name="">
			[<txp:if_section name="">: false]
		</txp:if_section>
		<txp:if_section name="linkuri,contact">
			[<txp:if_section name="linkuri,contact">: false]
		</txp:if_section>
		<txp:if_section name="capitol">
			[<txp:if_section name="capitol">: false]
		</txp:if_section>
		<txp:if_section name="articol">
			[<txp:if_section name="articol">: false]
		</txp:if_section>
		<txp:if_section name="publicatie">
			[<txp:if_section name="publicatie">: false]
		</txp:if_section>
		<txp:if_section name="blog,eblog">
			[<txp:if_section name="blog,eblog">: true]
			<txp:article_custom limit=99999  

section="blog" form="daily_aut_art" />
				[SQL (0,001050): select *, unix_timestamp(Posted) as uPosted from textpattern where 1 and Status = 4 and Posted <= now() and Section = 'blog' order by Posted desc limit 0, 99999]
				[articol 465]
				[SQL (0,000056): select Form from txp_form where name='daily_aut_art']
				[Form: daily_aut_art]
				<txp:if_different>
					[<txp:if_different>: true]
					<txp:posted format="%d %B %Y" />
				</txp:if_different>
				<txp:custom_field name="autor" />
				<txp:permlink>
					<txp:title/>
				</txp:permlink>
				[articol 464]
				[Form: daily_aut_art]
				<txp:if_different>
					[<txp:if_different>: true]
					<txp:posted format="%d %B %Y" />
				</txp:if_different>
				<txp:custom_field name="autor" />
				<txp:permlink>
					<txp:title/>
				</txp:permlink>
				[articol 461]
				[Form: daily_aut_art]
				<txp:if_different>
					[<txp:if_different>: true]
					<txp:posted format="%d %B %Y" />
				</txp:if_different>
				<txp:custom_field name="autor" />
				<txp:permlink>
					<txp:title/>
				</txp:permlink>
				[articol 457]
				[Form: daily_aut_art]
				<txp:if_different>
					[<txp:if_different>: true]
					<txp:posted format="%d %B %Y" />
				</txp:if_different>
				<txp:custom_field name="autor" />
				<txp:permlink>
					<txp:title/>
				</txp:permlink>
				[articol 456]
				[Form: daily_aut_art]
				<txp:if_different>
					[<txp:if_different>: true]
					<txp:posted format="%d %B %Y" />
				</txp:if_different>
				<txp:custom_field name="autor" />
				<txp:permlink>
					<txp:title/>
				</txp:permlink>
				[articol 455]
				[Form: daily_aut_art]
				<txp:if_different>
					[<txp:if_different>: true]
					<txp:posted format="%d %B %Y" />
					[<txp:if_different>: false]
				</txp:if_different>
				<txp:custom_field name="autor" />
				<txp:permlink>
					<txp:title/>
				</txp:permlink>
				[articol 443]
				[Form: daily_aut_art]
				<txp:if_different>
					[<txp:if_different>: true]
					<txp:posted format="%d %B %Y" />
				</txp:if_different>
				<txp:custom_field name="autor" />
				<txp:permlink>
					<txp:title/>
				</txp:permlink>
				[articol 442]
				[Form: daily_aut_art]
				<txp:if_different>
					[<txp:if_different>: true]
					<txp:posted format="%d %B %Y" />
				</txp:if_different>
				<txp:custom_field name="autor" />
				<txp:permlink>
					<txp:title/>
				</txp:permlink>
				[articol 436]
				[Form: daily_aut_art]
				<txp:if_different>
					[<txp:if_different>: true]
					<txp:posted format="%d %B %Y" />
				</txp:if_different>
				<txp:custom_field name="autor" />
				<txp:permlink>
					<txp:title/>
				</txp:permlink>
		</txp:if_section>
		<txp:if_section name="seminarii">
			[<txp:if_section name="seminarii">: false]
		</txp:if_section>
		<txp:if_section name="tipar">
			[<txp:if_section name="tipar">: false]
		</txp:if_section>
		<txp:if_section name="desprenoi">
			[<txp:if_section name="desprenoi">: false]
		</txp:if_section>
		<txp:if_section name="cuprins">
			[<txp:if_section name="cuprins">: false]
		</txp:if_section>
		<txp:if_section name="english,links,econtact">
			[<txp:if_section name="english,links,econtact">: false]
		</txp:if_section>
		<txp:if_section name="tofc">
			[<txp:if_section name="tofc">: false]
		</txp:if_section>
		<txp:if_section name="books">
			[<txp:if_section name="books">: false]
		</txp:if_section>
		<txp:if_section name="articles">
			[<txp:if_section name="articles">: false]
		</txp:if_section>
		<txp:if_section name="periodical">
			[<txp:if_section name="periodical">: false]
		</txp:if_section>
		<txp:if_section name="seminars">
			[<txp:if_section name="seminars">: false]
		</txp:if_section>
		<txp:if_section name="printed">
			[<txp:if_section name="printed">: false]
		</txp:if_section>
		<txp:if_section name="aboutus">
			[<txp:if_section name="aboutus">: false]
		</txp:if_section>
	<txp:site_url/>
	<txp:category_list wraptag="ul" break="li" class="" />
		[SQL (0,000139): select name, title from txp_category where type = 'article' and name not in('default','root')  order by name ASC]
	<txp:recent_comments limit="10" break="li" wraptag="ul" class="" />
		[SQL (0,000065): select parentid, name, discussid from txp_discuss where visible = 1 order by posted desc limit 0,10]
		[SQL (0,000180): select *, ID as thisid, unix_timestamp(Posted) as posted from textpattern where ID = 464]
		[SQL (0,000422): select *, ID as thisid, unix_timestamp(Posted) as posted from textpattern where ID = 420]
	<txp:linklist wraptag="ul" break="li" class="" limit="10" sort="date desc" />
		[SQL (0,000093): select *, unix_timestamp(date) as uDate from txp_link where 1 order by date desc limit 10]
		[SQL (0,000049): select Form from txp_form where name='plainlinks']
		[Form: plainlinks]
		<txp:linkdesctitle/>
		[Form: plainlinks]
		<txp:linkdesctitle/>
		[Form: plainlinks]
		<txp:linkdesctitle/>
		[Form: plainlinks]
		<txp:linkdesctitle/>
		[Form: plainlinks]
		<txp:linkdesctitle/>
		[Form: plainlinks]
		<txp:linkdesctitle/>
		[Form: plainlinks]
		<txp:linkdesctitle/>
		[Form: plainlinks]
		<txp:linkdesctitle/>
		[Form: plainlinks]
		<txp:linkdesctitle/>
		[Form: plainlinks]
		<txp:linkdesctitle/>
	<txp:feed_link section="" label="RSS" flavor="rss" wraptag="li" />
	<txp:link_feed_link flavor="rss" label="Links RSS" wraptag="li" />
	<txp:feed_link section="" label="Atom" flavor="atom" wraptag="li" />
	<txp:article_custom id="407" form="titlu_link" />
		[SQL (0,000333): select *, unix_timestamp(Posted) as uPosted from textpattern where 1 and Status >= 4 and Posted <= now() and ID = '407' order by Posted desc limit 0, 10]
		[articol 407]
		[SQL (0,000053): select Form from txp_form where name='titlu_link']
		[Form: titlu_link]
		<txp:permlink>
			<txp:title/>
		</txp:permlink>
<txp:image id="11" class="mises" />
	[SQL (0,000100): select * from txp_image where id = 11 limit 1]
[ ~~~ secondpass ~~~ ]
 -->

Offline

#7 2007-09-13 22:33:29

ruud
Developer Emeritus
From: a galaxy far far away
Registered: 2006-06-04
Posts: 5,068
Website

Re: <txp:comments /> doesn't do the job

Please post your diagnostics.

Offline

#8 2007-09-13 23:16:51

quinceginger
Member
From: Romania
Registered: 2006-08-21
Posts: 29

Re: <txp:comments /> doesn't do the job

Here they are. Please note that I changed language from “ro” only for this purpose.

Many thanks!

Textpattern version: 4.0.5 (r2466)
Last Update: 2007-07-12 22:35:46/2007-08-11 06:10:19
Document root: /home/misesrom/public_html
$path_to_site: /home/misesrom/public_html
Textpattern path: /home/misesrom/public_html/textpattern
Permanent link mode: id_title
Temporary directory path: /home/misesrom/public_html/textpattern/tmp
Site URL: misesromania.org
PHP version: 5.1.6
Register globals: 1
GD Image Library: bundled (2.0.28 compatible); supported formats: GIF, JPG, PNG.
Server Local Time: 2007-09-13 19:13:29
MySQL: 4.1.21-standard-log
Locale: en_GB.UTF-8
Server: Apache/1.3.37 (Unix) mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4 FrontPage/5.0.2.2635.SR1.2 mod_ssl/2.8.28 OpenSSL/0.9.7a PHP-CGI/0.1b
PHP Server API: cgi
RFC 2616 headers:
Server OS: Linux 2.6.9-42.0.10.ELsmp
Active plugins: ako_nav-0.9.1, zem_contact_lang-4.0.3.02, zem_contact_reborn-4.0.3.16, zem_redirect-1.2, rss_article_edit-0.1, rss_admin_db_manager-4.3, ajw_nofeed-0.1m

Pre-flight check:
————————————
Site URL preference might be incorrect: misesromania.net
————————————

.htaccess file contents:
————————————
#DirectoryIndex index.php index.html

#Options +FollowSymLinks
#Options -Indexes

<IfModule mod_rewrite.c> RewriteEngine On #RewriteBase /relative/web/path/

RewriteCond %{REQUEST_FILENAME} -f [OR] RewriteCond %{REQUEST_FILENAME} -d RewriteRule ^(.+) – [PT,L]

RewriteRule ^(.*) index.php
</IfModule>

#php_value register_globals 0
————————————

Offline

#9 2007-09-20 13:05:52

Mary
Sock Enthusiast
Registered: 2004-06-27
Posts: 6,236

Re: <txp:comments /> doesn't do the job

This would be why:

<txp:comments/>
[SQL (0,000091): select *, unix_timestamp(posted) as time from txp_discuss where parentid=464 and visible=1 order by ]

The command is incomplete, so it would cause an error and not return anything.

Do any of your custom fields happen to be named “sort”?

Offline

#10 2007-09-20 17:10:18

quinceginger
Member
From: Romania
Registered: 2006-08-21
Posts: 29

Re: <txp:comments /> doesn't do the job

Got it! Of course that must be it: custom_9 is titled ‘sort’

Mary, thanks a lot! I am sure it’s going to work if I change it. It’s a lesson for the future not to use such key words for labeling.

I’ll try to change it and post back.

Offline

#11 2007-09-20 19:59:31

quinceginger
Member
From: Romania
Registered: 2006-08-21
Posts: 29

Re: <txp:comments /> doesn't do the job

And of course it works.

Thank you again for pointing this important detail Mary!

Offline

Board footer

Powered by FluxBB